Friday, 6 April 2018

RMAN-03002 RMAN-06496 Errors in RMAN Restore - Oracle Database

RMAN-03002 RMAN-06496 Errors in Restore Operation - Oracle RMAN


RMAN-03002 RMAN-06496 Errors in RMAN Restore


I was trying to Roll forward the Near DR Site using Oracle Incremental Backup. I had already taken all the Backups required to roll forward the Physical Standby and bring it in sync with my Primary Database. Also the same were copied to the DR Site. I started with restoring the control file backup from the shipped backups and I got the below mentioned error,

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/06/2018 15:12:44
RMAN-06496: must use the TO clause when the database is mounted or open

If you'll see the last line of the error "must use the TO clause when the database is mounted or open", you'll get the idea. My Standby database was in mount state and I forgot to bring it to nomount state first. At mount state, the control file is already in use so the restore operation for Control file was denied at that moment.

To Fix the same:

Shutdown your database

RMAN> Shutdown;

Start your database in nomount state

RMAN> Startup nomount;

Restore your controlfile now

RMAN> restore standby controlfile from '/location_where_controlfile_is_located/control_file_name.bkp';

I hope this helps !!

No comments:

Post a comment