Oracle 18c Data Guard Broker Enhancements

Description:-

These are the changes in Oracle Data Guard Broker in Oracle Database Release 18c

This release provides several new commands:

  • VALIDATE DATABASE SPFILE performs a comparison of server parameter file (SPFILE) entries between the primary database and a specified standby database.
  • VALIDATE NETWORK CONFIGURATION performs network connectivity checks between members of a broker configuration.
  •  VALIDATE STATIC CONNECT IDENTIFIER validates the static connect identifier of a database.
  •  SET ECHO controls whether or not to echo commands that are issued either at the command-line prompt or from a DGMGRL script.
  • SHOW ALL (DGMGRL CLI properties) shows the values of DGMGRL CLI properties.

The V$DATAGUARD_PROCESS view, introduced in Oracle Database 12c Release 2 (12.2.0.1), now shows broker processes. (Oracle Data Guard Monitor (DMON)
Process.)

SQL> select name,TYPE,role from V$DATAGUARD_PROCESS;

NAME  TYP ROLE
----- --- ------------------------
LGWR  KSB log writer
TMON  KSB redo transport monitor
DMON  KSB broker monitor
INSV  KSB broker instance slave
NSV2  KSB broker net slave
TT00  KSV gap manager
TT01  KSV redo transport timer
ARC0  KSB archive local
TT02  KSV async ORL multi
TT03  KSV heartbeat redo informer
ARC1  KSB archive redo
ARC2  KSB archive redo
ARC3  KSB archive redo
RSM0  KSB broker worker
drcx  NET switchover
15 rows selected.

VALIDATE DATABASE SPFILE

The VALIDATE DATABASE SPFILE command performs a comparison of server parameter file (SPFILE) entries between the primary database and a specified standby database.

The validation of the server parameter file detects parameter value discrepancies between the primary and the specified standby database so that they can be rectified before a role change, thus ensuring that after a role change the databases perform at the same level they did prior to the role change. Additionally, using this command frees you from having to restart a database to correct improperly set parameters.

Format
VALIDATE DATABASE {database-name} SPFILE;

If the database to be validated is the primary database, then a message is returned saying the command cannot be issued on a primary database.

DGMGRL> VALIDATE DATABASE dbwrprim SPFILE;
This command cannot be used for the primary database.
DGMGRL> VALIDATE DATABASE dbwrstby SPFILE;
Connecting to "dbwrprim".
Connected to "dbwrprim"
Connecting to "dbwrstby".
Connected to "dbwrstby"
Parameter settings with different values:
audit_file_dest:
dbwrprim (PRIMARY) : /oradb/app/oracle/admin/dbwrprim/adump
dbwrstby : /oradb/app/oracle/admin/dbwrstby/adump
compatible:
dbwrprim (PRIMARY) : 18.0.0
dbwrstby : 18.3.0.0.0
dispatchers:
dbwrprim (PRIMARY) : (PROTOCOL=TCP) (SERVICE=dbwrprimXDB)
dbwrstby : (PROTOCOL=TCP) (SERVICE=dbwrstbyXDB)
fal_client:
dbwrprim (PRIMARY) : dbwrprim
dbwrstby : dbwrstby
sga_target:
dbwrprim (PRIMARY) : 1201668096
dbwrstby : 943718400

VALIDATE NETWORK CONFIGURATION

The VALIDATE NETWORK CONFIGURATION command performs network connectivity checks between members of a configuration.

The connect identifier for each connectivity check is generated based on the
DGConnectIdentifier property of the associated database.

Format
VALIDATE NETWORK CONFIGURATION FOR { ALL | member name };

Validating Network Configuration for a Specific Database

DGMGRL> VALIDATE NETWORK CONFIGURATION FOR dbwrstby;
Connecting to instance "dbwrstby" on database "dbwrstby" ...
Checking connectivity from instance "dbwrstby" on database "dbwrstby" to
instance "dbwrprim" on database "dbwprim"...
Succeeded.
Oracle Clusterware is not configured on database "dbwrstby".

VALIDATE STATIC CONNECT IDENTIFIER

The VALIDATE STATIC CONNECT IDENTIFIER command validates the static connect identifier of a database.
To perform this validation, the broker makes a new connection to the database using a static connect identifier based on the StaticConnectIdentifer property of the database. A new attribute, STATIC_SERVICE=TRUE is added to the connect identifier to ensure that a connection to the database is established using only a static service, not a dynamic service.

Format
VALIDATE STATIC CONNECT IDENTIFIER FOR { ALL | database name };

Command Examples
Validation of Static Connect Identifier For a Database on Which
Oracle Clusterware Is Configured

DGMGRL> VALIDATE STATIC CONNECT IDENTIFIER FOR dbwrstby;
Oracle Clusterware is not configured on database "dbwrstby".

SHOW ALL

The SHOW ALL command shows the values of DGMGRL CLI properties.

Format
SHOW ALL;

Command Example

DGMGRL> SHOW ALL;
debug ON
echo OFF
time OFF
observerconfigfile = observer.ora

 

Catch Me On:- Hariprasath Rajaram 

Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba 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

RestAPI for Oracle DBaaS Cookbook

Hello Friends,

Great news that I wanted to share with you all!!! I am delighted to announce the launch of my first Oracle technical book named “RestAPI for Oracle DBaaS Cookbook”. 

This book authored by myself (Hariprasath Rajaram, Cloud OCP on DBAAS),  Skant Gupta (Oracle Certified Master) and Stuti Kaushal (Oracle Certified Associate)  describe the hands-on guide imparting practical working knowledge and guidance of RestAPI concepts.

The Target Audience

The primary target audience are Oracle DBAs and Oracle Cloud DBA’s (DBaas). This book has been diligently planned for all levels of DBA experts. Coming right from the real-world practicing DBA’s, this book is written as a hands-on guide imparting practical working knowledge and guidance of RestAPI concepts.

What this book covers

Chapter 1, Introduction to RestAPI covers the Fundamentals of RestAPI, verbs, methods and status codes.

Chapter 2, Access Rules discusses the method of creating a rule, viewing a rule, enabling a rule, disabling a rule and deleting an access rule using RestAPI in Oracle Database Cloud Service.

Chapter 3, Backup and Recovery discusses method to start a backup operation, viewing all backup operations, starting a recovery operation and viewing all recovery operations.

Chapter 4, Patches illustrates the details about various operations being performed on Oracle Database Cloud patches using RestAPI

Chapter 5, Service Instances gives an overview on the usage of Oracle Database Cloud Service instances using various RestAPI methods

Chapter 6, Snapshots discusses the procedure of creating, viewing and deleting a snapshot in database using RestAPI

Chapter 7, SSH Keys describes usage of Oracle Database Cloud service RestAPI to create and manage database endpoints to view and manage Secure Shell (SSH) public keys of a Database

This book is available on Paperback, Kindle Edition and PDF version.

RestAPI for Oracle DBaaS Cookbook-Paperback

  
BUY ON AMAZON   https://www.amazon.com/dp/1731311249/

Co-Author’s

Special thanks for Skant Gupta for initiated the writing of this book and helped me to complete it on time successfully along with Stuti Kaushal.

Skant Gupta
Stuti Kaushal
RestAPI for Oracle DBaaS Cookbook-Kindle Edition
BUY ON AMAZON   https://www.amazon.in/dp/B07L2C5GKH/

Family Members

Special thanks to my wife and son who have patience during this time and helped me to complete this book. Without your support, i would not have completed this!!!

Doyensys Team

Thanks Somu Chockalingam, president of Doyensys Inc, for his encouragement and motivation to complete this book successfully. Thanks to all Doyensys DBA team who has supported me during this journey. Special Thanks To Marimuthu Pandu

Aioug Chennai Chapter Team

Thanks for overall support and guidance from AIOUG team, especially Hariharaputhran and Harish for their support.

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

 

Sincerely,
Hariprasath Rajaram
Oracle DBA Senior Consultant,
Doyensys Inc.Chennai,
India
Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DkeGfZsxfzXxHD6gTg
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-Performing a Reinstate Failed Primary Database Using DBCS Console

Oracle 18c-Performing a Reinstate Failed Primary Database Using DBCS Console

Description:-

  • In this article we are going to see reinstate a failed primary database as a standby database after a failover.
  • After performing a failover to the standby database, you may be able to restore your original disaster-recovery solution by reinstating the failed primary database from 11.2.0.3 onwords.
  • After the failover Terabytes,warehouses or datamarts databases,Recreating the old Production as a Standby using RMAN duplicate it takes couple of days

Check the below related posts

Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
Oracle 18c-Performing a Data Guard Switchover using DBCS Console Here
Oracle 18c-Performing a Data Guard Failover using DBCS Console Here
Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility Here
Oracle 18c-Performing a Data Guard Failover Using DBaascli Utility Here

Let’s Start the Demo Using DBCS Console:-

Step1:-Check the status using DBCS Console

Step2:-Check Staus using Dbaascli Command

[oracle@chennai-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_02”
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

Step3:-Check the Dataguard configuration status

dbaascli dataguard status –details yes

Step4:-Start the Reinstate using DBCS Console

Step5:-From the menu we need select the Reinstate button, and then confirm the action.

Step6:-Check Status using Dbaascli Command

[oracle@chennai-dg01 chennai]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_01″
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

Step7:-Check Status using DBCS Console

Reference:-

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/data-guard-reinstate-failed-primary.html

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-Performing a Reinstate Failed Primary Database Using DBaascli Utility

Oracle 18c-Performing a Reinstate Failed Primary Database Using DBaascli Utility

Description:-

  • In this article we are going to see reinstate a failed primary database as a standby database after a failover.
  • After performing a failover to the standby database, you may be able to restore your original disaster-recovery solution by reinstating the failed primary database from 11.2.0.3 onwords.
  • After the failover Terabytes,warehouses or datamarts database,Recreating the old Production as a Standby using RMAN duplicate it takes couple of days

Check the below related posts

Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
Oracle 18c-Performing a Data Guard Switchover using DBCS Console Here
Oracle 18c-Performing a Data Guard Failover using DBCS Console Here
Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility Here
Oracle 18c-Performing a Data Guard Failover Using DBaascli Utility Here

Let’s Start the Demo Using DBaascli Utility:-

Step1:-Check the status using DBCS Console

Step2:-Check Staus using Dbaascli Command

[oracle@chennai-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_02”
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

Step3:-Check the Dataguard configuration status

dbaascli dataguard status –details yes

Step4:-Start the Reinstate using dbaascli Command

dbaascli dataguard reinstate

Step5:-Check Status using Dbaascli Command

[oracle@chennai-dg01 chennai]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_01″
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

Step6:-Check Status using DBCS Console

 

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-Performing a Data Guard Failover using DBCS Console

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

Description:- 

  • In this article we are going to perform oracle 18c dataguard Failover step by steps using  DBCS (Oracle Database Cloud Service Console)
  • we can Perform the Failover 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

Step1:-Open the Oracle Database Cloud Service console

Oracle 18c-Configure Data Guard Details

Step2:-Before Failover check the database level.

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Primary Side

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-From the menu we need select the Failover button, and then confirm the action.

Step7:-Failover operation is started using DBCS Console and databases in Maintenance mode

Step8:-Failover Successfully Completed using DBCS Console.

Step9:-After Failover check the database level.

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

 

Step10:-Check the Dataguard Status Using dbaascli Command

[oracle@chennai-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_02”
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

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-Performing a Data Guard Failover Using DBaascli Utility

       Oracle 18c-Performing a Data Guard Failover Using DBaascli Utility

Description:- 

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

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 Details

Step2:-Before Failover check the database level.   

Primary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-Start the failover using dbaascli Command

Login into primary server execute the dbaascli dataguard failover

Failover completed successfully using dbaascli utility

Step7:-After Failover check the database level.

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Step8:-Check the Failover Status using DBCS Console.

Step9:-Check the Dataguard Status Using dbaascli Command

[oracle@chennai-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_02”
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

 

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-Performing a Data Guard Switchover using dbaascli Utility

       Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility 

Description:- 

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

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 consoleOracle 18c-Configure Data Guard Details

Step2:-Before Switchover check the database level.                                                                                      Primary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-Start the swithover using dbaascli Command

dbaascli dataguard switchover

Swithover completed successfully using dbaascli utility

Step7:-Restart the ORDS services.

[oracle@chennai-dg01 ~]$ /etc/init.d/ords restart
INFO: Stopping Oracle REST Data Services…
INFO: Oracle REST Data Services stopped
INFO: Starting Oracle REST Data Services…
INFO: Oracle REST Data Services bound to ports 8181,8080 25619
INFO: Oracle REST Data Services started with PID 25619

Step8:-Post checks after a switchoverPrimary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;Standby Side

Reference:-

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

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-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