RMAN-06024: No Backup Or Copy Of The Control File Found To Restore

A full backup of database plus archivelog and controlfile for standby has just be completed.

“alter system switch logfile” command  was issued after backup was completed as suggested in note

RMAN Duplicate For Standby Fails with Rman-06024: No Backup Or Copy Of The Control File Found To Restore [ID 466321.1]

But we still get RMAN-06024 error which is demonstrated below:

 RMAN> run {
 2> allocate auxiliary channel c1 type disk format '/BACKUP_STAGE/%u';
 3> duplicate target database for standby dorecover;
 4> }

released channel: ORA_DISK_1
 released channel: ORA_AUX_DISK_1
 allocated channel: c1
 channel c1: sid=648 devtype=DISK

Starting Duplicate Db at 2012-09-10 17:34:19

contents of Memory Script:
 {
 set until scn  8223255;
 restore clone standby controlfile;
 sql clone 'alter database mount standby database';
 }
 executing Memory Script

executing command: SET until clause

Starting restore at 2012-09-10 17:34:32

released channel: c1
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03002: failure of Duplicate Db command at 09/10/2012 17:34:32
 RMAN-03015: error occurred in stored script Memory Script
 RMAN-06026: some targets not found - aborting restore
 RMAN-06024: no backup or copy of the control file found to restore

Solution

This corresponds to Rman Duplicate For Standby Failing with Rman-06024 [METALINK DOCID 881674.1]
The solution is to run RMAN without the dorecover option


RMAN> run {
 2> allocate auxiliary channel c1 type disk format '/BACKUP_STAGE/%u';
 3> duplicate target database for standby;
 4> }

After a success duplication of standby database and run


SQL> recover managed standby database using current logfile disconnect;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: