Re: Recover until CANCEL - how does it work??

Using "until cancel" usually results in a partial or incomplete recovery.
Which leads to the question: why would you cancel? Well, one reason would be that you may have a corrupt/missing archived log file that prohibits
a full recovery in which case you will want to recover at least to that point in
time, or there may be some set of circumstances where you would only want
to do a recovery up to a certain point in time because of some undesirable
event that occurred after that point. Will the database be consistent and will
referential integrity constraints exist? Sure, at least up to the point in time
the the database was successfully recovered to.

M.Landa

Roy Varghese wrote:

> Hey people, one quick question...if you recover a
> database using the
> RECOVER UNTIL CANCEL option, how consistent will
> the database
> be when you open it? Will all referential
> integrity constraints still be valid?
> Can you recover the database until the last
> commited transaction at the
> point of CANCEL? Please respond.
>
> All answers appreciated ! Thanks in advance !!
>
> Roy Varghese
>
> email: rvarghese_at_ibm.net
Received on Sun Feb 08 1998 - 00:00:00 CST