Oracle Data Guard 12c Switchover Issues

Environment Primary: 2-nodes 12c RAC ASM Super Cluster Oracle Solaris Dedicated Network Interface for Data Guard Dedicated Listener for Data Guard Standby: 2-nodes 12c RAC ASM Super Cluster Oracle Solaris Dedicated Network Interface for Data Guard Dedicated Listener for Data Guard What is the Issue: Sometimes, when I do a Switchover I receive an error … Continue reading Oracle Data Guard 12c Switchover Issues

Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment

Introduction: We may classify the database services into two types of services : 1- Database Services 2- Cluster Managed Database Services Please note that: - The procedure dbms_service.start_service - used with the first type - is deprecated in databases managed by Oracle Clusterware and Oracle Restart with Release 11.2. While the procedure remains available in … Continue reading Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment

Oracle Data Guard 12c Testing Scenarios

Objective The objective of this post is to show the detailed steps for: Testing Read-Only access to the Standby DatabaseTesting Active Data Guard Access to the Standby DatabaseTesting Switching over/back to/from Standby DatabaseTesting Failover to the Standby Current Data Guard Environment Testing Read-Only access to the Standby Database On the current primary database create a … Continue reading Oracle Data Guard 12c Testing Scenarios