Re: Recovery database problem

Kamel,
 Hi. One of the options that you have is to recover until (partial recovery). I would suggest the 'recover until scn#'.

                                Hope this helps.

                                                Tapan H Trivedi

Kamel Hamard wrote:
>
> 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 Tue Aug 10 1999 - 07:05:21 CDT