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/