Nortel Networks Standard MCP 1.1 FP1 (02.02) manual

Page 6

6 Overview

Nortel Networks Confidential

 

 

while the secondary database operates in a limited write state at all times.

Table 1 Database operational states

Database states

Description

 

 

Normal

Fully writable for applications. Inserts,

(Primary database)

updates, or deletions are permitted to the

 

primary database. The Oracle Server

 

continuously transfers changed data to the

 

secondary database.

Limited write (Secondary database)

Quiesced (maintenance mode)

Read only for applications with the exception of registrations (inserts, updates, or deletions).

In the unlikely event of failure of the primary database, applications failover to the secondary database. During failover, applications can read and have limited write access to the secondary database. The failover state continues only until the primary database returns to service.

Note: The secondary database operates in a limited write state for applications but is always fully writable for Oracle replication processes.

No writes are permitted to either database.

When the database is quiesced, applications can only query the database and cannot insert, update, or delete database records.

Replicated databases automatically enter this state whenever changes are being made to the replication environment, including modifying replication objects and synchronizing the two databases.

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

Copyright © 2003, Nortel Networks

Image 6 Contents
MCP Database Module Page Overview How this guide is organizedArchitecture Database Module architecture normal operationData replication Database operational states Database states Description Database backups Oracle Enterprise Manager configurationDatabase administration Data transferManage replication transaction errors Fault managementDatabase recovery ResynchronizationSecurity FailoverMCP hardware Tools and utilitiesHardware Details Network interfaces and protocols SQL over JdbcOAM&P strategy Legal noteTask flows Upgrade task flows Topic Sub-topic ProcedureStrategy Offline migrationDatabase Module updates Updating a Database ModuleFrom the System Management Console 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 alarmsMonitoring alert logs and trace files $ORACLEBASE/admin/imsdb1/bdumpAlert log and trace file monitoring A telnet windowMonitoring disk usage At the Oracle Enterprise ManagerReports Generating reportsSelect the Report Definitions menu 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 organizedAdministration Administration tasks Topic Subtopic ProcedureTasks Tools and utilities Security and Administration Nortel Networks Confidential Export/Import method Rman method Comparing backup and recovery methodsOracle Enterprise Manager backups 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 Mediatype is Disk or Tape Nameofbackup is the name of the backup file,Schedule backup frequency 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 On the database server containing the damaged files Cd /opt/app/oracle/admin/imsdb1/pfileRestoring control 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