"Oracle Case" ORA-19573

1.1.1. ORA-19573

Date: 2014-05-21 17:25

Environment: Test environment

"Scenario description"

The database instance is in the open state (READ WRITE), and the database restore, recovery operation encountered an error in Rman.

"Error Message"

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>

"An explanation of the error"

[Email protected] ~]$ 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.

[Email protected] ~]$ oerr ora 19573

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

*cause:the file access Enqueue could not being obtained for a file

specified in a backup, copy or restore operation.

If the Enqueue type shown is ' shared ' and then the file is the

Input file for a backup or copy. If the type is ' exclusive ' and then

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

is attempting to overwrite the currently active version of the

File-in this case, the file must is offline or the database must

Be closed. If the type is ' read-only ' and then attempting

To-back-or-copy this file while the database was in Noarchivelog

Mode.

*action:wait until the conflictingoperation is complete and then retry

The copy or backup. If thedatabase is in Noarchivelog mode, then

All files being backed up must is closed cleanly.

[Email protected] ~]$

"Cause of error"

The database is in the open state, and all tablespace and data files are online, at which time Oracle does not allow restore recovery.

"Workaround"

In this test case, the DB instance is closed and then opened to the Mount state, and the Rman does not perform a full recovery again.