DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=pxSwpv/pOHWncTWaSSLUllPFkm6WXOz7IZ0VQeDDg92UXBwTex5LaxelyoT5ju0sEQMMODuwFvXtmIEKgGpB4MaGvCDM3urI6ZSupfsS2h7xBw4SMLtawDTFf1YFukFtS/foluV21gA/K5O2JsSUXn6xbtzZqRFTlAAHTWpt5bo=
Message-ID: <bf46380709071623m22bc4cb8re1fb96374ef3ad7a@mail.gmail.com>
Date: Fri, 7 Sep 2007 16:23:55 -0700
From: "Jared Still" <jkstill@gmail.com>
To: Jay.Miller@tdameritrade.com
Subject: Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
Cc: oracle-l@freelists.org
In-Reply-To: <304CF4722010DD4FA19829D09DDB956BAC3106@prdhswsemlmb01.prod-am.ameritrade.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_2419_32264601.1189207435771"
References: <46DD7C44.83D7.0016.0@controller.state.nv.us>
	 <716f7a630709051235y6c0656b5ra2741ca4afa32e15@mail.gmail.com>
	 <46E19DCE.5050604@gmail.com>
	 <304CF4722010DD4FA19829D09DDB956BAC3106@prdhswsemlmb01.prod-am.ameritrade.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: jkstill@gmail.com
------=_Part_2419_32264601.1189207435771
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 9/7/07, Jay.Miller@tdameritrade.com <Jay.Miller@tdameritrade.com> wrote:
>
> I've recovered up to the latest archivelog I have before the gap, but
> can't open the database.  Would setting _allow_resetlogs_corruption=true
> let me open it?  The database only needs to be open for a few hours to
> do some queries and then I'll be trashing it.
>

Open and SR and get help from support.

You will probably need to set _corrupted_rollback_segments as well.

Opening the database will likely require setting an event as well.

They will tell you you need to exp/imp the db, but that doesn't
really seem to matter in your case.


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

<br><br><div><span class="gmail_quote">On 9/7/07, <b class="gmail_sendername"><a href="mailto:Jay.Miller@tdameritrade.com">Jay.Miller@tdameritrade.com</a></b> &lt;<a href="mailto:Jay.Miller@tdameritrade.com">Jay.Miller@tdameritrade.com
</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I&#39;ve recovered up to the latest archivelog I have before the gap, but
<br>can&#39;t open the database.&nbsp;&nbsp;Would setting _allow_resetlogs_corruption=true<br>let me open it?&nbsp;&nbsp;The database only needs to be open for a few hours to<br>do some queries and then I&#39;ll be trashing it.<br></blockquote>
</div><br>Open and SR and get help from support.<br><br>You will probably need to set _corrupted_rollback_segments as well.<br><br>Opening the database will likely require setting an event as well.<br><br>They will tell you you need to exp/imp the db, but that doesn&#39;t
<br>really seem to matter in your case.<br><br><br><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br>

------=_Part_2419_32264601.1189207435771--
--
http://www.freelists.org/webpage/oracle-l