Ritesh Singh

• Jul 7th, 2006

 

if the entire disk is corrupted and no backup is there don nothing sit and relax their is no possibility of recovery ...a backup is required for restoration and for recovery redo log and archive logs.

Once if you have theses than think of recovering ..a dba should always plan for the recovery scenario depending upon the criticality of the database.oracle provides 0% data loss facilty through data guard and online backup .its dba who has to decide. 

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 4th, 2006

 

Entire Disk is corrupted???

1) Production database runs on RAID Levels or on HUGE EMC Storage!

2) Changes are less for data loss on all disks - if it's on RAID! Yes - if there is a failure with Disk Controller which control?s the Disk?s.

3) Backup Strategy ? which you Business Implements!

Daily Hot Backups, Weekly Cold backups & Monthly Backup! If you have everything on Tape ? Veritas Net Backup or What ever! You are safe!

As a DBA your responsibility is to make sure that you have restore & recovery options available.

Cheers

more details

Ravi Prakash

gopi

• Mar 7th, 2015

 

Use disaster recovery just startup stanby database . if the database doesnt have any stanby database, then go to youtube watch funny videos.. and relax