ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解決方法

ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解決方法

 

一個朋友說自己使用RMAN進行恢復datafile 3，出現ORA-19573，不能正常恢復。與朋友溝通，朋友執行恢復的時候，竟還有例項處於OPEN狀態。把所有例項mount後，恢復成功

 

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

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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

RMAN-03002: failure of restore command at 07/26/2013 11:45:33

ORA-19870: error while restoring backup piece /rman/backup/data/level0_RACDB_93_1_2tofn3hn_20130726.bak

ORA-19573: cannot obtain exclusive enqueue for datafile 3

 

[oracle@racdb 2 rman]$ oerr ora 19573

19573, 00000, "cannot obtain %s enqueue 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 conflicting operation is complete, then retry

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

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

 

 

解決方法：所有例項mount狀態下執行恢復！

 

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26442936/viewspace-767331/，如需轉載，請註明出處，否則將追究法律責任。