ORA-19573: cannot obtain exclusive enqueue for datafile 1

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30606702/viewspace-2122862/