| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Recover until CANCEL - how does it work??
On Fri, 06 Feb 1998 11:36:17 -0600, Roy Varghese <rvarghese_at_ibm.net> 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 !!
Sure, data consistency is guaranteed, no matter if you apply all of the archived redo logs or only until certain redo file or even if you stop somwhere in the middle of the particular redo file (point-in-time recovery).
All commited transactions from the recovered portion of the redo log files are written to the database and all the transactions that were not commited at the time when recovery process stopped are automaticaly rolled back immediately after roll-forward process is ended.
>Roy Varghese
>
>email: rvarghese_at_ibm.net
Regards,
Jurij Modic Republic of Slovenia jurij.modic_at_mf.sigov.mail.si Ministry of Finance ============================================================The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Feb 07 1998 - 00:00:00 CST
 |
 |