ITPub博客

首页 > 数据库 > Oracle > ORA-19573: cannot obtain exclusive enqueue for datafile 1

ORA-19573: cannot obtain exclusive enqueue for datafile 1

原创 Oracle 作者:wenjunheyixiao 时间:2016-08-02 15:09:06 0 删除 编辑


1         

问题

RMAN> restore datafile 1;


Starting restore at 02-AUG-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=152 device type=DISK


channel ORA_DISK_1: starting datafile backup set restore

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

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oralce/oradata/enmoedu1/system01.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oralce/fast_recovery_area/ENMOEDU1/backupset/2016_08_02/o1_mf_nnndf_TAG20160802T121001_ct078sm5_.bkp

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

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

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

RMAN-03002: failure of restore command at 08/02/2016 15:00:19

ORA-19870: error while restoring backup piece /u01/app/oralce/fast_recovery_area/ENMOEDU1/backupset/2016_08_02/o1_mf_nnndf_TAG20160802T121001_ct078sm5_.bkp

ORA-19573: cannot obtain exclusive enqueue for datafile 1


2

原因:

最后查看发现数据库实例都在开启状态,所以我就把数据库开启到mount的状态再进行实验;

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.


Total System Global Area  830930944 bytes

Fixed Size                  2257800 bytes

Variable Size             536874104 bytes

Database Buffers          285212672 bytes

Redo Buffers                6586368 bytes

Database mounted.

SQL>


3

验证:

[oracle@enmoedu1 ~]$ rman target/


Recovery Manager: Release 11.2.0.4.0 - Production on Tue Aug 2 15:03:17 2016


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: ENMOEDU1 (DBID=8870347, not open)


RMAN> restore datafile 1;


Starting restore at 02-AUG-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=10 device type=DISK


channel ORA_DISK_1: starting datafile backup set restore

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

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oralce/oradata/enmoedu1/system01.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oralce/fast_recovery_area/ENMOEDU1/backupset/2016_08_02/o1_mf_nnndf_TAG20160802T121001_ct078sm5_.bkp

channel ORA_DISK_1: piece handle=/u01/app/oralce/fast_recovery_area/ENMOEDU1/backupset/2016_08_02/o1_mf_nnndf_TAG20160802T121001_ct078sm5_.bkp tag=TAG20160802T121001

channel ORA_DISK_1: restored backup piece 1

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

Finished restore at 02-AUG-16


RMAN> recover datafile 1;


Starting recover at 02-AUG-16

using channel ORA_DISK_1


starting media recovery


archived log for thread 1 with sequence 6 is already on disk as file /u01/app/oralce/fast_recovery_area/ENMOEDU1/archivelog/2016_08_02/o1_mf_1_6_ct07rbky_.arc

archived log file name=/u01/app/oralce/fast_recovery_area/ENMOEDU1/archivelog/2016_08_02/o1_mf_1_6_ct07rbky_.arc thread=1 sequence=6

media recovery complete, elapsed time: 00:00:01

Finished recover at 02-AUG-16


4

总结:

一定要细心,再细心,细心!



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-2122862/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-12-02

  • 博文量
    117
  • 访问量
    161253