Chapter14 User-Managed Incomplete Recovery

Types of Incomplete Recovery

• Time-based recovery
• Cancel-based recovery
• Change-based recovery

Incomplete Recovery

• Follow all steps carefully
• Take whole database backups before and after recovery.
• Always verify that the recovery was successful.
• Back up and remove archived logs.

Incomplete and the Alert Log

• Check the alert log before and after recovery
• Contains error information,hints,and SCNs

User-Managed Procedures    [不完全恢复的过程]

• Shutdown and backup the database
• Restore all datafiles.Do not restore the control file,redo logs,password file,or parameter file.
• Mount the database.
• Reover the datafiles to a point before the time of failure.
• Open the database with RESETLOGS
• Perform a closed database backup.

RECOVER Command Overview

• Recover a database until cancel:

Recover DATABASE until cancel

• Recover a database unitl time:

RECOVER DATABASE until time '2002-07-24:14:22:03'　　　　　　[demo]

• Recover using backup control file

RECOVER DATABASE until time '2002-07-24:14:22:03' using backup controlfile

 Change-Based Recovery

• Digoal`s video:Incomplete Recovery by using LogMiner

http://www.boobooke.com/v/bbk1260

http://www.boobooke.com/v/bbk1261

使用RMAN 进行数据库的不完全恢复，通过LogMiner获取SCN号;