In a previous post we have looked at some of the new features for the Data Guard Broker Observer in 19c like the ability to run the Observer in OBSERVE ONLY mode as well as some other features like multiple Observers and multiple failover target standby databases. In this note we look at how Master […]
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 […]
This note outlines the steps to create an Oracle 19c Container Database via DBCA and then use the RMAN DUPLICATE command to create an Oracle 19c physical standby Container Database. Download the note ….
This note illustrates the steps required to upgrade an Oracle 12c Data Guard Primary and Standby database configuration to Oracle 19c and the convert the Oracle 19c non-CDB Primary/Standby databases to an Oracle 19c Pluggable Databases hosted in an Oracle 19c Data Guard Container CDB. Download the note ….
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 […]
One of the new features in Oracle 19c is that either when a flashback or point-in-time recovery is performed on the primary database in an Oracle Data Guard configuration, the same operation is also performed on the standby database as well. Following a flashback or PITR operation, the primary database is then opened with the […]
One of the real nice new features in Oracle 12c Release 2 (126.96.36.199) is the ability to create an Oracle Data Guard Standby Database using DBCA (Database Configuration Assistant). This really does simplify the process of creating a standby database as well and automates a number of steps in the creation process which were earlier […]
This note describes the procedure of creating an Oracle 188.8.131.52 Data Guard Physical Standby database with a two-node Real Application Cluster (RAC) Primary and Standby database on an Oracle Exadata X5-2 eight rack. The procedure will use RMAN for the creation of the Physical Standby database and will use the DUPLICATE FROM ACTIVE DATABASE method […]
This note describes the procedure used to perform a minimal downtime platform migration from Windows to Linux as well as a database upgrade from Oracle 184.108.40.206 to Oracle 12c (220.127.116.11). We create a Data Guard physical standby database using the DUPLICATE FROM ACTIVE DATABASE feature, followed by a switchover and then we activate the standby […]
This note describes how to run an Initial Load along with Change Data Capture from a source Oracle 11g R2 Active Standby database (ALO Archived Log Only mode capture) to a MS SQL Server 2012 target database. The table is a 6.3 million row table – AC_AMOUNT in the IDIT_PRD schema. Steps Create the Initial […]
In a previous post we had seen how to setup and create an Oracle 12c Data Guard Physical Standby Database. Remember Data Guard is set up at the CONTAINER database level and not at the PLUGGABLE database level. In this example we will see how we can simply unplug a database from a non Data […]
This note examines how to create an Oracle 12.1.0 physical standby Active Data Guard database using the RMAN DUPLICATE FROM ACTIVE command. We will be creating the data guard configuration in a 12c Container Database. Remember – in 12c Data Guard is set up at the Container level and not the individual Pluggable database level […]
This note describes the procedure used to perform a rolling database upgrade from 18.104.22.168 to Oracle 12c Release 1 using a Data Guard physical standby database and transient logical standby database. The average time to perform a database upgrade would be in the region of one to two hours and for many organizations even that […]
This note describes the procedure used to setup and configure a Data Guard Cascaded Standby database environment. The cascading standby database receives redo from the Primary database and then this redo is cascaded to one or more cascaded standby databases. So the cascaded standby database does not receive its redo directly from the Primary database […]
A common DBA task is to perform regular clones and database refreshes of the production database for the purpose of setting up training or test or development environments. If we are having a physical standby Data Guard environment, then we can easily offload the potentially I/O and CPU intensive backup process required for creating these […]
After a data guard failover operation has been performed, instead of recreating the original primary database as the new standby database, we can use the FLASHBACK DATABASE to SCN command instead. This is particulary important in case the size of the primary database would mean a long backup and restore RMAN operation to recreate the […]
If we have a number of Data Guard physical standby database environments to manage, the following report can help us quickly identify the log transported and log applied status of the Primary and Standby databases in our environment and if any standby database is lagging behind the primary as well. The script can also be […]
Oracle 11g introduces the Snapshot Standby database which essentially is an updateable standby database which has been created from a physical standby database. We can convert a physical standby database to a snapshot standby database, do some kind of testing on a database which is a read write copy of the current primary or production […]
This note will provide a guide to setting up an active-active DR solution for the 10g EM Grid Control Oracle Management Server (OMS) Repository database using Oracle Data Guard. Download ….