On this 2nd scenario we experience a total database loss.
The test database is built with 2 disk groups, datadg that contains all tablespaces, redo logs and control files, and Archdg that contains all archived logs.
To be able to simulate the disk group loss we need to shutdown the database, otherwise deleting the files inside ASM is not possible, once the database is down all files on the Disk Group are deleted.
The recovery steps include:
- Invoke rman, startup and restore the spfile
- Shutdown and restart with the restored spfile
- Restore the control file and mount the database
- Restore and recover the database
- Open the database first instance
- Open the second instance and all RAC services
Important! : Before running a crash scenario be sure to Backup the Database: Rman RAC on ASM Backup Script
Comments (1)
Why do you execute 'sql "alter system archive log current"' in your backup script? RMAN does it automatically while starting backup job. The only reason I can imagine you just want to be sure, you want to do everything explicitly. And I don't understand at all why you do it again in the end of the script.
Posted by Guest | May 11, 2007 3:47 PM
Posted on May 11, 2007 15:47