88 Security and Administration | Nortel Networks Confidential | ||
|
|
|
|
|
|
|
|
If | Do |
|
|
Point in Time Recovery | 1. Execute the following command: |
| cd /IMS/imssipdb/data/db_schema/backup |
| incomplete_restore.sh <db_type> <media_type> |
| <TIME: |
| (for example, |
| 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> |
|
|
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
1Login as oracle.
2Change to the directory containing the imsdb1 control files as follows:
cd /opt/app/oracle/admin/imsdb1/pfile
3Open the initimsdb1.ora file in a text editor.
4Replace the following lines:
control_files=("/IMS/oradata/imsdb1/control01.ctl",
Copyright © 2003, Nortel Networks |