Re: no archivelog incomplete recovery?
Date: Mon, 7 Jul 2008 07:04:43 +0200
Message-ID: <486b2b610807062204m22055d41vf606ac44dce3a6af@mail.gmail.com>
You need to recover to be able to open the database with resetlogs.
Stefan
On Mon, Jul 7, 2008 at 5:14 AM, Paul Drake <bdbafh_at_gmail.com> wrote:
>
>
> On Sun, Jul 6, 2008 at 7:57 PM, John Smith <john40855_at_gmail.com> wrote:
>
>> I am studying for the OCP, and one of the practice test questions is how
>> to recover from a lost active online redo log in noarchivelog mode. the
>> answer they give is to restore a consistent backup, startup in mount mode,
>> perform a cancel based recovery, and open with resetlogs.
>>
>> Is that answer correct? I didnt think you could do a recovery if you
>> arent in archivelog mode.
>>
>
>
> Hmm.
> If the backup were consistent (a cold backup of a database in noarchivelog
> mode, or an rman backup while the database is in a mount state) then no
> recovery would be required.
> One could force recovery, telling it that the controlfile was a backup
> controlfile (even if it was not).
> But if no archived redo logs (or online redo logs) are being applied, then
> what is the point of performing a cancel-based recovery?
>
> Paul
>
>
-- ========================= Stefan P Knecht Senior Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht_at_trivadis.com http://www.trivadis.com OCP 9i/10g SCSA SCNA ========================= -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 07 2008 - 00:04:43 CDT