OCM 12c Preparation - Create a physical standby database

Creating an physical standby database is not an easy task. It involves a lot of steps, as duplicating the primary database, changing some parameters and database configuration. Than you need to create the standby database and finally synchronize and enable it with real-time apply.

For this topic, I recommend exercising the following points:

• Duplicate from active for standby.
  • Practice here skipping some PDBs from copying.
  • Also, practive adding PDB's later on primary and choosing whether to add it on the standby or not.
• Keep in your brain all requisites prior starting the configuration (force logging, standy redos, etc).
• Create a physical standby from scratch (setting manually all the parameters).
• Create a physical standby using dgmgrl (this is the best approach if available on the exam)
• Create a physical standby using EM (pay attention at this method, can save you A LOT of time. Preferable if allowed.).
• Enable real-time apply.

In 12c we have the new Far Sync instance and Redo Routes. Although in my opinion the should have created a specific topic naming Far Sync if it is in exam, I recommend you to study and be able to add it in your DG environment after everything is built.

Consider yourself ready when you are able to create, configure and align a Physical Standby (from a single instance as startup point) in 20 minutes + 10 minutes for Far Sync. Try to practice without using any GUI (not even netmgr to create static listener).

Path to Documentation:

Oracle Data Guard Concepts and Administration -> Creating a Physical Standby Database

+3