| Restore job using Enterprise Manager [message #67770] |
Mon, 04 March 2002 23:37  |
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 #68242 is a reply to message #67770] |
Mon, 17 February 2003 22:25  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
