Recovery from a total oracle disaster

[azigy]

Hi,
I am testing out a disaster recovery plan for ur databases. We have oracle 10g on a windows 2003 sever. Now my question is how do I recreate my databases from my backups after say a complete system crush. let say i get a new harddirve for my server and reinstall oracle. how do I get back my databases from my backups.
Thanks,
Harold.

[skhanal]

Depends on what type of backups you have.

[azigy]

I am using incremental updated backups
Thanks

[skhanal]

You can use RMAN to restore full backup and incremental backup. You will need to have instance setup before you can restore.

[azigy]

I have installed a new oracle instance. My problem is how to get my database back from my backups. Let say my database name was DB101. Now in my new instance I can not connect to DB101. So how do i get back DB101 From my backups.

Thanks

[skhanal]

Does the new instance has same name as the one you had before? If not then you can only import data from the export created for DB101.

To restore database, you have to put the database in mount state and run

restore database

command. If you have backup created using RMAN then you need to use RMAN to restore it.

[azigy]

The instance Name is DB101