First: Problem description
An error was reported when backing up the control file:
RMAN> restore controlfile from ‘/home/oracle/backup/PROD_32_20140829.bak’;
Starting restore at 29-AUG-14
using channel ORA_DISK_1
RMAN-00571: ============================================================================================================================================================================================================ =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================================================================================================================================================================================ =============
RMAN-03002: failure of restore command at 08/29/2014 02:41:21
RMAN-06496: must use the TO clause when the database is mounted or open
Second: the reason for the error
The control file was restored in the database mount state.
Third: solution
Restore the control file in the nomount state.
Fourth: Example
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 113247824 bytes
Database Buffers 167772160 bytes
Redo Buffers 2973696 bytes
No more errors were reported.
RMAN-06496: must use the TO clause when the database is mounted or open
