Create a Database Standby (Data Guard) on OCI Oracle Cloud for a DB System Database
In one of my previous post I have created a 12c DB System on Oracle Cloud OCI.
Now for that database I am going to create a Dataguard for that database. In OCI we need to have an Enterprise version to create a data guard.
Steps:
1) Login to OCI console and go to Database Services. Select the Database and click on Data Guard Association.
2) But Wait ....!!! Before creating the dataguard, let's create a database image. Go to Database details and follow below screenshots. This image will be needed while creating the dataguard
It takes some time to create the image.
Validate that the database image is created.
3) Now we will create DG. Go to navigation as given in point 1 and follow as below. Give the same shape as primary database(not mandatory) and choose the image created in step 2.
Click Next
Click on Enable Data Guard
It will take time to complete. Approx. 1 hr 25 mins
Process is running to provision the DG.
My Standby is created.
Lets connect to my Primary and Standby to verify
The standby host will also use same ssh keys as per the primary.
SQL> SELECT PROCESS,STATUS, THREAD#,SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY ;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 5 1 514
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
RFS RECEIVING 1 6 611431 1
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
MRP0 APPLYING_LOG 1 6 611430 2097152
12 rows selected.
Post a Comment
Post a Comment