Introduction:- Data plays an important role in business operations on a day to day life. Without data, we can not perform our business operations. Data helps to generate business reports, With the help of data, all kind of business’s departments( Hr, Top management, Technical Departments, Accounts Departments etc.) can achieve their goals on time. Loss of data causes business loss. For reducing the loss of data we can find new technology in the market. Oracle Corporation provides  Oracle Data Gaurd as disaster recovery options. In this article, we are going to have the journey of  12c Physical stand by Database creation.

What is Physical stand by  Database?

A physical standby database is an accurate block-for-block copy of a primary database. A physical standby is maintained as an exact copy through a process called Redo Apply, in which redo data received from a primary database is continuously applied to a physical standby database using the database recovery mechanisms.A physical standby database can be opened for read-only access and used to offload queries from a primary database.

We have three option on how to configure a physical standby database.

  • Enterprise Manager Grid Control
  • Data Guard Broker
  • SQL*Plus

Creation of 12c Physical Stand by Database

1. Start up the standby instance

2. Create the standby database online from the primary database
It can be run from the standby database, i.e. the data will be pulled from the primary, or it can be run from the primary, where the data will be pushed to the standby.
In this example, we run the command on the standby:

3. Verify the instance is running fine:

4. Remove the multiplexed copy of each SRL group on the standby

Note: One of them may return ORA-00261 because it is being used by the transport service. To drop it, on the primary database, switch the logfile:

The current standby redo log file will be archived and then the multiplexed member can be dropped:

Verify the SRL group multiplexed members were removed:

5. Set the necessary Data Guard related initialization parameters for the standby database:

6. Start the Apply process in the Standby database:

7. Verify Data Guard configuration:
On the standby:

On the primary:

On the standby:

Query the physical standby database to monitor Redo Apply and Redo Transport services activity at the standby site:

8. Post Creation Steps:
8.1 Configure ARCHIVELOG DELETION POLICY in RMAN in both systems

8.2 In the standby system, set ORACLE_SID variable in the oracle os profile:

8.3 On the standby database, enable the Flashback Database:

8.4 Register the standby database in the Oracle Restart:

Notes
Standby Database Status

Notice:- that the standby database is running in MOUNT status. Therefore, no normal user can connect to it. This is the default initial behavior of a freshly created standby database. However, it can be opened to the normal users for read-only operations.
Shutting Down the Databases
1. Stop the standby database:

2. Stop the primary database.
3. Shutdown the appliances.
Note: Every time you start this created standby database (in MOUNT mode), you should issue the command to star the apply process (MRP):

I hope this article is useful . Thanks for spend valuable time to read.

Leave a Reply