Oracle 18c-Performing a Data Guard Switchover using DBCS Console

         Performing a Data Guard Switchover using DBCS Console

Description:- 

  • In this article we are going to perform oracle 18c dataguard Switchover step by steps using  DBCS (Oracle Database Cloud Service Console)
  • we can Perform the Switchover Operation using DBCS (Oracle Database Cloud Service Console) Or dbaascli utility

Check this link how to create oracle database 18c  dataguard

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Let’s start the Demo:-
Both Primary and Standby database already configured
Check the link Oracle 18c-Configure Data Guard On Oracle Cloud Service Here

Step1:-Open the Oracle Database Cloud Service console

Oracle 18c-Configure Data Guard DetailsStep2:-Before Swithover check the database level.

Primary Side 

Standby Side

Overview Picture

Step3:-From the menu we need select the Switchover button, and then confirm the action.Step4:-Switchover operation is started using DBCS Console and databases in Maintenance mode

Step5:-Swithover Successfully Completed using DBCS Console.

Step6:-After Swithover check the database level.                                                                                                select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Primary Side

Standby Side

Reference:-
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/data-guard-switchover.html

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba

 

Oracle 18c-Configure Data Guard On Oracle Cloud Service

                  Configure oracle 18c Data Guard on Oracle Cloud 

Description:-

  • in this article we are going to see how to configure oracle 18c Dataguard on Oracle Cloud
  • Using Oracle cloud account we are going to configure the Dataguard
  • Creating a Free Account In Oracle Cloud Here
  • Oracle Data Guard Provisioning in Oracle Cloud
    -Primary on Premise, DR in Oracle Cloud
    -Primary and DR both in Oracle Cloud
  • In this article we are going configure 2nd method(Primary and DR both in Oracle Cloud)
  • Oracle cloud provides fully automated setup of your primary and Standby database. Here your primary and DR both databases reside in Oracle cloud

Let Start’s the Demo:-

Step1:- Login to Oracle database Cloud Service Wizard
Click Oracle Cloud My services->Database

Step2:-Oracle Database Cloud Service click create instance button

Step3:- Select Required Software release
(The option 18.1.0.0,12.2.0.1,12.1.0.2 or 11.2.0.4)

-From the Instance Name select the Chennai
-From the Description select the Dataguard
-From the Software Release list, select Oracle database 18c
-From the Software Edition list, select Enterprise Edition.
-From the Database Type list, select Single Instance with Data Guard Standby.

Then click Next to continue.

Step4:- Fill required details in Service details

-For DB Name (SID), enter Chennai. PDB Name enter PDB1
-Set the administrative password (this is sys password).
-For Usable Database Storage (GB), enter 25.
-for Total Data File Storage (GB), enter 88.5
-From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM
-For SSH Public Key, enter the Public Key.
-From Backup Destination list,select None
-From the Standby Database Configuration, select Disaster Recovery

Then click Next to continue.

Step5:-  Verify the configuration details and click Create

Step5:-  Finally oracle 18c dataguard is ready use.

Step6:-Now Login to the Primary and Standby Server.

On Primary ServerOn Standby Server

How to generate and setup a SSH Key could be found here

Reference:-

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/use-data-guard-this-service.html#GUID-FB63CBB2-74E1-4FD6-AFFA-4F902008223C

Catch Me On:- Hariprasath Rajaram

LinkedIn:    https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:   https://www.facebook.com/HariPrasathdba
FB Group:   https://www.facebook.com/groups/894402327369506/
FB Page:      https://www.facebook.com/dbahariprasath/?
Twitter:       https://twitter.com/hariprasathdba