Re: Incomplete recovery not working...

From: eAddict <eAddict_at_gmail.com>
Date: Thu, 07 Jun 2007 13:01:56 -0700
Message-ID: <1181246516.725816.212840@p77g2000hsh.googlegroups.com>

On Jun 7, 2:49 pm, sybra..._at_hccnet.nl wrote:

>

> Find out, using v$log and v$log_file to which *online redolog*
> sequence 26547 is pointing.
> Then specify *that* file in recover database.

I tried that...
QL> select group#, sequence#, bytes, first_change#, to_char(first_time,'DD-MON-YY HH24:MI:SS'), status from v$log   2 /

    GROUP# SEQUENCE# BYTES FIRST_CHANGE# TO_CHAR(FIRST_TIME STATUS

---------- ---------- ---------- ------------- ------------------
----------------

         1      26546   94371840    6934088055 03-JUN-07 17:08:43

ACTIVE          2 26547 94371840 6934090440 03-JUN-07 17:09:39 CURRENT SQL> recover database using backup controlfile until cancel; ORA-00279: change 6934091358 generated at 06/03/2007 17:09:39 needed for thread 1
ORA-00289: suggestion : /oracle/BPR/saparch/BPRarch1_26547.dbf ORA-00280: change 6934091358 for thread 1 is in sequence #26547

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} /oracle/BPR/origlogB/log_g2m1.dbf
ORA-00328: archived log ends at change 6368365545, need later change 6934091358
ORA-00334: archived log: '/oracle/BPR/origlogB/log_g2m1.dbf'

The SCN is larger than what was in file #2...

Anyway, yes we are running in archive log mode. What we are trying to do is recover to a new system
to be able to transport stuff out BEFORE the developer hosed stuff in the live system. We have a test
system that we can restore too - i just wasn't sure that we need the archive log files since I was restoring
an online backup.

Vince Received on Thu Jun 07 2007 - 15:01:56 CDT