We have Oracle RAC 11gR2 on Windows Server 2008, two nodes, and database is in a 2TB storage with ASM filesystem. The redologs, control files and datafiles are stored in ASM.
As I read once, a DBA should be paranoic. So, I'm creating an image file of C: drive for each node. In case something happens with Windows configuration or system corruption, I got a backup.
I know that I can generate database backups with RMAN and I am creating them. My question is about this scenario (which I haven't tested yet):
Suposse that my ASM filesystem get corrupted, but my Windows Servers 2008 are OK. Instances on Windows won't load because they won't find any database. In that case, how should I proceed to recover my database?
- Reinstall from scratch ASM filesystem? Should I create disk group with its original name?
- Restore RMAN backup to a new ASM filesystem? Is there any online manual about this specific point?
Any further comments about this will be very much appreciated.