Re: Oracle error of "recover database until scn..."
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