rman 恢复数据报ORA-19573: cannot obtain exclusive enqueue for ...

cqszpx

于 2022-09-25 16:13:24 发布

阅读量522

点赞数

文章标签：数据库 oracle

本文链接：https://blog.csdn.net/cqszpx/article/details/127039278

版权

在尝试使用RMAN恢复Oracle数据库时遇到ORA-19573错误，提示无法获得数据文件的独占队列。错误源于数据库在打开状态下进行恢复操作。解决方法是将数据文件脱机，然后将数据库切换到挂载状态，再执行恢复操作，从而成功解决问题。

摘要由CSDN通过智能技术生成

报错现象：
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: restor