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 …

Continue reading

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 …

Continue reading

Dec 03

Oracle Data Guard Fast-Start Failover and Oracle Wallet

The Fast-Start Failover Observer is an Oracle Data Guard Broker component that allows the DBA automate failover tasks and have more peaceful nights of sleep. What a few DBA know, however, is that it can work in conjunction with the Oracle Wallet, so that you can remove the password of your scripts. Consider the scenario …

Continue reading

Nov 28

OCM 11g Preparation – Create Physical Standby Database with real-time apply

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

Nov 28

ORA-12853, ORA-04031 and ORA-06512: at “SYS.UTL_RECOMP”, line 865

Those days I created a really small 11.2.0.4 database in a very powerful Sun Sparc 64 processors server. I’ve set up the database to use as memory_target the minimal possible: 524M. I planed to increase this size later after preparing the DB Server. When I started enabling the Database Vault, I received the following error …

Continue reading