Restore Control Files
You can restore the control files that stores the physical structure of the database. Before you restore, you must locate the file. When you locate the files, ensure that the database is in the Open state.
Follow these steps:
- Log in to the computer where you want to restore the control files.
- Locate the control files using the following command:
- Change the state of the database to nomount or shutdown before you restore the control files.
- Log in to the Arcserve UDP Console.
- Restore the Control file using the Restore Wizard. For more information on the restore process, see How to Restore From a Recovery Point.
- Log in to the destination computer.
- Navigate to the specific folders and verify that the control files are restored.
- Mount the database to begin the database recovery:
- Enter the RECOVER command with the USING BACKUP CONTROLFILE clause.
- The database recovery process begins.
- (Optional) Specify the UNTIL CANCEL clause to perform an incomplete recovery.
- Apply the prompted archived logs.
- Note: If the required archived log is missing, then it implies that a necessary redo record is located in the online redo logs. It occurs because unarchived changes are located in the online logs when the instance failed. You can specify the full path of an online redo log file and press Enter (you may have to try this a few times until you find the correct log).
- Enter the following command to return the control file information about the redo log of a database:
- (Optional) Enter the following command to see the names of all of the member of a group:
- Example: After applying the prompted archived logs, you may see the following messages:
- Specify the full path of the online redo log file and press Enter.
- Example: E:\app\Administrator\oradata\orcl\redo01.log
- Note: You have to specify the full path multiple times until you get the correct log.
- The following messages are displayed:
- Open the database with the RESETLOGS clause after completing the recovery process.
SQL> SHOW PARAMETER CONTROL FILES;
SQL> STARTUP NOMOUNT;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
SQL>SELECT * FROM V$LOG;
SQL>SELECT * FROM V$LOGFILE;
ORA-00279: change 55636 generated at 24/06/2014 16:59:47 needed for thread 1
ORA-00289: suggestion e:\app\Administrator\flash_recovery_area\orcl\ARCHIVELOG\2014_06_24\ O1_MF_1_2_9TKXGGG2_.ARC
ORA-00280: change 55636 for thread 1 is in sequence #24
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Log applied
Media recovery complete
SQL> ALTER DATABASE OPEN RESETLOGS;
The lost control files are recovered.