Database Backup and Recovery (MOSC)

MOSC Banner

set until scn

edited Apr 17, 2014 8:04AM in Database Backup and Recovery (MOSC) 15 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center