Nortel Networks Standard MCP 1.1 FP1 (02.02) manual Administration, Tasks

Page 70

70 Security and Administration	Nortel Networks Confidential

For more information about network and Database Module security, see MCP Basics.

Administration

Database Module administration consists of backup, recovery, resynchronization, and optimization.

Replication objects are grouped together to form a replication group. Administration of the Database Module replication process is performed through a replication group called IMSREPGROUP.

Tasks

Table 9 outlines Database Module Administration tasks.

Table 9 Administration tasks

Topic	Subtopic	Procedure

“Database backups”	Parameter files	“Backing up
		parameter files” on
		page 73
	“Oracle Enterprise	“Backup job setup”
	Manager backups”	on page 74
	New backup jobs	“Creating a backup
		job” on page 75
	Existing backup jobs	“Modifying a
		scheduled backup
		job” on page 82
“Database recovery”	Export	“Restoring exported
		backup files” on
		page 85
	RMAN	“Restoring RMAN
		backup files” on
		page 86
	Control files	“Restoring control
		files” on page 88
Replication	Errors	“Resolving
		replication errors” on
		page 89

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

Copyright © 2003, Nortel Networks

Image 70

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 FailoverTools and utilities MCP hardwareHardware Details Network interfaces and protocols SQL over JdbcOAM&P strategy Legal noteTask flows Upgrade task flows Topic Sub-topic ProcedureStrategy Offline migrationUpdating a Database Module Database Module updatesFrom 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 ManagerGenerating reports 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 tasks Topic Subtopic Procedure AdministrationTasks 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