18 Mayıs 2012 Cuma

[EN] ORA-00230: operation disallowed: snapshot control file enqueue unavailable

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