Databases Reference
In-Depth Information
If you've lost all of the control files of the standby database and you don't happen to have a backup control file
for the standby database, of course, you can't restore the standby control file. You must create a brand-new standby
control file from the primary database using the following steps:
1.
Create a new standby control file from the primary database.
2.
Copy the new control file to all the multiplexed control file locations on the standby host as
specified in the initialization parameter file (SPFILE or the init.ora file).
3.
Mount the standby database:
SQL> startup mount;
4.
Restart the managed recovery process:
SQL> alter database recover managed standby database disconnect from session;
How It Works
In the Solution section, we show how to copy a good control file to replace a lost or damaged standby database control
file. Alternatively, you can edit the initialization parameter
control_files
to remove the reference to the lost or
damaged control file, and restart the standby database.
Recovering File(s) for a Primary Database
Problem
You've lost one or more primary database control files and would like to recover from the loss.
Solution
The way you handle the loss of control files of the primary database is similar to how you do so in the case of a single
database running in a non-Oracle Data Guard environment. We divide the solution into the case where you lose only
a single control file and a case where you lose all the primary database control files.
Recovering from the Loss of a Single Control File
If you've lost just a single copy of the control file (or it's corrupted and the database can't access it), simply place a
good copy of one of the surviving control files over the inaccessible or missing control file and restart the primary
instance. You do not need to perform a restore or a recovery in this case.
Recovering from the Loss of All Control Files
If you lose all of the control files of the primary database, you have three basic options. The choice depends on the
downtime you're willing to accept.
