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

On Jul 14, 3:49*am, Woody Ling <woodyl...@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 ?

On Jul 14, 7:46*pm, Helma <helma.vi...@hotmail.com> wrote:
> On Jul 14, 3:49*am, Woody Ling <woodyl...@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