Incomplete Recovery of Oracle Database

Incomplete Recovery

Incomplete Recovery of Oracle Database

	An important table was dropped. (use Time-based Recovery)
	Bad data was committed in a table. (use Time-based Recovery)
	Complete Recovery fails because an Archive Log is lost. (use Cancel-based Recovery)
	A Tablespace has been dropped. (Recovery using a backup control file)
	Loss of all unarchived Redo Logs and the datafile. (use Cancel-based Recovery)
	Loss of Current Redo Logs -- database Open, but in a "Hung" state.
	Loss of Current Redo Logs -- database Closed.
	Recovery through Resetlogs -- if the media failure occurs before the backup is completed, this recovery might be required. (Use Change-based Recovery)

Types of Incomplete Recovery

	Time-based Recovery
	Cancel-based Recovery
	Change-based Recovery (Used in a Distributed Environment)

Recovery Steps

	Check Alert Log before and after Recovery.
	Shut down and perform a whole closed database back up (precautionary measure). Don't over write the previous back up. (make this one backup 02)
	Restore all datafiles ONLY from backup 01. Take your database back in time.
	Mount the database and Recover the datafiles before the time of failure.
	Open the database with "resetlogs" option.
	Discards any redo information that was not applied during recovery, ensuring that it will never be applied.
	Perform a whole closed database backup.

Send mail to mike@infomaxweb.com with questions or comments about this web site.
Copyright © 2003 Infomax
Last modified: 10/27/06