Re: Errors During Recovery Using RMAN

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 1 May 2001 15:03:02 +1000
Message-ID: <3aee4393$1@news.iprimus.com.au>

Errors During Recovery Using RMANFirst, I'd worry why you are restoring and recovering the entire database when you say that the actual requirement is simply to recover a particular datafile.

Secondly, all recoveries with RMAN require the relevant files to be offline (so if you are in MOUNT stage, that's OK). So if you were trying to actually restore just one datafile, you'd have to have a line in there to issue the 'alter tablespace blah offline' command.

Thirdly, it appears not to be able to overwrite one file that already exists (I presume all the other files existed too, but clearly it was able to overwrite them). I can only think of two reasons why RMAN wouldn't be able to overwrite a file: one, the file is actually still online (unlikely), and two, because RMAN doesn't have rights to replace it. So, check the permissions on the datafile that RMAN seems to be spewing about, and make sure that they are identical to all the others.

Finally, it's not a good idea to post in HTML. Plenty of readers don't work with it, and plenty of sensible people get a bit worried about nasties that might be lurking within HTML documents.

Regards
HJR "Anurag Minocha" <AMinocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E11129B_at_jshemail.herold.com... Hi,
I am trying to recover a lost datafile using rman and get errors.
Here is the script I am running and below that are errors.

RMAN> run {

2> allocate channel c2 type disk;
3> restore database;
4> recover database;
5> release channel c2;
6> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c2
RMAN-08500: channel c2: sid=11 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c2: starting datafile backupset restore
RMAN-08502: set_count=3 set_stamp=428428372

RMAN-08019: channel c2: restoring datafile 1 RMAN-08509: destination for restore of datafile 1: C:\ORA805
\DATABASE\SYS1ORCL.O

RA
RMAN-08019: channel c2: restoring datafile 2 RMAN-08509: destination for restore of datafile 2: C:\ORA805
\DATABASE\USR1ORCL.O

RA
RMAN-08019: channel c2: restoring datafile 3 RMAN-08509: destination for restore of datafile 3: C:\ORA805
\DATABASE\RBS1ORCL.O

RA
RMAN-08019: channel c2: restoring datafile 4 RMAN-08509: destination for restore of datafile 4: C:\ORA805
\DATABASE\TMP1ORCL.O

RA
RMAN-08019: channel c2: restoring datafile 5 RMAN-08509: destination for restore of datafile 5: C:\ORA805
\DATABASE\USR2ORCL.O

RA
RMAN-08019: channel c2: restoring datafile 6 RMAN-08509: destination for restore of datafile 6: C:\ORA805
\DATABASE\TEMPORCL.O

RA
RMAN-08019: channel c2: restoring datafile 7 RMAN-08509: destination for restore of datafile 7: C:\ORA805
\DATABASE\REC_DATAOR

CL.ORA

RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c2
RMAN-00569: ================error message stack
follows================
RMAN-03002: failure during compilation of command

RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel c2
RMAN-10032: unhandled exception during execution of job step 1: ORA-06512: at li
ne 148
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible
ORA-19504: failed to create file "C:\ORA805
\DATABASE\REC_DATAORCL.ORA"

ORA-27038: skgfrcre: file exists
OSD-04010: option specified, file already exists
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line

925
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE
Thanks
Anurag Received on Tue May 01 2001 - 00:03:02 CDT