Re: no archivelog incomplete recovery?

Aren't you going to need to perform a resetlogs anyway - unless very lucky - backing up an online log won't produce a *reliable* file to restore anyway?

cheers

Niall

On Mon, Jul 7, 2008 at 12:09 PM, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

> The OP was referring to performing a recovery after lost online redo logs.
> If you don't have them backuped, you need to perform resetlogs, and for that
> you need to perform a "dummy" recovery.
>
> Cheers
>
> Stefan
>
> On Mon, Jul 7, 2008 at 12:05 PM, Paul Drake <bdbafh_at_gmail.com> wrote:
>
>> Stefan,
>>
>> If one restores a consistent backup set, no recovery is required.
>> As the database is in noarchivelog log, no logs are going to be applied.
>> The restored database is from an SCN prior to the online redo log having a
>> corruption or being lost.
>>
>> No resetlogs is required.
>>
>> Paul
>>
>>
>> On Mon, Jul 7, 2008 at 1:04 AM, Stefan Knecht <knecht.stefan_at_gmail.com>
>> wrote:
>>
>>> 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.completestreets.org/faq.html
>> http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
>>
>
>
>
> --
> =========================
>
> 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
> =========================
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l