Home » RDBMS Server » Backup & Recovery » data not acess (10g AIX)
data not acess [message #314587] Thu, 17 April 2008 04:03 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
hey
i want to do incremnatl backup
i get this error
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00115 to /sapdev/oracle/SRT/rman.dbfRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/17/2008 11:58:14
ORA-19573: cannot obtain exclusive enqueue for datafile 115

but this is my RMAN TABLESPACE
whats wrong?
thanks
Re: data not acess [message #314593 is a reply to message #314587] Thu, 17 April 2008 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-19573: 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

Regards
Michel
Re: data not acess [message #314594 is a reply to message #314587] Thu, 17 April 2008 04:16 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
ok.
but my TABLESPACE RMAN its READ WRITE ONLINE.

RMAN need to backup warm ?
Re: data not acess [message #314597 is a reply to message #314587] Thu, 17 April 2008 04:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
in this case, the file must be offline or the database must
be closed.
Re: data not acess [message #314636 is a reply to message #314587] Thu, 17 April 2008 05:58 Go to previous message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
thanks
Previous Topic: Flashback for Oracle 10g
Next Topic: Rman backup valid or not
Goto Forum:
  


Current Time: Fri May 10 04:09:19 CDT 2024