Oracle 12c-Step by Step Manual Data Guard Switchover

Oracle 12c-Step by Step Manual Data Guard Switchover

Prepared by Ranesh

Step 1:- Check database role and database name

Primary database:-

select name,open_mode,database_role from v$database

Precheck for Switchover:-

Before performing switchover, kindly verify the state of data guard on both the instances by following SQL queries:

 ALTER SYSTEM SET  log_archive_dest_2=’service=warangal  async valid_for=(online_logfiles,primary_role) db_unique_name=warangal’;

Step 2:-

ALTER SESSION SET nls_date_format=’DD-MON-YYYY HH24:MI:SS’;

SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#;

On Primary database:-

Step 3:- select switchover_status from v$database;

Note: This command will give you appropriate message about the data guard current status.

On Primary database:-

Step 4:

SQL> alter database commit to switchover to standby;

Step 5:-

shutdown immediate

startup nomount

alter database mount standby database

Step 6:-select name,open_mode,database_role from v$database;

alter database recover managed standby database disconnect from session;

On Standby database:

Step 7:-alter database commit to switchover to primary;

Step 8:-select name,open_mode,database_role from v$database;