Setting up a Physical Standby at 19c

Oct 13, 2025 by thesweetdesigns.com 106 views

Oracle DataGuard between 11.2.0.4 (primary) and 19c (physical standby)

Oracle DataGuard is a high availability and disaster recovery solution that provides real-time data protection and replication between primary and standby databases. In this article, we will discuss the possibility of setting up a physical standby database at 19c and keeping it in sync with a primary database at 11.2.0.4.

Oracle DataGuard is a feature of Oracle Database that provides real-time data protection and replication between primary and standby databases. It allows for the creation of a standby database that can be used for disaster recovery, high availability, and data protection. There are two types of DataGuard configurations: physical and logical.

Physical Standby

A physical standby database is a complete copy of the primary database, including all data files, control files, and redo logs. The physical standby database is updated in real-time using redo logs from the primary database. This type of standby database is used for disaster recovery and high availability.

Logical Standby

A logical standby database is a read-only copy of the primary database, but it does not contain all the data files. The logical standby database is updated in real-time using redo logs from the primary database, but it only contains the data that is required for the application. This type of standby database is used for data protection and high availability.

Our production database is currently running on 11.2.0.4 and needs to be upgraded to 19c. Upgrading to a newer version of Oracle Database can provide many benefits, including improved performance, new features, and better security. However, upgrading to a newer version of Oracle Database can also be complex and time-consuming.

Setting up a Physical Standby at 19c

We can set up a physical standby database at 19c and keep it in sync with the primary database at 11.2.0.0.4. To do this, we will need to create a new standby database at 19c and configure it to receive redo logs from the primary database at 11.2.0.4.

Step 1: Create a New Standby Database at 19c

To create a new standby database at 19c, we will need to create a new database instance and configure it to use the 19c version of Oracle Database. We will also need to create a new control file and data files for the standby database.

CREATE DATABASE standby19c
  CONTROLFILE REUSE
  MAXLOGFILES 16
  MAXLOGMEMBERS 3
  MAXLOGHISTORY 1000
  MAXDATAFILES 1024
  MAXINSTANCES 8
  MAXLOGFILE 1024M
  CHARACTER SET AL32UTF8
  NATIONAL CHARACTER SET AL16UTF16
  EXTENT MANAGEMENT LOCAL
  UNDO TABLESPACE undotbs1
  DATAFILE 'standby19c.dbf' SIZE 1024M
  LOGFILE GROUP 1 ('standby19c_redo01.log') SIZE 1024M,
         GROUP 2 ('standby19c_redo02.log') SIZE 1024M,
         GROUP 3 ('standby19c_redo03.log') SIZE 1024M;

Step 2: Configure the Standby Database to Receive Redo Logs

To configure the standby database to receive redo logs from the primary database, we will need to create a new redo log file and configure the standby database to receive redo logs from the primary database.

ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo04.log' SIZE 1024M;
ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo05.log' SIZE 1024M;
ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo06.log' SIZE 1024M;

Step 3: Configure the Primary Database to Send Redo Logs

To configure the primary database to send redo logs to the standby database, we will need to create a new redo log file and configure the primary database to send redo logs to the standby database.

ALTER DATABASE ADD LOGFILE 'primary_redo01.log' SIZE 1024M;
ALTER DATABASE ADD LOGFILE 'primary_redo02.log' SIZE 1024M;
ALTER DATABASE ADD LOGFILE 'primary_redo03.log' SIZE 1024M;

Step 4: Configure the Standby Database to Receive Redo Logs from the Primary Database

ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo07.log' SIZE 1024M;
ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo08.log' SIZE 1024M;
ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo09.log' SIZE 1024M;

Step 5: Configure the Primary Database to Send Redo Logs to the Standby Database

To configure the primary database to send redo logs to the standby database, we will need to create a new redo log file and configure the primary database to send redo logs to the standby database.

ALTER DATABASE ADD LOGFILE 'primary_redo04.log' SIZE 1024M;
ALTER DATABASE ADD LOGFILE 'primary_redo05.log' SIZE 1024M;
ALTER DATABASE ADD LOGFILE 'primary_redo06.log' SIZE 1024M;

Step 6: Start the Standby Database

To start the standby database, we will need to start the database instance and configure it to use the 19c version of Oracle Database.

STARTUP MOUNT;
ALTER DATABASE OPEN STANDBY;

Step 7: Configure the Standby Database to Receive Redo Logs from the Primary Database

ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo10.log' SIZE 1024M;
ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo11.log' SIZE 1024M;
ALTER DATABASE ADD STANDBY LOGFILE 'standby19c_redo12.log' SIZE 1024M;

Step 8: Configure the Primary Database to Send Redo Logs to the Standby Database

To configure the primary database to send redo logs to the standby database, we will need to create a new redo log file and configure the primary database to send redo logs to the standby database.

ALTER DATABASE ADD LOGFILE 'primary_redo07.log' SIZE 1024M;
ALTER DATABASE ADD LOGFILE 'primary_redo08.log' SIZE 1024M;
ALTER DATABASE ADD LOGFILE 'primary_redo09.log' SIZE 1024M;

In this article, we discussed the possibility of setting up a physical standby database at 19c and keeping it in sync with a primary database at 11.2.0.4. We walked through the steps required to create a new standby database at 19c and configure it to receive redo logs from the primary database at 11.2.0.4. We also discussed the benefits of using Oracle DataGuard for high availability and disaster recovery.

Oracle DataGuard provides many benefits for high availability and disaster recovery, including:

Real-time data protection: Oracle DataGuard provides real-time data protection by replicating data from the primary database to the standby database.
High availability: Oracle DataGuard provides high availability by allowing the standby database to take over in the event of a failure of the primary database.
Disaster recovery: Oracle DataGuard provides disaster recovery by allowing the standby database to be used in the event of a disaster that affects the primary database.

In conclusion, Oracle DataGuard is a powerful tool for high availability and disaster recovery. By setting up a physical standby database at 19c and keeping it in sync with a primary database at 11.2.0.4, we can provide real-time data protection, high availability, and disaster recovery. We hope this article has provided a useful overview of the benefits and steps required to set up a physical standby database at 19c using Oracle DataGuard.
Oracle DataGuard between 11.2.0.4 (primary) and 19c (physical standby) - Q&A

In our previous article, we discussed the possibility of setting up a physical standby database at 19c and keeping it in sync with a primary database at 11.2.0.4 using Oracle DataGuard. In this article, we will answer some of the most frequently asked questions about setting up a physical standby database at 19c and keeping it in sync with a primary database at 11.2.0.4.

Q: What are the system requirements for setting up a physical standby database at 19c?

A: The system requirements for setting up a physical standby database at 19c are:

Oracle Database 19c (Enterprise Edition)
Oracle Database 11.2.0.4 (Enterprise Edition)
A minimum of 4 GB of RAM
A minimum of 2 CPU cores
A minimum of 100 GB of disk space

Q: What are the steps required to set up a physical standby database at 19c?

A: The steps required to set up a physical standby database at 19c are:

Create a new standby database at 19c
Configure the standby database to receive redo logs from the primary database
Configure the primary database to send redo logs to the standby database
Start the standby database
Configure the standby database to receive redo logs from the primary database

Q: What are the benefits of using Oracle DataGuard for high availability and disaster recovery?

A: The benefits of using Oracle DataGuard for high availability and disaster recovery are:

Real-time data protection
High availability
Disaster recovery

Q: Can I use Oracle DataGuard with other high availability solutions?

A: Yes, you can use Oracle DataGuard with other high availability solutions, such as Oracle Real Application Clusters (RAC) and Oracle Active Data Guard.

Q: How do I troubleshoot issues with Oracle DataGuard?

A: To troubleshoot issues with Oracle DataGuard, you can use the following steps:

Check the Oracle DataGuard logs for errors
Check the Oracle Database logs for errors
Use the Oracle DataGuard command-line utility to check the status of the standby database
Use the Oracle Database command-line utility to check the status of the primary database

Q: Can I use Oracle DataGuard with Oracle Cloud?

A: Yes, you can use Oracle DataGuard with Oracle Cloud. Oracle DataGuard is supported on Oracle Cloud, and you can use it to set up a physical standby database at 19c and keep it in sync with a primary database at 11.2.0.4.

Q: How do I upgrade my primary database from 11.2.0.4 to 19c?

A: To upgrade your primary database from 11.2.0.4 to 19c, you will need to follow these steps:

Create a new database instance at 19c
Use the Oracle Database upgrade utility to upgrade the primary database to 19c
Configure the new database instance to use the 19c version of Oracle Database
Start the new database instance

Q: Can I use Oracle DataGuard with Oracle Exadata?

A: Yes, you can use Oracle DataGuard with Oracle Exadata. Oracle DataGuard is supported on Oracle Exadata, and you can use it to set up a physical standby database at 19c and keep it in sync with a primary database at 11.2.0.4.

In this article, we answered some of the most frequently asked questions about setting up a physical standby database at 19c and keeping it in sync with a primary database at 11.2.0.4 using Oracle DataGuard. We hope this article has provided a useful overview of the benefits and steps required to set up a physical standby database at 19c using Oracle DataGuard.