If your an OCP, this is already in your blood.
What you need to do here is do all kinds of complete restore/recovery operations.
Practice the following:
- Losing one or multiple logfiles (members or entire groups, active or inactive)
- Losing one or all controlfiles
- Losing one or all datafiles (with or without prior full backup)
- Losing spfile
- Losing everything (including spfile)
- Database and Tablespace point in time recovery
I also recommend studying the situation where you have a data guard environment and you need to restore missing controlfile/datafiles on your primary using the standby (and vice versa).
Path to Documentation:
Oracle Database Backup and Recovery User's Guide -> Performing RMAN Recovery: Advanced Scenarios
Oracle Data Guard Concepts and Administration -> 11 Using RMAN to Back Up and Restore Files
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!