A time ago, the problem that I used to face was the failure of the recovery part of the duplicate script for any problems (like forgetting to set the db_recovery_area_dest_size big enough to hold the archives that will come from duplicate) and I ended up having to start the DUPLICATE command all over again. The recovery …
Jan 09
OCM 11g Preparation - Mantain recovery catalogs
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 …
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
