User managed incomplete recovery
=> Time/Cancel/Change (SCN) based
1. STARTUP MOUNT
2. Restore all data files (including system, data, index, undo but not control file or redo log files)
3. RECOVER DATABASE UNTIL TIME ‘dd-mon-yyyy hh24:mi:ss’ (or CANCEL or CHANGE number)
4. ALTER DATABASE OPEN RESETLOGS
Log sequence number will be re-initialized.
SHUTDOWN
Take full backup of database
1. STARTUP MOUNT
2. Restore all data files (including system, data, index, undo but not control file or redo log files)
3. RECOVER DATABASE UNTIL TIME ‘dd-mon-yyyy hh24:mi:ss’ (or CANCEL or CHANGE number)
4. ALTER DATABASE OPEN RESETLOGS
Log sequence number will be re-initialized.
SHUTDOWN
Take full backup of database
No comments:
Post a Comment