Re: Database recovery problem - solved

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Tue, 25 May 2010 09:23:54 +0300

I just talked with the guys who handle this problem.
They say that "end backup" does not help as oracle wants logs from March for recovery.

They succeeded, with oracle support, now to bring up the database using two underscore parameters:
1) Allow reset log corruption - to restart the database without recovery
2) Corrupted rollback segments - because the database tried to back out uncommitted transactions.

After using these parameters the database started and now we exporting it and will build new database and do import.

Adar Yechiel
Rechovot, Israel



Yechiel Adar wrote:
We have a situation:
1) In March, someone issued "alter database begin backup".
2) Last Sunday the server was rebooted.
3) The database did not come up because he needs recovery.
4) When we try to recover, oracle wants archive logs from March, and they are not available.
5) RMAN restore and recover also wants old logs.

Any suggestions?

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


Other related posts:

  • » Re: Database recovery problem - solved - Yechiel Adar