Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recovery database problem

Recovery database problem

From: Kamel Hamard <hamard_at_iro.umontreal.ca>
Date: Tue, 10 Aug 1999 01:57:56 GMT
Message-ID: <EGLr3.10414$X82.672736@carnaval.risq.qc.ca>


Hi,

I want to recover a database following to a media failure. I have a backup of the database (datafiles, controlfile (binary and text format) and a backup of archive log file made with Recovery manager under oracle 8i under windows NT.

Any body can help me?

I'm looking on the steps to follow to restore the database on a new host.

For the moment a cant restore the archive log files and the error message is as follow:

RMAN> run {

2> allocate channel c1 type disk
3> format 'd:\orant\oradata\wcdb\archive';
4> restore (archivelog all);
5> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=14 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE RMAN-06050: archivelog thread 1 sequence 352 is already on disk as file D:\ORANT\ORADATA\WCDB\ARCHIVE\%WCDB%T001S00352.A RC

RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 15 scn 205182 found to restore
RMAN-06025: no backup of log thread 1 seq 14 scn 204484 found to restore
RMAN-06025: no backup of log thread 1 seq 13 scn 203201 found to restore
RMAN-06025: no backup of log thread 1 seq 12 scn 181901 found to restore

thanks for any help.

Kamel Received on Mon Aug 09 1999 - 20:57:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US