Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
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-lReceived on Fri Sep 07 2007 - 18:23:55 CDT