ORA-19573: cannot obtain exclusive enqueue for datafile 1

ORA-19573: cannot obtain exclusive enqueue for datafile 1

Posted: March 17, 2013 in StandBy
Tags: exclusive enqueue, Incremental backup apply, ORA-19573

1

I got the following error while applying the incremental backup to the standby database “ORA-19573: cannot obtain exclusive enqueue for datafile 1″. This was very annoying as i have cross checked everything many times. Here is few lines from RMAN sessions from which applying incremental backup:

channel ORA_DISK_4: reading from backup piece /oraclebackup/PLMQDBS/inc/incr_for_stdby_f7o3u54k_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/07/2013 12:39:20
ORA-19870: error while restoring backup piece /oraclebackup/PLMQDBS/inc/incr_for_stdby_f4o3u54k_1_1
ORA-19573: cannot obtain exclusive enqueue for datafile 1

Well, error was because of very silly mistake, i forgot to cancel the media recovery process before starting the RMAN incremental apply session. Once i have cancelled the recovery process as below, incremental backup ran fine.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

oracore@myhost $ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 7 12:41:16 2013 Copyright (c) 1982, 2009, Oracle.  All rights reserved. SQL> conn sys as sysdba Enter password: Connected. SQL> select name from v$database; NAME --------- PLMQDBS SQL> select open_mode from v$database; OPEN_MODE -------------------- MOUNTED SQL> alter database recover managed standby database cancel; Database altered.

what a small mistake !!!!!!!!