A new feature in Oracle 21c is the ability to create a Data Guard Far Sync Instance via Data Guard Broker. The DGMGRL command CREATE FAR_SYNC automates the entire process of creating the Far Sync database instance for a Data Guard Configuration. It internally runs the RMAN DUPLICATE TARGET DATABASE FOR FARSYNC command and creates […]
The Data Guard Broker PREPARE DATABASE FOR DATA GUARD command configures a database to be used as a Primary Database in a Data Guard Broker configuration. It enables and sets a number of database parameters like LOG_BUFFER, DG_BROKER_START, STANDBY_FILE_MANAGEMENT, DB_BLOCK_CHECKSUM etc. It also enables FLASHBACK and ARCHIVELOG for the database and creates the Standby Redo […]
One of the new Data Guard Broker features introduced in Oracle 12c Release 2 was the ability to set multiple Fast Start Failover (FSFO) targets with the broker determining which was the ideal Data Guard standby database to perform a failover operation to. This was configured via the property FastStartFailoverTarget. In this example we have […]
Oracle 12c Release 2 introduced the ability to execute a DGMGRL command script via the @ command as well as the ability to call host operating system commands via the HOST command. A number of new Data Guard Broker features have been introduced in Oracle 18c like the DGMGRL commands like VALIDATE DATABASE SPFILE, VALIDATE […]
New in Oracle 12c Release 2 is the ability for scripts to be executed through the Data Guard broker DGMGRL command-line interface very similar to like say in SQL*Plus. DGMGRL commands, SQL commands using the DGMGRL SQL command, and OS commands using the new HOST (or !) capability can be bundled into a script file […]
This note describes the commands used to create a Data Guard broker configuration using the command line dgmgrl interface. This can also be done via the Enterprise Manager Grid Control GUI as well and the assumption is that there is a Physical Standby database in place and redo transport and redo apply have already been […]
