Catalogs are the best place to keep your database records, as you can keep a long history and also be safe about your backup locations in case you lose your controlfile. The catalog also allow you to share the backup across the data guard instances. You need to do all sort of operations that involve …
Dec 23
OCM 11g Preparation – Use Recover Manager to perform complete database restore and recovery operations
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) …
Dec 19
OCM 11g Preparation – Create and Manage a tablespace that uses NFS mounted file system file
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 …
Dec 03
OCM 11g Preparation – Switchover and switch back
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 …
Dec 03
OCM 11g Preparation – Configure the Observer
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 …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
