Home » RDBMS Server » Backup & Recovery » recover error
recover error [message #154180] Fri, 06 January 2006 02:56 Go to next message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

Hi all,
I have a database with name is TEST
I have backup my database into 'D:/backup' by command following:
RMAN> run {
allocate channel t1 type disk;
backup
format 'D:/backup/%d_t%t_s%s_p%p'
(database);
release channel t1;
}

Then I changes some infomation in TEST database. and I restore and recover TEST database by command following
run {
allocate channel t1 type disk;
restore database;
recover database;
release channel t1;
}
when I run this command. I get a error
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=1 set_stamp=579023015 creation_time=06-JAN-06
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to D:\ORACLE81\ORADATA\BACKUP\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to D:\ORACLE81\ORADATA\BACKUP\RBS01.DBF
RMAN-08523: restoring datafile 00003 to D:\ORACLE81\ORADATA\BACKUP\USERS01.DBF
RMAN-08523: restoring datafile 00004 to D:\ORACLE81\ORADATA\BACKUP\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to D:\ORACLE81\ORADATA\BACKUP\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to D:\ORACLE81\ORADATA\BACKUP\INDX01.DBF
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue for datafile 2
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE


Can anybody tell me what is error???
thanks
Re: recover error [message #154240 is a reply to message #154180] Fri, 06 January 2006 06:07 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Datafile 2 is in use - RMAN cannot write to it:

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.
Re: recover error [message #154471 is a reply to message #154240] Sun, 08 January 2006 20:19 Go to previous message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

My database is in ARCHIVELOG mode. What do I do before I run restore command????
Previous Topic: Exp/Imp data from table containing BLOB column..?
Next Topic: Oracle error 19502
Goto Forum:
  


Current Time: Mon Dec 23 03:32:22 CST 2024