Aug 07

OCM 11g Preparation - Configure connect time failover

This topic is pretty easy. You have all the default properties that you can list using the broker: FastStartFailoverThreshold = '30' OperationTimeout = '30' FastStartFailoverLagLimit = '30' CommunicationTimeout = '180' FastStartFailoverAutoReinstate = 'TRUE' FastStartFailoverPmyShutdown = 'TRUE' BystandersFollowRoleChange = 'ALL' To change any of them, all you need is to run: "EDIT DATABASE <database name> SET PROPERTY <property …

Continue reading

Aug 07

OCM 11g Preparation - Configure the data guard environment to reduce overheads of fast incremental backups on the primary database

In this topic, you must know hot to perform your backups from your physical standby databases. With this, you will reduce the overhead and concurrency of reading your datafiles in the primary as well as avoiding the incrementing of the redo generation caused by full block being written while in backup mode. To make your backups even faster, …

Continue reading

Aug 04

OCM 11g Preparation - Configure services using both Manual and Policy Managed methods

As the last topic of RAC, we need to know how to create Manual and Policy services (do not confuse with Admin / Policy managed databases). You can only create Policy managed services in Policy managed databases. Thus, this topic is a good opportunity to practice the conversion between Admin <-> Policy Managed databases. Practice: …

Continue reading

Aug 04

OCM 11g Preparation - Configure archiving

Enabling archive in a RAC environment is a pretty easy task. Probably this is most focused and easier topic from the whole list. So here, all you will need is: Shutdown your database (all instances); Startup in mount one of them; Enable archivelog; Startup open the current one; Startup all the rest; It's much better …

Continue reading

Jul 29

OCM 11g Preparation - Configure ASM for the shared disks and create a clustered database

We have seen in Create ASM Disk Groups and Implement ASM failure groups how to configure ASM for shared disks, but in my opinion, this topics wants you to go further in the disk level. It wants you to know how to: create a disk partition in a shared disk; oracleasm createdisk (one node) / oracleasm scandisks (other nodes) …

Continue reading