Home » RDBMS Server » Backup & Recovery » ORA-19573: cannot obtain exclusive enqueue for datafile 2 (Oracle9i)
ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324379] Mon, 02 June 2008 04:31 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I took backup and sync with the recovery catalog and now i tried to restore database it shows the following error

RMAN> restore database;

Starting restore at 02-JUN-08

using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to D:\ORACLE\ORADATA\RAM\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\RAM\CWMLITE01.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\RAM\DRSYS01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\RAM\EXAMPLE01.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\RAM\INDX01.DBF
restoring datafile 00010 to D:\ORACLE\ORADATA\RAM\XDB01.DBF
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\RAM\SYSTEM01.DBF
restoring datafile 00007 to D:\ORACLE\ORADATA\RAM\ODM01.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\RAM\TOOLS01.DBF
restoring datafile 00009 to D:\ORACLE\ORADATA\RAM\USERS01.DBF
restoring datafile 00011 to D:\ORACLE\ORADATA\RMAN01.ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/02/2008 14:50:31
ORA-19573: cannot obtain exclusive enqueue for datafile 2


pls can anyone help on this issue

Thanks,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324381 is a reply to message #324379] Mon, 02 June 2008 04:42 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,
Is the database in mount state?

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324418 is a reply to message #324381] Mon, 02 June 2008 07:18 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Yes its in mount state only

thanks,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324607 is a reply to message #324381] Tue, 03 June 2008 05:37 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I found the same error while restoring the database what could be the reason for it


RMAN> restore database;

Starting restore at 03-JUN-08

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=9 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to D:\ORACLE\ORADATA\RAM\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\RAM\CWMLITE01.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\RAM\DRSYS01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\RAM\EXAMPLE01.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\RAM\INDX01.DBF
restoring datafile 00010 to D:\ORACLE\ORADATA\RAM\XDB01.DBF
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\RAM\SYSTEM01.DBF
restoring datafile 00007 to D:\ORACLE\ORADATA\RAM\ODM01.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\RAM\TOOLS01.DBF
restoring datafile 00009 to D:\ORACLE\ORADATA\RAM\USERS01.DBF
restoring datafile 00011 to D:\ORACLE\ORADATA\RMAN01.ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/03/2008 16:04:07
ORA-19573: cannot obtain exclusive enqueue for datafile 2


*My database is in not in mount State

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324613 is a reply to message #324607] Tue, 03 June 2008 05:48 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,

list your steps prior to restore. Before restore DB should be in mount state.

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324616 is a reply to message #324613] Tue, 03 June 2008 05:58 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I have been connected to recovery catalog ,when i use STARTUP MOUNT and in mount state ,it throws following error
while restoring the database

RMAN> restore database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/03/2008 16:12:57
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

*My database is in ARCHIVELOG mode

Thanks,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324629 is a reply to message #324613] Tue, 03 June 2008 06:48 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
1.Can we restore and recover the database when we are connected to recovery catalog during archivelog mode

Thanks,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324633 is a reply to message #324613] Tue, 03 June 2008 06:53 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,

List of my steps before restoring

1.Connect as target sys
2.confirgued some options
3.Made the database to MOUNT state
4.Took backup of whole database using archivelog
5.now i connected to recovery catalog "rmancat"
6.And again connected to Target sys
7.Now i tried to restore the database ,but it throws the above error

Thanks,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324639 is a reply to message #324613] Tue, 03 June 2008 07:50 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I have done the following process in RMAN
1.Made the database in mount state and took the backup of whole database
2.Then resync it to recovery catalog
3.And connected to the recovery catalog and target sys
4.now i made the database to mount state and tried to restore the Tablespace Example,but i could not able restore and recover the tablespace as show below


[B]D:\>rman target="sys/simple@ram" catalog="rmancat/rman@ram"[/B]

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RAM (DBID=2829852685)
connected to recovery catalog database

RMAN> [B]list backup;[/B]
List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
216     43M        DISK        00:00:08     03-JUN-08
        BP Key: 221   Status: AVAILABLE   Tag: TAG20080603T173556
        Piece Name: D:\ORACLE\ORABACKUP\ORA_DF656444156_S22_S1

  List of Archived Logs in backup set 216
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      806895     02-JUN-08 846965     02-JUN-08
  1    11      846965     02-JUN-08 849285     02-JUN-08
  1    14      903920     02-JUN-08 1051463    03-JUN-08
  1    15      1051463    03-JUN-08 1071977    03-JUN-08

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
217     126M       DISK        00:00:12     03-JUN-08
        BP Key: 222   Status: AVAILABLE   Tag: TAG20080603T173556
        Piece Name: D:\ORACLE\ORABACKUP\ORA_DF656444156_S21_S1

  List of Archived Logs in backup set 217
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       190578     27-MAY-08 224032     27-MAY-08
  1    8       458294     28-MAY-08 496660     28-MAY-08
  1    9       496660     28-MAY-08 806895     02-JUN-08

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
218     Full    170M       DISK        00:00:29     03-JUN-08
        BP Key: 223   Status: AVAILABLE   Tag: TAG20080603T173614
        Piece Name: D:\ORACLE\ORABACKUP\ORA_DF656444174_S23_S1
  List of Datafiles in backup set 218
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\UNDOTBS01.DBF
  3       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\CWMLITE01.DBF
  4       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\DRSYS01.DBF
  5       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\EXAMPLE01.DBF
  6       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\INDX01.DBF
  10      Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\XDB01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
219     Full    341M       DISK        00:00:41     03-JUN-08
        BP Key: 224   Status: AVAILABLE   Tag: TAG20080603T173614
        Piece Name: D:\ORACLE\ORABACKUP\ORA_DF656444174_S24_S1
  List of Datafiles in backup set 219
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\SYSTEM01.DBF
  7       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\ODM01.DBF
  8       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\TOOLS01.DBF
  9       Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RAM\USERS01.DBF
  11      Full 1121684    03-JUN-08 D:\ORACLE\ORADATA\RMAN01.ORA

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
220     Full    1M         DISK        00:00:01     03-JUN-08
        BP Key: 225   Status: AVAILABLE   Tag:
        Piece Name: D:\ORACLE\ORABACKUP\ORA_CFC-2829852685-20080603-03
  SPFILE Included: Modification time: 27-MAY-08

[B]RMAN> resync catalog;[/B]

starting full resync of recovery catalog
full resync complete

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel at 06/03/2008 17:57:3
2
RMAN-20002: target database already registered in recovery catalog

[B]RMAN> restore tablespace EXAMPLE;[/B]

Starting restore at 03-JUN-08

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=9 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to D:\ORACLE\ORADATA\RAM\EXAMPLE01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/03/2008 17:58:03
ORA-19573: cannot obtain exclusive enqueue for datafile 5

[B]RMAN> startup force mount;[/B]

Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> run
2> {
3> alter tablespace offline;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "tablespace": expecting one of: "clone, database
"
RMAN-01007: at line 3 column 7 file: standard input

RMAN> run
2> {
3> alter tablespace EXAMPLE offline;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "tablespace": expecting one of: "clone, database
"
RMAN-01007: at line 3 column 7 file: standard input

[B]RMAN> run
2> {
3> sql 'alter tablespace EXAMPLE offline';
4> restore tablespace EXAMPLE;
5> recover tablespace EXAMPLE;
6> sql 'alter tablespace EXAMPLE online';
7> alter database open;
8> }[/B]

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql command at 06/03/2008 18:03:57
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

[B]RMAN> startup force;[/B]

Oracle instance started
database mounted
database opened

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

[B]RMAN> run
2> {
3> sql 'alter tablespace EXAMPLE offline';
4> restore tablespace EXAMPLE;
5> recover tablespace EXAMPLE;
6> sql 'alter tablespace EXAMPLE online';
7> alter database open;
8> }[/B]

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql command at 06/03/2008 18:04:55
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

RMAN> alter database open;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/03/2008 18:05:08
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE


Pls can u help,on this issue

Thanks in Advance,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #324680 is a reply to message #324616] Tue, 03 June 2008 12:28 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,
at first when you connected your target database in open state and that's why the enqueue error.
secondly did a force startup which disconnected your session from the catalog.

first startup mount and then connect to the catalog and try to restore.

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #325824 is a reply to message #324680] Mon, 09 June 2008 01:53 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can u breif in steps,why because i have tried the below step it shows the following error

D:\>rman

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN> connect target sys/simple@ram

connected to target database: RAM (DBID=2829852685)

RMAN> startup mount;

database is already started

RMAN> startup force mount;

Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> connect catalog rmancat/rman@ram

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initializati
on or shutdown in progress


pls can u help on this issue

Thanks,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #325826 is a reply to message #325824] Mon, 09 June 2008 01:59 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Hi,

From the looks of it seems that your target DB and catalog DB are both same. Since you put the target DB to mount which means catalog DB is also in mount and unable to get the details from the catalog tables.

Try creating the recovery catalog on a different DB

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #325830 is a reply to message #325826] Mon, 09 June 2008 02:14 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I am having only single DB thats mentioned above ,my questions regarding RMAN
1.Whether its manadatory to create the catalog in separate DB
2.Is not possible to restore or recover the database through the recovery catalog within the same DB
3.After connecting target and catalog is it manadatory to keep the database in mount state,but when i make it MOUNT state and tried to restore or recover it throws "NOT CONNECTED TO ORACLE"

Thanks in advance,

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #325839 is a reply to message #325830] Mon, 09 June 2008 02:54 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
read this

Report message to a moderator

Re: ORA-19573: cannot obtain exclusive enqueue for datafile 2 [message #325873 is a reply to message #325839] Mon, 09 June 2008 05:28 Go to previous message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Thank u for the Kind reply's , possibly working in RMAN keep in touch with u if any issues

Thanks&Regards
Ram

Report message to a moderator

Previous Topic: Why to use indexfile option in IMPORT/EXPORT
Next Topic: RMAN restore with resetlogs option
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 16:05:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.