2.4k questions

2.4k answers

98.0k users

4 Online Users
0 Member 4 Guest
Today Visits : 1206
Yesterday Visits : 1735
Total Visits : 2425203



Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc


Viktoria Katsanioti,




0 votes

How do you perform a failover in Oracle Data Guard?
in General by (95.8k points)

1 Answer

0 votes

On the Oracle Data Guard Overview page in Cloud Control, select the standby database that you want to change to the primary role and click Failover. Then, on the Failover Confirmation page, click Yes to invoke the default Complete failover option (from google)

What is failover in Data Guard?

Failover is a one way process where your primary database goes down due to some reasons and to get back the production live without any loss, you convert your existing Physical Standby database to start behaving as Primary database

please read

Switchover and Failover Operations
Note: The examples shown in this section do not necessarily show the specific attributes you might need to use in your own environment. The required attributes vary depending on your configuration (including whether your environment is Oracle RAC-based or single-instance). Refer to the appropriate Oracle RAC or Oracle Restart documentation for further information. Database services can be configured to be active in specific database roles on Oracle RAC databases and on single-instance databases managed by Oracle Restart. The broker interacts with Oracle Clusterware or Oracle Restart to ensure that the appropriate database services are active and that the appropriate FAN events are published after a role change. FAN events are always published through ONS. However, the event notifying a failover is only published for database services that have been configured to be active while the database is in the primary role on the new primary database. Services that must be active in any given database role (primary, physical standby, logical standby, or snapshot standby) must be configured with the Server Control utility (SRVCTL) explicitly on each database where the service must be active. In the following example commands, a service named PAYROLL is configured to be active in the PRIMARY role on the primary database NORTH . The service is then configured to be active in the PRIMARY role on the standby database SOUTH , so that it will be active on that database after a role transition. In these sample commands, the ellipse (...) signifies any other add service options you wish to supply. On primary database NORTH , execute the following: srvctl add service –db NORTH –service PAYROLL –role PRIMARY ... On standby database SOUTH , execute the following: srvctl add service –db SOUTH –service PAYROLL –role PRIMARY ... Services that are to be active while the database is in the physical standby role must also be created and started on the current primary database regardless of whether the service will be started on that database or not. This is to ensure that the service definition gets propagated to the physical standby database via the redo stream and thus allows for the service to be started on the physical standby database. The service can be started on the physical standby only after the redo generated by starting the service has been applied. It is important that all SRVCTL add service options be identical on all the databases so that the services behave the same way before and after a role change. If all the databases do not have the same values, SRVCTL attempts to override the values, which will fail on the physical standby database because it is open read-only. In the following example, a service named sales is configured to be active in the PHYSICAL_STANDBY role on the primary database NORTH . It is then started and stopped on the primary database. It could optionally also be removed from the primary database if there is no intention to ever run this
by (95.8k points)