Nortel Networks FP1 Manuale Utente Scaricare il pdf (Pagina 88)

88 Security and Administration

Nortel Networks Confidential

Restoring control files

Use the following procedure to restore control files.

Note: Stop all IMS applications before performing this procedure.

The examples used in this procedure assume control02.ctl and

control03.ctl are damaged.

On the database server containing the damaged files

1 Login as oracle.

2 Change to the directory containing the imsdb1 control files as

follows:

cd /opt/app/oracle/admin/imsdb1/pfile

3 Open the initimsdb1.ora file in a text editor.

4 Replace the following lines:

control_files=("/IMS/oradata/imsdb1/control01.ctl",

Point in Time Recovery 1. Execute the following command:

cd /IMS/imssipdb/data/db_schema/backup

incomplete_restore.sh <db_type> <media_type>

<TIME: YYYY-MM-DD-mm-ss>

(for example, 2002-09-04:23:45:50)

2. Now that the PRIMARY database is restored to a point

in time, look at the alert_imsdb1.log file to find the

appropriate SCN.

The alert_imsdb1.log file is located in

/opt/app/oracle/admin/imsdb1/bdump/alert_imsdb1.log

3. Edit that file and search for RESETLOGS.

(a) If the message is, “RESETLOGS after complete

recovery through change xxx,” you have applied all the

changes in the database and successfully performed a

complete recovery. Recovery of the secondary database

is not needed and this procedure is complete.

(b) If the message is, “RESETLOGS after incomplete

recovery UNTIL CHANGE xxx,” you have performed an

incomplete recovery. Go to the next step to complete the

recovery.

4. Record the change number from the message and

enter the following commands:

cd /IMS/imssipdb/data/db_schema/backup

incomplete_restore.sh <db_type> <media_type> SCN

<scn_number>

If Do

1 2 ... 83 84 85 86 87 88 89 90 91 92 93 94 95 96

Nessun commento

Nortel Networks FP1 Manuale Utente Pagina 88