Databases Reference
In-Depth Information
When you restore your control file and when the auto backup feature has not been enabled, then RMAN is unable
to determine by itself the default location. You must directly tell RMAN from which backup piece to restore the control
file.
■
If you are using a FRA and a recovery catalog, then refer to Recipe 10-2 for details about restoring your control
file. In that scenario, RMAN will automatically retrieve the backup piece name and location from the
recovery catalog.
Note
If you have the RMAN output log from a backup, then you should be able to see which backup piece contains the
backup of your control file. For example:
Piece Name:
'/u01/fra/O12C/backupset/2012_07_17/o1_mf_ncnnf_TAG20120717T0954_80cd0x_.bkp';
Control File Included: Ckp SCN: 682078
In this example, the correct backup piece name is as follows:
o1_mf_ncnnf_TAG20120717T0954_80cd0x_.bkp
Restoring Control File Using Recovery Catalog
Problem
You need to restore your control file, and you use a recovery catalog when creating backups.
Solution
Restoring the control file is fairly simple when you use a recovery catalog. All you need to do is ensure that you
connect to both your target database and the recovery catalog. Then issue
startup nomount
, and issue the
restore
controlfile
command.
In this example, the recovery catalog owner and password are both
rcat
, and also the name of the recovery catalog
is
rcat
. You'll have to change those values to match the
username/password@service
in your environment.
$ rman target /
RMAN> connect catalog rcat/rcat@rcat
RMAN> startup nomount;
RMAN> restore controlfile;
RMAN restores the control files to the location defined by your
control_files
initialization parameter. You
should see a message indicating that your control files have been successfully copied back from an RMAN backup
piece. Here's a partial listing of RMAN's message stack after a successful control file restore:
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/dbfile/o12c/control01.ctl
output file name=/u01/dbfile/o12c/control02.ctl
You can now alter your database into mount mode and perform any additional restore and recovery commands
required for your database.
