| Share this post! | Vote this! |
|
Incomplete recovery can mean restoring a database to a specific
point in time (date and time), a specific SCN (system change number) or
sequence number (archive log). You normally restore all the datafiles
and controlfile (only required if physical structure has changed), any
archived redo logs but you do not restore the redo log files (not
normally backed up).
If you lose all copies of the current logfile group perform a incomplete recovery upto the last log switch, also if you recover tablespaces that are in a different time to other tablespaces, they must be all the same time.
Incomplete recovery is always done in mount mode and will use the controlfile, a incomplete recovery can only be performed if you have SYSDBA privilege. Use v$log_history to obtain the archive redo logs thread and sequence numbers if performing a sequence number recovery.
The sequence for incomplete recovery recover is: more...
If you lose all copies of the current logfile group perform a incomplete recovery upto the last log switch, also if you recover tablespaces that are in a different time to other tablespaces, they must be all the same time.
Incomplete recovery is always done in mount mode and will use the controlfile, a incomplete recovery can only be performed if you have SYSDBA privilege. Use v$log_history to obtain the archive redo logs thread and sequence numbers if performing a sequence number recovery.
The sequence for incomplete recovery recover is: more...
0 comments:
Post a Comment