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

Hi Jay

	What error message do you get? What version?
	How are you trying to open the database? Resetlogs?
	

Thanks
Riyaj

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com
Sent: Friday, September 07, 2007 3:41 PM To: oracle-l_at_freelists.org
Subject: Missing archive logs from middle of level 0 backup - can _allow_resetlogs_corruption help?

I'm trying to recover a table from an old level 0 backup, Unfortunately it looks like 2 archivelogs must have been deleted in the middle of the backup and are not available for restore.

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.  

Jay Miller
Sr. Oracle DBA
201.369.8355

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 07 2007 - 15:51:32 CDT