rman 恢復(fù)數(shù)據(jù)報ORA-19573: cannot obtain exclusive enqueue for ...
報錯現(xiàn)象:
RMAN> run {
2> restore database;
3> recover database;
4> }
Starting restore at 12-AUG-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=96 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/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to
/u01/app/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to
/u01/app/oracle/oradata/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to
/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to
/u01/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to
/u01/app/oracle/oradata/orcl/test1.dbf
channel ORA_DISK_1: reading from backup piece
/home/oracle/rmanback/incremental_ORCL_1575005578_22_1_20220812.bak
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/12/2022 14:24:53
ORA-19870: error while restoring backup piece
/home/oracle/rmanback/incremental_ORCL_1575005578_22_1_20220812.bak
ORA-19573: cannot obtain exclusive enqueue for datafile 1
ORA-19890: data file already in use
ORA-45909: restore, recover or block media recovery may be in progress
原來是database 在open下,忘了將datafile offline,造成此低級錯誤;將數(shù)據(jù)文件offline 后,重啟數(shù)據(jù)庫到mount下,在執(zhí)行恢復(fù),問題解決!
