Recovery options

[newbie]

Hello, what are the recovery options if I lost all of my data files and redo logs file. I do have a copy of hot backups and all archived log files. Based on this, I have to perform incomplete recovery right? Please help.

[ggnanaraj]

Hi

You can do the following...

1. Restore data files and redo log files. (redo logs from cold backup)

2. Create controlfile with RESETLOGS. (edit trace of controlfile)

3. RECOVER DATABASE WITH RESETLOGS

4. RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE

5. ALTER DATABASE OPEN RESETLOGS


HTH.

[anandkl]

I feel we need to use backup controlfile as the last option in recovery.
1.Mount u r database.
2.Restore your datafiles.
3.Recover database until cancel.
4.Alter database open resetlogs.

After the 4th command u can see your redo log files get created automatically.

Once you are done with the recovery dont forget to take a complete backup of the your database.This you need to do because your redo log files will be reset to sequence no 1 and your previous backup will not be of any use.

regards
anandkl