DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2001
    I have a primary database prod and standby database stby. The standby database is seldom used. It's in "Managed Recovery" mode so that it will always in sync with PROD. However, sometimes the managed recovery mode might fail to perform the sync. Sometimes, it's too late to find the problem and the gap between them is as huge as 1000 archived logs. It will be a trouble to sync them at that time. Sometimes, even impossible.

    I am thinking to write a script to check the following view on both PROD and STBY:

    SELECT 'max:'||max(sequence#) FROM v$log_history;

    Then, place the script on the cron job so that it will check everyday and notify you whenever the gap is more than , let's say, 5 archived logs.

    I am glad to share the script and also looking for better solution.

    Here are my scripts:

    1. SQL

    set termout off
    set head off
    set echo off

    spool &1

    SELECT 'max:'||max(sequence#) FROM v$log_history;
    spool off

    2. Shell


    export EMAIL_ADDRESS='test@test.com'

    . $HOME/.oracle

    cd /export/home/oracle/test

    export ORACLE_SID=gtre

    sqlplus -s internal @maxlog.sql stby_gtre.log

    sqlplus -s dba_admin/gdgdfff@ttnn.test.com @maxlog.sql prmy_gtre.log

    echo stby_gtre.log
    cat stby_gtre.log

    echo prmy_gtre.log
    cat prmy_gtre.log

    stby=`grep max stby_gtre.log|awk -F: '{print $2}'`
    prmy=`grep max prmy_gtre.log|awk -F: '{print $2}'`

    if (( $prmy > $stby ))
    cat /export/home/oracle/test/ck_stby.log|mailx -s "============stby database out of sync============" $EMAIL_A
    }> /export/home/oracle/test/ck_stby.log

  2. #2
    Join Date
    Feb 2001
    As an alternate idea, Did you consider using "ARCHIVE LOG LIST"

  3. #3
    Join Date
    Oct 2000
    Correct me if I am wrong... but going by the script you will always get an alert since the sequence id on your prod db will always be > then the seq on stby.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.