RMAN备份恢复报错 ORA-19573: cannot obtain exclusive enqueue for datafile 5

最新推荐文章于 2025-06-05 08:13:36 发布

莲华君

最新推荐文章于 2025-06-05 08:13:36 发布

阅读量706

点赞数

CC 4.0 BY-SA版权

文章标签： oracle

原文链接：https://blog.csdn.net/huangliang0703/article/details/46692417

本文详细记录了一次使用RMAN进行Oracle数据库数据文件备份和恢复过程中遇到的ORA-19573错误的解决过程。通过将数据文件设置为离线状态，成功避免了在恢复过程中出现的独占锁获取失败问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMAN备份恢复报错 ORA-19573: cannot obtain exclusive enqueue for datafile 5

用vi 编辑了一个数据文件，导致下面的错误：

验证还原

RMAN> validate datafile 5;

Starting validate at 2015-06-29 22:26:23
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of validate command on ORA_DISK_1 channel at 06/29/2015 22:26:23
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: '/export/11g/oradata/orcl/example01.dbf'
ORA-01565: error in identifying file '/export/11g/oradata/orcl/example01.dbf'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

列出备份信息

RMAN> list backup;

List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 69.02M DISK 00:00:06 2015-06-29 21:06:47
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20150629T210641
Piece Name: /export/11g/flash_recovery_area/ORCL1/backupset/2015_06_29/o1_mf_nnndf_TAG20150629T210641_bs3tx260_.bkp

List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
5 Full 1422071 2015-06-29 21:06:42 /export/11g/oradata/orcl/example01.dbf

之前做了一个备份，准备还原：

还原准备


RMAN> restore datafile 5;

Starting restore at 2015-06-29 22:28:33
using channel ORA_DISK_1
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 00005 to /export/11g/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /export/11g/flash_recovery_area/ORCL1/backupset/2015_06_29/o1_mf_nnndf_TAG20150629T210641_bs3tx260_.bkp
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/29/2015 22:28:35
ORA-19870: error while restoring backup piece /export/11g/flash_recovery_area/ORCL1/backupset/2015_06_29/o1_mf_nnndf_TAG20150629T210641_bs3tx260_.bkp
ORA-19573: cannot obtain exclusive enqueue for datafile 5

出现了错误 ORA-19573: cannot obtain exclusive enqueue for datafile 5

SQL> select FILE_NAME,STATUS,ONLINE_STATUS from dba_data_files;

FILE_NAME
--------------------------------------------------------
/export/11g/oradata/orcl/example01.dbf

AVAILABLE ONLINE

设置数据文件离线

我们可以看到数据文件还是在线的状态，现将其离线，再次查看状态，变成了recover 状态。

SQL> alter database datafile 5 offline;

Database altered.
Database altered.

SQL> select FILE_NAME,STATUS,ONLINE_STATUS from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/export/11g/oradata/orcl/example01.dbf
AVAILABLE RECOVER

再次执行还原

RMAN> restore datafile 5;

Starting restore at 2015-06-29 22:32:36
using channel ORA_DISK_1

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 00005 to /export/11g/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /export/11g/flash_recovery_area/ORCL1/backupset/2015_06_29/o1_mf_nnndf_TAG20150629T210641_bs3tx260_.bkp
channel ORA_DISK_1: piece handle=/export/11g/flash_recovery_area/ORCL1/backupset/2015_06_29/o1_mf_nnndf_TAG20150629T210641_bs3tx260_.bkp tag=TAG20150629T210641
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

Finished restore at 2015-06-29 22:32:44

这次还原成功了。