Category: OCM 11g Preparation

The "Switchover and switch back" is extremely easy to perform when you have the broker configured. However, for OCM, you must know how to perform it using also the manual approach. For this topic, I recommend exercising the following points: Switchover and switch back using sqlplus. Do the same using dgmgrl (easy). Try also using the …

Continue reading

The Fast-Start Failover Observer is an Oracle Data Guard Broker component that allows the DBA automate failover tasks. Having it set up is a requirement to have more peaceful nights of sleep as well as a good OCM exam score. For this topic, I recommend exercising the following points: Keep in your brain all requisites prior starting …

Continue reading

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 …

Continue reading

We already talked about creating tablespaces in the other exam topic "OCM 11g Preparation – Create and manage temporary, permanent, and undo tablespaces". For OCM, to have a topic about Big File Tablespace (BST) set aside, is because they want you to fully understand it. The advantages of BST are more related to the hardware, OS …

Continue reading

So, create and manage database configuration files. What is this? Basically PFILE and SPFILE. So you may ask, do I need to know by heart and how to use the 260 parameters (not including the hidden ones)? Off course not. You are studying for OCM, not for any memorization championship. But what you must know is …

Continue reading