DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, September 13, 2016

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;

No comments: