【oracle案例】ORA-19573

1.1.1. ORA-19573

日期:2014-05-21 17:25

环境:测试环境

 

【情景描述】

数据库实例处于OPEN状态(READ WRITE),这时在RMAN中执行数据库还原、恢复操作遇到报错。

 

【报错信息】

RMAN> run {   

2> allocate channel ch1 type disk;

3> allocate channel ch2 type disk;

4> set until scn 1520939;

5> restore database;

6> recover database;

7> release channel ch1;

8> release channel ch2;

9> }

......

released channel: ch1

released channel: ch2

RMAN-00571:===========================================================

RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============

RMAN-00571:===========================================================

RMAN-03002: failure of restore command at05/21/2014 17:04:43

ORA-19870: error while restoring backuppiece/U01/app/test/rman/fra/TESTDB/backupset/2014_05_21/o1_mf_nnndf_TAG20140521T164225_9qrsqkyw_.bkp

ORA-19573: cannot obtain exclusive enqueuefor datafile 1

 

RMAN>

 

【报错详解】

[oracle@oracle ~]$ oerr ora 19870

19870, 00000, "error while restoringbackup piece %s"

// *Cause: This error should be followed byother errors indicating

//        the cause of the problem.

// *Action: See other errors actions.

[oracle@oracle ~]$ oerr ora 19573

19573, 00000, "cannot obtain %senqueue for datafile %s"

// *Cause: The file access enqueue could not be obtained for a file

//         specified in a backup, copy or restore operation.

//         If the enqueue type shown is 'shared', then the file is the

//         input file for a backup or copy. If the type is 'exclusive', then

//         the file is the output file for a datafile copy or restore which

//         is attempting to overwrite the currently active version of that

//         file - in this case, the file must be offline or the database must

//         be closed.  If the type is'read-only', then you are attempting

//         to back up or copy this file while the database is in NOARCHIVELOG

//         mode.

// *Action: Wait until the conflictingoperation is complete, then retry

//         the copy or backup.  If thedatabase is in NOARCHIVELOG mode, then

//         all files being backed up must be closed cleanly.

[oracle@oracle ~]$

 

【报错原因】

数据库处于OPEN状态,所有的表空间和数据文件都是ONLINE的,此时oracle不允许还原恢复。

 

【解决方法】

在此测试案例中,先关闭数据库实例,然后打开到MOUNT状态,再次登录RMAN执行不完全恢复。

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值