Recover corrupted database

If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?

Questions by shanthiavari

Showing Answers 1 - 6 of 6 Answers

kalpeshbanokar

  • Jul 24th, 2008
 

Succesful backup is possible iff there is "Archive Mode" is on.
that is database is in Archive Mode.
and if it's off
then there are only 99.9% chances
through
Group1 or Group2 of Online Redo log files.

  Was this answer useful?  Yes

m4k4v3l1

  • Jul 1st, 2009
 

Things Useful For Complete Recovery :

1- Last Valid Backup

2- Dump Files

3- Archive Logs


- If You Have a Valid Backup on Another Disk Rather Than The Damaged One , You Can Recover The Database till The Time Of This Backup.

- If You Have Archive Logs till The Time Of Disaster , You Can Recover The Database to The Point Of The Last Commit .

- If You Don`t Have Backup Or Archive Logs , You Can Use Dump File To Restore Files Back To Their Place .

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions