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 👍!