Step by Step Dataguard Switchover

Step:1

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

Step:2

select
dest_name,status,error from
v$archive_dest
where dest_name=’LOG_ARCHIVE_DEST_2′;

Step:3

select
message from v$dataguard_status;

select
switchover_status from
v$database;

On
Primary database

Step:4

alter
database commit to switchover to standby;

Step:5

shutdown
immediate;

Step:6

startup nomount

Step:7

alter
database mount standby database;

Step:8

alter
database recover managed standby database disconnect from session;

Step:9

select
name,open_mode,database_role from
v$database;

On
Standby database:

Step:10

alter
database commit to switchover to primary;

Step:11

shutdown
immediate;

Step:12

Startup

Step:13

select
name,open_mode,database_role from
v$database;