OCM 12c Preparation - Protect the database from loss of data due to any kind of failure

So, you need to know how to protect your database and how to resolve any kind of issue.

How to protect is the easier part, you must ensure your environment will be prepared for a catastrophic event:

• Enable Archivelog
• Enable Flashback
• Add Supplemental Log

Then perform a full backup of your CDB (including the PDBs)

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 from CDB
• Losing one or all datafiles from PDB (with or without the PDB backup after its creation)
• Losing spfile
• Losing everything (including spfile)
• Database, PDB and Tablespace point in time recovery
• Drop a PDB and do a PDB PITR just before it was removed
• Using Restore Points to flashback your database
• New Table Point In Time Recovery (using also the REMAP or dump file features)

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

+3