December 2014 archive

If your an OCP, this is already in your blood. 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 (with or without prior full backup) …

Continue reading

This is one of those topics that when I stopped to study, I saw and I thought, whoa, I never heard about that... After doing the process 2 or 3 times, you will have it memorized. For this topic, I recommend doing it 1 time reading this doc and 2 times using only oracle documentation: Oracle …

Continue reading

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