Category: OCM 11g Preparation

OCM 11g Preparation

OCM 11g Preparation - Convert the standby to a snapshot standby

Standby databases can become snapshot standbys with a single command line over DG Broker. This is one of the most amazing things in Data Guard and very useful to test your scripts before running them on production! What I recommend in this chapter is: Convert a physical standby to snapshot standby (and vice-versa) using Broker. …

Continue reading

OCM 11g Preparation - Configure archivelog deletion policy for the Dataguard configuration

When you are in a DG environment, you need to decide what to do with your archivelog and define a retention policy for them. You can do it using the "CONFIGURE ARCHIVELOG DELETION POLICY" option of RMAN. You can define it to either: BACKED UP integer TIMES TO DEVICE TYPE deviceSpecifier; TO APPLIED ON [ALL] …

Continue reading

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

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

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