set until scn
Hi ,
on 10.2.0.4 on Win 2003
I have a backup from which I want to recover my database.
From restore DATABASE preview; I have the following information
restore DATABASE preview;
Media recovery start SCN is 1947476901186
Recovery must be done beyond SCN 1947476908130 to clear data files fuzziness
How should I use this information to avoid :
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'S:\ORADATA\MYDB\MYDB_SYSTEM01.DBF'
In my SET UNTIL SCN, which value for SCN should be given ?
Thanks and regards.