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

From: Woody Ling <>
Date: Sun, 13 Jul 2008 18:49:04 -0700 (PDT)
Message-ID: <>

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!


Woody Ling
Hong Kong Received on Sun Jul 13 2008 - 20:49:04 CDT

Original text of this message