Posted by Mir Sayeed Hassan on 2nd October 2017
Manually Perform Physical standby data Guard Failover steps In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database. standby Database: Verify… Read more..
Posted in DataGuard (DR) | Comments Off on Physical standby data Guard Failover steps
Posted by Mir Sayeed Hassan on 2nd October 2017
Verify Primary & Standby Database are sync & applied logs ON PRIMARY: col MEMBER FORMAT A100 set linesize 200 sql> SELECT a.thread#, b. last_seq, a.applied_seq, a. last_app_timestamp, b.last_seq-a.applied_seq ARC_DIFF FROM (SELECT thread#, MAX(sequence#) applied_seq, MAX(next_time) last_app_timestamp FROM gv$archived_log… Read more..
Posted in DataGuard (DR) | Comments Off on Verify Primary & Standby Database are sync & applied logs
Posted by Mir Sayeed Hassan on 27th September 2017
Failover by using the DGMGRL On Primary Database [oracle@pr ~]$ !sq sqlplus / as sysdba SQL> SELECT NAME,DB_UNIQUE_NAME, OPEN_MODE,DATABASE_ROLE FROM V$DATABASE; NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE ——– —————————— ——————–… Read more..
Posted in DataGuard (DR) | Comments Off on Failover by using the DGMGRL