RMAN-06496: must use the TO clause when the database is mounted or open, rman-06496mounted

RMAN-06496: must use the TO clause when the database is mounted or open, rman-06496mounted

I. Problem Description

An error occurred while 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

 

Ii. Cause of error

The control file is restored when the database is mounted.

Iii. Solution

Restore the control file in nomount state.

Iv. 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 error is reported.