Problem:
Starting Control File and SPFILE Autobackup at 18-MAY-2012 08:03:33
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script db_alfa_backup_db_02
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_SBT_TAPE_1 channel at 05/18/2012 08:03:40
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
Recovery Manager complete.
Backup process end time:Fri May 18 08:03:49 EEST 2012
Solution:
If two RMAN control file autobackup operation overlaps, the second session which started a little bit later gets the following error. If the first session completes the command successfully, you can ignore the second sessions error.
-- SECOND SESSION
Starting Control File and SPFILE Autobackup at 18-MAY-2012 08:03:33
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script db_alfa_backup_db_02
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_SBT_TAPE_1 channel at 05/18/2012 08:03:40
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
Recovery Manager complete.
Backup process end time:Fri May 18 08:03:49 EEST 2012
-- FIRST SESSION
Starting Control File and SPFILE Autobackup at 18-MAY-2012 08:03:19
piece handle=c-1831052958-20120518-02 comment=API Version 2.0,MMS Version 4.2.0.0
Finished Control File and SPFILE Autobackup at 18-MAY-2012 08:04:29
Recovery Manager complete.
Backup process end time:Fri May 18 08:05:17 EEST 2012
Hiç yorum yok:
Yorum Gönder