Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?

Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 7 Sep 2007 16:23:55 -0700
Message-ID: <bf46380709071623m22bc4cb8re1fb96374ef3ad7a@mail.gmail.com>


On 9/7/07, Jay.Miller_at_tdameritrade.com <Jay.Miller_at_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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 07 2007 - 18:23:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US