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

From: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 14 Jul 2008 04:46:52 -0700 (PDT)
Message-ID: <98d5fa32-2f77-4590-a6ec-bccb619c7100@i76g2000hsf.googlegroups.com>


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 ? Received on Mon Jul 14 2008 - 06:46:52 CDT

Original text of this message