Re: RMAN 8i question - Disaster Recovery and online redo logs...

BD wrote:
> Hi, all.

(skipped)

You are trying to do a complete recovery. You removed your online redo logs, so you can only do an incomplete recovery. Read the RMAN documentation regarding Incomplete (Point in time) recovery and look for "set until time ..." or "set until logseq ..."

Your (new) STEP 10 should look something like:

startup mount
rman nocatalog target /
run {allocate channel ch1 type disk;

     sql "alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''";
     set until logseq 2 thread 1;
     restore database;
     switch datafile all;
     recover database;} 

HTH.

--
Ravi