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

Other related posts: