Jul 31

OCM 12c Preparation – Start, stop, configure, and administer Oracle Grid Infrastructure

Like 11g, configure and administer Grid Infrastructure can be done using the 2 main provided tools: “crsctl” and “srvctl”. srvctl start/stop -> Start/Stop the cluster services. srvctl realocate -> Move some service, like the scan listener. srvctl status -> Check if service is running. srvctl config -> Display configuration. srvctl modify -> Change configuration. crsctl start/stop crs -> …

Continue reading

Jul 28

OCM 12c Preparation – Configure fast start failover

This topic is similar to the one related to the Observer in 11g OCM Exam. 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 …

Continue reading

Jul 28

OCM 12c Preparation – Restore the standby database to its normal function

This topic is just telling you exactly to UNDO what you did in the previous topic: convert now from snapshot standby back to a physical standby. Just do the opposite way. However, as the topic title is not entirely clear, this could also means to restore the standby database to its normal function after a …

Continue reading

Jul 28

OCM 12c Preparation – Make the standby database available for testing

Make the standby database available for testing = Convert your Physical Standbys into Snapshot Standbys Standby databases can become snapshot standbys with a single command line over DG Broker or SQLPlus. What I recommend in this chapter is: Convert a physical standby to snapshot standby using Broker. (preferable) The same above using SQLPlus. That’s it! …

Continue reading

Jul 28

OCM 12c Preparation – Create a physical standby database

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