check switchover status
Learnomate Technologies > check switchover status
Switchover in Oracle 12C Dataguard
26
Oct
In this blog, We will try to understand how to perform switchover activity. Switchover activity will change the role of database. Precheck for SwitchoverALTER 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#;SQL> select dest_name,status,error from v$archive_dest where dest_name=’LOG_ARCHIVE_DEST_2′; DEST_NAME ——————————————————————————– STATUS ERROR ——— —————————————————————– LOG_ARCHIVE_DEST_2 VALIDSQL> select message from v$dataguard_status;select […]
Tags:
active data guard failover ,
alter database switchover to verify ,
check switchover status ,
data guard broker switchover verify ,
data guard failed destination ,
data guard switchover and failover best practices 12c ,
dgmgrl switchover verify ,
dr switch over ,
ora 16468 error connecting to switchover target ,
oracle 11g 12c data guard with asm pdf ,
oracle 11g data guard switchover step by step ,
oracle data guard failover steps 12c ,
oracle data guard switchover step by step using dgmgrl ,
oracle manual switchover to standby ,
oracle switchover to standby ,
switchover and failover ,
switchover and switchback in oracle 12c ,
switchover and switchback in oracle 12c rac ,
switchover_status resolvable gap on primary ,
