Re: no archivelog incomplete recovery?

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
=========================

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