Re: Oracle error of "recover database until scn..."

On Jul 14, 7:46 pm, Helma <helma.vi..._at_hotmail.com> wrote:
> On Jul 14, 3:49 am, Woody Ling <woodyl..._at_gmail.com> wrote:
>
>
>
>
>
> > Hi all,
>
> > I get error message when using "recover database until scn ...." as
> > below:
>
> > ---------------------------------------------------------------------------­---
> > RMAN> list backup;
>
> > List of Backup Sets
> > ===================
>
> > BS Key  Type LV Size       Device Type Elapsed Time Completion
> > Time
> > ------- ---- -- ---------- ----------- ------------
> > --------------------
> > 6       Full    742.70M    DISK        00:23:54     10-JUL-2008
> > 14:45:27
> >         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag:
> > TAG20080710T142132
> >         Piece Name: /u01/backup/07jl4tjd_1_1
> >   List of Datafiles in backup set 6
> >   File LV Type Ckp SCN    Ckp Time             Name
> >   ---- -- ---- ---------- -------------------- ----
> >   1       Full 6510393    10-JUL-2008 14:21:33 /u03/oradata/
> > system01.dbf
> >   2       Full 6510393    10-JUL-2008 14:21:33 /u03/oradata/
> > undotbs01.dbf
> >   3       Full 6510393    10-JUL-2008 14:21:33 /u03/oradata/
> > sysaux01.dbf
> >   4       Full 6510393    10-JUL-2008 14:21:33 /u03/oradata/
> > users01.dbf
>
> > RMAN> restore database;
> > ......
> > ......
> > channel ORA_DISK_1: restore complete, elapsed time: 00:21:35
> > Finished restore at 14-JUL-2008 09:08:19
>
> > RMAN> recover database until scn 6510394;
>
> > Starting recover at 14-JUL-2008 09:18:30
> > using channel ORA_DISK_1
>
> > starting media recovery
>
> > archive log filename=/ArchiveLog/oracle/abcdb1_192_652198877.arc
> > thread=1 sequence=192
> > Oracle Error:
> > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
> > error below
> > ORA-01194: file 1 needs more recovery to be consistent
> > ORA-01110: data file 1: '/u03/oradata/system01.dbf'
>
> > media recovery complete, elapsed time: 00:00:03
> > Finished recover at 14-JUL-2008 09:18:37
> > --------------------------------------------------------
>
> > As the check point SCN of the data files is 6510393, I wonder why I
> > cannot recover up to SCN 6510394.
> > Besides, what is the lowest SCN I should recover to?
>
> > Now I can only find it by "try and error".
>
> > RMAN> recover database until scn 6510400;
> > Oracle Error....
> > RMAN> recover database until scn 6510500;
> > Oracle Error....
> > RMAN> recover database until scn 6510600;
> > Oracle Error....
> > RMAN> recover database until scn 6510700;
> > Finished!
>
> > Thanks.
>
> > Woody Ling
> > Hong Kong
>
> did you check  metalink Note:435201.1 ?- Hide quoted text -
>
> - Show quoted text -

Thanks for your info. I just check it.

I know that I should apply more archivelogs in order to open the database but my question is "how many".

Since the backup check point SCN is 6510393 I suppose I can restore and recover up to 6510394 but I failed.

Finially I should recover up to SCN 6510700 in order to open the database, what is the reason behind?

Thanks.
Woody Ling
Hong Kong Received on Tue Jul 15 2008 - 20:17:29 CDT