OCM 11g Preparation - Create Physical Standby Database with real-time apply

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.
  • 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.

Path to Documentation:

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


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.