Nortel Networks FP1 : User's Manual : Page 53

How this guide is organized
This document provides an overview of Database Module architecture, including data replication an...
- This document provides an overview of Database Module architecture, including data replication an...
- • Configuring the Oracle Enterprise Manger to perform backups, observer accounts and email notifi...
Required hardware, software, tools and utilities, and OAM&P strategy are explained later in this ...
Other Database Module concepts and tasks explained are
- Other Database Module concepts and tasks explained are
- • Upgrades: Maintenance upgrades required between major product releases. See
  - • Upgrades: Maintenance upgrades required between major product releases. See
    - • Upgrades: Maintenance upgrades required between major product releases. See
  - • Performance management: Where to observe logs and alarms and how database failover works. See
    - • Performance management: Where to observe logs and alarms and how database failover works. See

Architecture

Data replication

ATTENTION
- Database Module deployment creates or updates both replicated objects (database tables) and non-r...

The Database Module replication environment has the states of operation identified in

The Database Module replication environment has the states of operation identified in

Table1 Database operational states

Data transfer

Oracle Enterprise Manager configuration

Database administration

Fault management

Security

MCP hardware

Note: Minimal configurations use a single database, and thus only one server is required.

Note: Minimal configurations use a single database, and thus only one server is required.

Table2 Upgrade task flows

Tools and utilities

Database Module updates

CAUTION
- When the database is replaced by a backup, any newly provisioned subscriber or configuration data...
- Contact your next level of support for assistance prior to reverting the database to a previous v...

Undeploying a database

Fault management

CAUTION
- Nortel Networks recommends that the primary and secondary databases and external backup media be ...

Task flows

Table3 Performance management task flows

“Monitoring registration deletions” on page31
- “Monitoring registration deletions” on page31

Tools and utilities

Database failover

ATTENTION
- A minor alarm is raised when applications are connected to the primary database and the connectio...

For information about database backup and recovery, resynchronization, replication, and optimizat...

Database monitoring from the Oracle Enterprise Manager Console

Monitoring events

Table4 Database events

Monitor replication jobs

CAUTION
- After a restart, there is a higher probability that replication jobs may be broken. Therefore, be...

Monitoring replication

Monitoring registration deletions

Alarm monitoring

Alert log and trace file monitoring

ATTENTION
- Nortel Networks recommends that you monitor database alert logs and trace files periodically to e...

Monitoring alert logs and trace files

Monitoring disk usage

Reports

Table5 Performance management task flows

The Oracle Monitor component

ATTENTION
- The Oracle Monitor component does not monitor the Database Module in real time. For details about...

Information regarding the Oracle Monitor component appears in the

The

Configuration management

Table6 Configuration management tasks

Tools and utilities

OEM Console login

ATTENTION
- Only database administrators and system administrators have access to the Database Administration...

Logging in to the OEM Console

Configuration tasks

Application database connection configuration

Table7 Application database configuration properties

Querying or modifying Oracle Monitor configuration properties

Accounting management

Performance management

Security and Administration

Table8 Database Module administrator and user roles

For Database Module login and user configuration procedures, see

For more information about network and Database Module security, see

For more information about network and Database Module security, see

Administration

Table9 Administration tasks

Tools and utilities

Database backups

CAUTION
- Using Recovery Manager (RMAN), archive logs can fill up available disk space if backups are not d...
- It is recommended that the Export/Import method be used to backup and restore data.

Table10

Table10
- Table10

Table10 Comparing backup and recovery methods

Backups should be scheduled during off-peak hours. The default time is 2:00 a.m.

If a backup fails, the log files display the probable cause of the failure and any available expl...

If a backup fails, the log files display the probable cause of the failure and any available expl...

CAUTION
- To avoid risk of data loss, always backup data to external media and use consistent and regular b...

This section contains the following backup procedures:

Oracle Enterprise Manager backups

Backing up parameter files

Backup job setup

Backup job setup

CAUTION
- Only trained personnel should perform the following task.

Use the following backup procedure to set up daily backup jobs.

At the primary database server command line

At the primary database server command line

For login instructions, see

Creating a backup job

Creating a backup job

CAUTION
- Only trained personnel should perform the following task.

Set general backup properties

Set general backup properties

Export
- Export

Note: The Export backup method is recommended. See “Database backups” on page71
- Note: The
  - Note: The

Alternatively, use the following backup methods:

4 Under

4 Under

5 In the

Set backup task properties

Define backup parameters

If
- If
Do
- Do

10 In the

10 In the

If
- If
Do
- Do

Schedule backup frequency

If
- If
Do
- Do

Note: For

Note: For

13 Choose a default start time during off-peak hours. The default time is 2:00 a.m.

13 Choose a default start time during off-peak hours. The default time is 2:00 a.m.

Set backup notifications

Submit and add the backup job to the library

If
- If
Do
- Do

Modifying a scheduled backup job

Database recovery

CAUTION
- Only trained personnel should perform the following task.

Use the following procedure to restore other files.

On the primary database server

On the primary database server

ATTENTION
- If you use the Import/Export backup and recovery method you can restore the databases by importin...

Restoring

Restoring

CAUTION
- Only trained personnel should perform the following task.

On the database server with the damaged files

On the database server with the damaged files

If
- If
Do
- Do

Restoring control files

Manage replication transaction errors

ATTENTION
- Nortel Networks recommends that you monitor error transactions once every 12 hours from the OEM C...

Resolving replication errors

If
- If
Do
- Do

Resynchronization

CAUTION
- Resynchronizing databases is a lengthy process. Allow 1-2 hours to complete the operation.
- Only trained personnel should perform the following task.

In the unlikely event that changes to the primary database are not propagated to the secondary da...

In a telnet window

In a telnet window

Disk space management

CAUTION
- Only trained personnel should perform the following task.

In a telnet window

In a telnet window

The information contained in this document is the property of Nortel Networks. Except as specific...

The information contained in this document is the property of Nortel Networks. Except as specific...

Information is subject to change without notice. Nortel Networks reserves the right to make chang...

*Nortel Networks, the Nortel Networks logo, the Globemark, UNIStim, Oracle, MCP, Nortel, Northern...

Configuration management 53

Nortel Networks Confidential

10 Select the Schedule tab.

The Edit Administrator Preferences > Schedule tab opens.

11 Click the Email icon and select all days of the week and all hours

of the day as follows:

Click the top left-hand cell of the grid and drag the mouse pointer

to the bottom right-hand cell.