Tuesday, March 10, 2015

ORA-01580: error creating control backup

ERROR

Soon after launching the duplication or restore rman tries to restore the controlfile before it mounts the auxiliary database,which is not possible due to the rman configuration for snapshot controlfile which we can see with 
RMAN> show all;

or specifically

RMAN>show snopshot controlfile name;

Therefore the rman session hangs for sometime and throws the following error

RMAN-00571: ======================================================
RMAN-00569: ======== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ======================================================
RMAN-03002: failure of show command at 02/01/2015 01:35:50
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 11/08/2011 01:35:50
ORA-01580: error creating control backup file /u01/snapcf_ggdb1.f


SOLUTION

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

sqlplus "/ as sysdba"
sys@db1> EXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('/u01/app/oracle/product/11.2/db/dbs/snapcf_db1.f');
PL/SQL procedure successfully completed.

And then restart the duplication or restore.

No comments:

Post a Comment