RE: recover database question

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 15 Jun 2004 11:45:50 -0400
Message-ID: <004c01c452ef$d598d180$8459699f@vttaxnet.tax.state.vt.us>

See answers inline: Note, you can set an until time inconjunction with the until cancel. HTH, Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jos
Sent: Tuesday, June 15, 2004 8:35 AM
To: oracle-l_at_freelists.org
Subject: recover database question

List,
What the difference in doing the following two: recover database using backup controlfile until cancel

This will only be possible if you don't need any archivelogs to have the database consistant. If what you need is still in the redo logs than you can cancel the recovery and it will be ok. and
recover database using backup controlfile
=> Oracle prompt for archive log

type CANCEL once all archivelogs are done.

This will work if you have all of the archivelogs needed ir can restore them from backupsets. When you have applied all archived logs and there is only a redo log left, you can cancel.

You will get a message if you can't do either operation which will let you know that you won't have a consistant recovery and an open resetlogs will fail.
Regards,
Jos

Find local movie times and trailers on Yahoo! Movies.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 15 2004 - 10:42:45 CDT