RMAN restore control file

If all control files are lost or damaged, you need to restore them from the backup. The restorecontrolfile command is used to restore the control file. The logarithm is required after the control file is restored.

If all control files are lost or damaged, you need to restore them from the backup. The restore controlfile command is used to restore the control file. The logarithm is required after the control file is restored.

If all control files are lost or damaged, you need to restore them from the backup. The restore controlfile command is used to restore the control file. After restoring the control file, you must perform full media recovery on the Data Mu and use the resetlog option to open the database. RMAN can restore the control file to its default storage location, or use restore controlfile... to destination to specify the location.

Restore the control file from a known control file backup
SQL> show parameter control_files

NAME TYPE VALUE
-----------------------------------------------------------------------------
Control_files string/u01/app/Oracle/oradata/test/c
Ontrol01.ctl,/u01/app/oracle/
Oradata/test/control02.ctl,/u
01/app/oracle/oradata/test/con
Trol03.ctl

Displays currently available backups
RMAN> list backup;

List of Backup Sets
==============================

BS Key Size Device Type Elapsed Time Completion Time
-------------------------------------------------------
77 693.50 k disk 00:00:02 28-JAN-15
BP Key: 75 Status: AVAILABLE Compressed: YES Tag: TAG20150128T131713
Piece Name:/u02/test_df870182233_s95_s1

List of Archived Logs in backup set 77
Thrd Seq Low SCN Low Time Next SCN Next Time
-------------------------------------------------
1 13 2928236 28-JAN-15 2928830 28-JAN-15

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
78 Full 166.91 m disk 00:01:19 28-JAN-15
BP Key: 76 Status: AVAILABLE Compressed: YES Tag: TAG20150128T131716
Piece Name:/u02/test_df870182236_s96_s1
List of Datafiles in backup set 78
File LV Type Ckp SCN Ckp Time Name
---------------------------------
1 Full 2928835 28-JAN-15/u01/app/oracle/oradata/test/system01.dbf
2 Full 2928835 28-JAN-15/u01/app/oracle/oradata/test/undotbs01.dbf
3 Full 2928835 28-JAN-15/u01/app/oracle/oradata/test/sysaux01.dbf
4 Full 2928835 28-JAN-15/u01/app/oracle/oradata/test/users01.dbf
5 Full 2928835 28-JAN-15/u01/app/oracle/oradata/test/example01.dbf
6 Full 2928835 28-JAN-15/u01/app/oracle/oradata/test/test01.dbf

BS Key Size Device Type Elapsed Time Completion Time
-------------------------------------------------------
79 7.50 k disk 00:00:01 28-JAN-15
BP Key: 77 Status: AVAILABLE Compressed: YES Tag: TAG20150128T131841
Piece Name:/u02/test_df870182321_s97_s1

List of Archived Logs in backup set 79
Thrd Seq Low SCN Low Time Next SCN Next Time
-------------------------------------------------
1 14 2928830 28-JAN-15 2928868 28-JAN-15

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
80 Full 9.42 m disk 00:00:02 28-JAN-15
BP Key: 78 Status: AVAILABLE Compressed: NO Tag: TAG20150128T131843
Piece Name:/u01/app/oracle/10.2.0/db/dbs/c-2155613261-20150128-0d
Control File Included: Ckp SCN: 2928874 Ckp time: 28-JAN-15
SPFILE encoded ded: Modification time: 28-JAN-15

From the above information, we can see that backup set 80 is a backup of the control file and spfile file.