【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执行不完全恢复。