Nortel Networks Standard MCP 1.1 FP1 (02.02) manual Fault management, Database recovery

Page 8

8 Overview	Nortel Networks Confidential

Database recovery

Recovery restores a database to its original state after a failure. See “Database recovery” on page 84.

Manage replication transaction errors

The OEM Console provides tools for resolving replication errors, should they occur. Replication errors can result from a lack of available space in a table targeted for an update or other unresolved replication conflicts.

For additional information, see “Resolving replication errors” on page 89.

Resynchronization

Replicated databases should always be in synchronization. In the unlikely event that changes made to one database are not successfully propagated to the other, the two databases become out of synchronization and must be manually resynchronized. See “Resynchronization” on page 92.

Disk space management

Ascript called optimize_dbspace drops and recreates Database Module indexes to reduce disk space usage. See “Disk space management” on page 93.

Fault management

Use the OEM Console to monitor and respond to Database Module faults in the categories listed in this section. Note the recommended frequency for each task.

•Replication: Replication jobs ensure that the primary and secondary databases remain synchronized.

Therefore it is critical that you use the OEM Console to monitor replication jobs once every 24 hours to ensure the databases remain synchronized.

See “Monitor replication jobs” on page 27 and “Resolving replication errors” on page 89.

•Backups: Once backup jobs have been scheduled using the Oracle Enterprise Manager (OEM) Console, the system backs up the database at predefined periods and sends a status email to the operator.

It is recommended that you monitor backup status to ensure the backup was successful. See “Monitoring backups” on page 20.

NN10031-111 Standard MCP 1.1 FP1 (02.02) April 2003

Copyright © 2003, Nortel Networks

Image 8

Contents

MCP Database Module Page Overview How this guide is organized Architecture Database Module architecture normal operationData replication Database operational states Database states Description Oracle Enterprise Manager configuration Database administrationDatabase backups Data transferFault management Database recoveryManage replication transaction errors ResynchronizationSecurity FailoverHardware Details MCP hardwareTools and utilities Network interfaces and protocols SQL over JdbcOAM&P strategy Legal noteUpgrade task flows Topic Sub-topic Procedure StrategyTask flows Offline migrationFrom the System Management Console Database Module updatesUpdating a Database Module Reverting to a previous version of the database Undeploying a databasePage Fault management Monitoring Database failover Monitoring backups From the OEM ConsoleNortel Networks Confidential Fault management Fault management Nortel Networks Confidential Event monitoring Alert State Icon description Alert descriptionMonitoring events Database events Events Type Description Database events Events Type Description OEM Replication Administration Dbms jobs window Monitor replication jobsSelect Distributed Advanced Replication Administration Monitoring replicationNortel Networks Confidential Fault management Fault management Nortel Networks Confidential Monitoring registration deletions On the OEM consoleFault management Nortel Networks Confidential Nortel Networks Confidential Fault management Alarm monitoring Monitoring alarms$ORACLEBASE/admin/imsdb1/bdump Alert log and trace file monitoringMonitoring alert logs and trace files A telnet windowMonitoring disk usage At the Oracle Enterprise ManagerSelect the Report Definitions menu ReportsGenerating reports Select Create a Single Report for the Targets Selected Below Click View Report Recommended reportsPerformance management task flows Report Title Category DescriptionOracle Monitor component Oracle Monitor General Information Area GIA pane Configuration management tasks Topic Subtopic Procedure TasksConfiguration management Nortel Networks Confidential OEM Console login Logging in to the OEM ConsoleLaunch the Oracle Enterprise Manager Console web page opens Oracle Enterprise Manager Console login window opens Oracle Enterprise Manager Console login windowOracle Enterprise Manager Console Configuration tasks From the Configuration menu, select Manage Administrators Manage Administrator Accounts window Edit Administrator Preferences General window opensSelect the Notification tab and click Email Edit Administrator Preferences Schedule tab opens Edit Administrator Preferences Access tab opens Nortel Networks Confidential Configuration management Configuring a database observer account from the OEM Console Manage Administrator Accounts window opens. See onApplication database connection configuration Create Administrator Account window opensConfiguration management Nortel Networks Confidential From the System Management Console IMS Main and Backup Database tabs Page Database Base tab Oracle Server tabOracle Listener tab Page Accounting management Page Performance management Page Security and Administration How this chapter is organizedTasks AdministrationAdministration tasks Topic Subtopic Procedure Tools and utilities Security and Administration Nortel Networks Confidential Comparing backup and recovery methods Oracle Enterprise Manager backupsExport/Import method Rman method Backing up parameter filesAt the primary database server command line Backup job setupCreating a backup job Set general backup propertiesBackup type Frequency Export Weekday Level Level1backup Level0backupSet backup task properties Create Job Task pane opensDefine backup parameters Create Job Parameters pane opensCommand box, enter a command as appropriate Nameofbackup is the name of the backup file, Schedule backup frequencyMediatype is Disk or Tape Create Job Schedule pane opensSet backup notifications Create Job Access pane opensSubmit and add the backup job to the library Modifying a scheduled backup jobFrom the OEM Console Database recovery Page Restoring Rman backup files On the database server with the damaged filesCd /IMS/imssipdb/data/dbschema/util stopimsdb abort Cd /opt/app/oracle/admin/imsdb1/pfile Restoring control filesOn the database server containing the damaged files Controlfiles=/IMS/oradata/imsdb1/control01.ctlResolving replication errors Select Distributed Advanced Replication Administration Nortel Networks Confidential Security and Administration Resynchronization Resynchronizing databases Cd /IMS/imssipdb/data/dbschema/util Optimizing database disk usagePage MCP Database Module