Contents
What is control file if control file is missing how you can recover?
If all control files have been lost in a permanent media failure, but all online redo log members remain intact, then you can recover the database after creating a new control file. You are not required to open the database with the RESETLOGS option after the recovery.
How do I restore an old RMAN backup?
Start RMAN and connect to the target database. Run the STARTUP FORCE NOMOUNT command. Run the SET DBID command to distinguish this connected target database from other target databases that have the same name. Run the RESTORE CONTROLFILE command.
What will happen if database is running and control file gets lost?
If the control files are missing, then the database cannot be mounted, so at most, the database state is nomount. Any attempt to mount will fail because of the missing files.
How to restore control files to the database?
For example, to copy a good version of control01.dbf to a new disk location you might issue: Edit the parameter file of the database so that the CONTROL_FILES parameter reflects the current locations of all control files and excludes all control files that were not restored.
How does RMAN Restore and recover a database?
RMAN uses the autobackup format and DBID to determine where to hunt for the control file autobackup. If one is found, RMAN restores the control file from that backup to all of the control file locations listed in the CONTROL_FILES initialization parameter.
How to recover control files from auto backup?
With the DBID set, we can now recover the control files from the control file autobackup. Again we have to pass the entire path along with the control file auto backup name. Next we mount the database and restore the database. Next we recover the database. Finally open the database with the RESETLOGS option.
Is it possible to restore a control file to a new location?
The only exception is the case described in “Restore of the Control File to a New Location”, where you restore your control file to a location not listed in the CONTROL_FILES initialization parameter. In that case, you create a copy of your control file in the specified location without touching your running database.