DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
         :content-type:references;
        b=MCs43Y+P6zdkM9vmWD4BvOg+Gjvh3r/GdSU4hXT1r+vwNHpgS8yB+VZ3RYXzZcSFhb
         8CI0RnXU6XbwYg3t2hJsAFWEDPnOQsriIruM18oNnw2J+cap5XKxsMO5u7BzUbe7FEX9
         71+YhYhYHW5ipf1qNv5oSewvX3ai7Q/g6Uj6A=
Message-ID: <486b2b610807062204m22055d41vf606ac44dce3a6af@mail.gmail.com>
Date: Mon, 7 Jul 2008 07:04:43 +0200
From: "Stefan Knecht" <knecht.stefan@gmail.com>
To: bdbafh@gmail.com
Subject: Re: no archivelog incomplete recovery?
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <910046b40807062014o52fdbb8cj1fcce68c373b5bfe@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_6407_29086689.1215407083770"
References: <a4c7620807061657v77c65767q192cbef5cebf1dcb@mail.gmail.com>
	 <910046b40807062014o52fdbb8cj1fcce68c373b5bfe@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: knecht.stefan@gmail.com
------=_Part_6407_29086689.1215407083770
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@gmail.com> wrote:

>
>
> On Sun, Jul 6, 2008 at 7:57 PM, John Smith <john40855@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@trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

------=_Part_6407_29086689.1215407083770
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

You need to recover to be able to open the database with resetlogs.<br><br>Stefan<br><br><div class="gmail_quote">On Mon, Jul 7, 2008 at 5:14 AM, Paul Drake &lt;<a href="mailto:bdbafh@gmail.com">bdbafh@gmail.com</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d"><br><br><div class="gmail_quote">On Sun, Jul 6, 2008 at 7:57 PM, John Smith &lt;<a href="mailto:john40855@gmail.com" target="_blank">john40855@gmail.com</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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.&nbsp; the answer they give is to restore a consistent backup, startup in mount mode, perform a cancel based recovery, and open with resetlogs.<br>


<br>Is that answer correct?&nbsp; I didnt think you could do a recovery if you arent in archivelog mode.<br>
</blockquote></div><br><br></div>Hmm.<br>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.<br>One could force recovery, telling it that the controlfile was a backup controlfile (even if it was not).<br>

But if no archived redo logs (or online redo logs) are being applied, then what is the point of performing a cancel-based recovery?<br><font color="#888888"><br>Paul<br><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>=========================<br><br>Stefan P Knecht<br>Senior Consultant<br>Infrastructure Managed Services<br><br>Trivadis AG<br>Europa-Strasse 5<br>CH-8152 Glattbrugg<br>
<br>Phone +41-44-808 70 20<br>Fax +41-808 70 12<br>Mobile +41-79-571 36 27<br><a href="mailto:stefan.knecht@trivadis.com">stefan.knecht@trivadis.com</a><br><a href="http://www.trivadis.com">http://www.trivadis.com</a><br>
<br>OCP 9i/10g SCSA SCNA<br>=========================

------=_Part_6407_29086689.1215407083770--
--
http://www.freelists.org/webpage/oracle-l