Oracle error of "recover database until scn..."
Date: Sun, 13 Jul 2008 18:49:04 -0700 (PDT)
Message-ID: <a4a30bc2-ef8a-4329-b4bd-88c53f1617b3@p25g2000hsf.googlegroups.com>
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
Received on Sun Jul 13 2008 - 20:49:04 CDT