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

From: "Jared Still" <jkstill@xxxxxxxxx>
To: Jay.Miller@xxxxxxxxxxxxxxxx
Date: Fri, 7 Sep 2007 16:23:55 -0700

On 9/7/07, Jay.Miller@xxxxxxxxxxxxxxxx <Jay.Miller@xxxxxxxxxxxxxxxx> 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

References:

Hello OCP's.
From: Patrick O'Brien

Re: Hello OCP's.
From: Don Seiler

Re: Hello OCP's.
From: fmhabash

Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?
From: Jay.Miller

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

Other related posts: