Using OEM 12c to Manage Database Recovery After Server Failure
We are late to the game and moving slowly from 11g to 12c for OEM. Let me posit the following in hopes that 12c has some functionality that 11g did not.
After database failure, we manage our current database recovery using a number of scripts and processes by hand on the database server. These include the following:
- Connect to RMAN repository
- Startup force database in nomount state and recover controlfile and spfile from MML
- Shutdown database
- Start database in mount state with recovered controlfile and spfile
- Recover datafiles and archive logs from MML
- Restore database and archive logs
- Open database with reset logs option