Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

Archive for the 'DataGuard (DR)' Category

Next Entries »

Verify Primary & Standby Database are sync & applied logs

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

Failover by using the DGMGRL

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

Next Entries »