Home » RDBMS Server » Enterprise Manager » Restore job using Enterprise Manager
Restore job using Enterprise Manager [message #67770] Mon, 04 March 2002 23:37 Go to next message
Rob
Messages: 70
Registered: January 2000
Member
Have managed to create a job to backup my db, but I can't restore. I get the following:
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 BackupTest
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue for datafile 1
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
I have discovered this is because the db needs to be taken offline, but if I do that, I can't connect to my management server to create/run the job. How the **** do I do it??? Somebody help me, please!!!!
Re: Restore job using Enterprise Manager [message #67894 is a reply to message #67770] Fri, 28 June 2002 05:51 Go to previous messageGo to next message
Eddy Confer
Messages: 17
Registered: January 2002
Junior Member
Rob,
I don't have the answer to your question. I am experiencing the same problem. Did you ever get an answer?
Re: Restore job using Enterprise Manager [message #68242 is a reply to message #67770] Mon, 17 February 2003 22:25 Go to previous messageGo to next message
Pramod
Messages: 18
Registered: April 1999
Junior Member
Hello

I am also facing the similar problem. Please see whether anything is going wrong... If u have solution by now then please give it to me too.

C:>RMAN RCVCAT RMAN/RMAN@WOW

Recovery Manager: Release 9.0.1.1.1 - Production

(c) Copyright 2001 Oracle Corporation. All rights reserved.

connected to recovery catalog database

RMAN> CONNECT TARGET RMAN/RMAN@WOW

connected to target database: WOW (DBID=2808331299)

RMAN> RUN{
2> ALLOCATE CHANNEL C1 TYPE DISK;
3> RESTORE CONTROLFILE TO 'D:ORACLEORADATAWOWCTRLWOW.CTL';
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> RELEASE CHANNEL C1;
7> }

allocated channel: C1
channel C1: sid=11 devtype=DISK

Starting restore at 17-FEB-03

controlfile is already restored to file D:ORACLEORADATAWOWCTRLWOW.CTL
restore not done; all files readonly, offline, or already restored
Finished restore at 17-FEB-03

Starting restore at 17-FEB-03

channel C1: starting datafile backupset restore
channel C1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to D:ORACLEORADATAWOWINDX01.DBF
released channel: C1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 02/17/2003 04:08:40
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-12004: unhandled exception during command execution on channel C1
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue
for datafile 6
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE

From
Pramod
Re: Restore job using Enterprise Manager [message #68832 is a reply to message #67894] Tue, 02 November 2004 21:49 Go to previous message
veenu
Messages: 1
Registered: November 2004
Junior Member
If you do not specify set newname commands for the datafiles during a restore job, the database must be closed or the datafiles must be offline. Otherwise, you will see output similar to the following, which results from an attempt to restore datafile 3 while the file is online:

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 ch1
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue
for datafile 3
Previous Topic: How to take oracle database dump without data ?
Next Topic: ORACLE Instance RBP - Can not allocate log, archival required
Goto Forum:
  


Current Time: Mon May 16 16:26:04 CDT 2022