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;
  • September 13, 2016 | 12 views
  • Comments