ORA-19573: cannot obtain exclusive enqueue for datafile 1


I’m trying to recover my standby database with an incremental backup based on scn from primary database. But i face the below error when i recover the standby database with the incremental backup taken in primary database.

RMAN> recover database;

Starting recover at 06-NOV-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=21 device type=DISK

channel ORA_DISK_1: starting incremental datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: +STDBY/11gdb/datafile/system.258.8059

21881

destination for restore of datafile 00002: +STDBY/11gdb/datafile/sysaux.259.8059

21967

destination for restore of datafile 00003: +STDBY/11gdb/datafile/undotbs1.260.80

5922023

destination for restore of datafile 00004: +STDBY/11gdb/datafile/users.261.80592

2029

channel ORA_DISK_1: reading from backup piece /u01/incr_for_stdby_07oo9fik_1_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 11/06/2013 13:22:27

ORA-19870: error while restoring backup piece /u01/incr_for_stdby_07oo9fik_1_1

ORA-19573: cannot obtain exclusive enqueue for datafile 1

solution: 

$ 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
---------
ANAR

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database recover managed standby database cancel;

Database altered.

Starting again recover database command:

RMAN> recover database;

Starting recover at 06-NOV-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=139 device type=DISK

channel ORA_DISK_1: starting incremental datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: +STDBY/11gdb/datafile/system.258.8059

21881

destination for restore of datafile 00002: +STDBY/11gdb/datafile/sysaux.259.8059

21967

destination for restore of datafile 00003: +STDBY/11gdb/datafile/undotbs1.260.80

5922023

destination for restore of datafile 00004: +STDBY/11gdb/datafile/users.261.80592

2029

channel ORA_DISK_1: reading from backup piece /u01/incr_for_stdby_07oo9fik_1_1

channel ORA_DISK_1: piece handle=/u01/incr_for_stdby_07oo9fik_1_1 tag=TAG2013110

6T130419

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

Finished recover at 06-NOV-13

2 comments

  1. Ravi Kumar · · Reply

    We faced the same issue while we are doing the SCN incremental backup reover in our standby database. Thanks for your wonderfull notes. It was help us really for an time.

    Thanks.

  2. You are welcome Dear!!!

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: