The recovery of the damaged datafiles and the archive logs includes the following steps:
1 |
Connect to the database with SYSDBA privileges by using the SQL*Plus utility. |
3 |
5 |
After the restoration is complete, use SQL*Plus to perform the recovery manually by issuing the following command for every tablespace that needs recovering: |
6 |
Alter the recovered tablespaces online with the following SQL*Plus command: |
You can recover a Control File using one of the following options:
• |
Restoring a Lost Copy of a Multiplexed Control File: Use this procedure to recover a database if a permanent media failure has damaged one or more Control Files of a database, and at least one Control File has not been damaged by the media failure. For more information, see Restore Lost Copy of a Multiplexed Control File in the Oracle Database Backup and Recovery Advanced User’s Guide or to Responding to the Loss of a Subset of the Current Control Files in the Oracle Database Backup and Recovery User’s Guide for Oracle 11g. |
• |
Restoring a Control File from Backup After Loss of All Current Control Files: Use this procedure to restore a Backup Control File if a permanent media failure has damaged all Control Files of a database and you have a backup of the Control File. |
You cannot mount and open the database until the Control File is accessible.
The plug-in saves a copy of the snapshot of the Control File to the Control File Save Filename (Full Path) specified on the Add, or Edit, Oracle Database dialog box. You can copy the Control File from this location if you lose all current Control Files. If the snapshot is not available in the Control File Save Filename (Full Path), you can restore it from the backup by performing the following steps:
2 |
Connect to the database with SYSDBA privileges by using the SQL*Plus utility. |
6 |
To recover the database to a point equivalent to the current SCN stored in the datafiles, perform the recovery by using the USING BACKUP CONTROLFILE command. |
7 |
After recovery is finished, open the database with the RESETLOGS option. |
Review the following topics regarding RMAN recovery:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center