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:
SQL> SHOW PARAMETER CONTROL FILES;
SQL> STARTUP NOMOUNT;
SQL> SHUTDOWN IMMEDIATE;
SQL> START MOUNT
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE
The database recovery process begins.
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
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).
SQL>SELECT * FROM V$LOG;
SQL>SELECT * FROM V$LOGFILE;
Example: After applying the prompted archived logs, you may see the following messages:
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}
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:
Log applied
Media recovery complete
SQL> ALTER DATABASE OPEN RESETLOGS;
The lost control files are recovered.
Copyright © 2015 Arcserve.
All rights reserved.
|
|