Case studies for Recovery Using RMAN

[anuragmin]

Hi,
Where do I find case studies depicting various disaster scenarios and recovering from them using RMAN.

I checked out the Oracle 8.0.5 documentation and saw that it does not cover all of them.

For example I have lost 2 datafiles because of media failure and just want to recover those from the backup set. The examples given in the documentation tell how to restore and recover the whole database.

Any pointers about the case studies and also how to restore only the lost datafiles will be greatly appreciated.

Thanks for all the times this forum has helped me solve the problems.

Anurag

[sambavan]

Here are some recovery senarios:

Scenario1: Restoring a database in NOARCHIVELOG Mode
Scenario2: Restoring datafiles to differnt location
Scenario3: Recovering tablespace
Scenario4: Relocating a tablespace
Scenario5: Incomplete recovery of a database
Scenario6: Restoring a database to a previous incarnation

Things are explained to an extent at :
http://www.oradoc.com/ora817/server.817/a76990/toc.htm


Sam