troubleshooting Question

Backup ASM database

Avatar of miyahira
miyahiraFlag for Peru asked on
Oracle Database
6 Comments3 Solutions673 ViewsLast Modified:

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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros