#echo "Present working directory is: $PWD"
export CONF=$PWD/dg.conf
[ ! -f "$CONF" ] && { echo "Configuration file: $CONF is missing."; echo "Exiting."; exit 1; }
. $CONF

export SYSPASSWD=$(cat .syspasswd)
export DR_LOG=db_db.log
export LOG=db.log

[ -f $DR_LOG ] && rm $DR_LOG
[ -f $LOG ] && rm $LOG

echo "Printing Standby Current SCN and Primary Current SCN"
echo "set echo off ver off feed off head off pages 0;
select current_scn from v\$database;" |
   sqlplus -s "sys/${SYSPASSWD}@${STANDBY_HOST}:${STANDBY_PORT}/${STANDBY_DB} as sysdba" |
   tee $DR_LOG

echo "set echo off ver off feed off head off pages 0;
select current_scn from v\$database;" |
    sqlplus -s "sys/${SYSPASSWD}@${PRIMARY_HOST}:${PRIMARY_PORT}/${PRIMARY_DB} as sysdba" |
    tee $LOG

echo ""
export DR_SCN=$(cat $DR_LOG |sed -e 's/ //g')
export SCN=$(cat $LOG |sed -e 's/ //g')

# Convert SCN to timestamp on the Primary DB
echo "Printing Standby Current SCN To Timestamp and Primary Current SCN To Timestamp"
echo "set echo off ver off feed off head off pages 0;
select scn_to_timestamp(current_scn) from v\$database;" |
    sqlplus -s "sys/${SYSPASSWD}@${PRIMARY_HOST}:${PRIMARY_PORT}/${PRIMARY_DB} as sysdba" 

echo "set echo off ver off feed off head off pages 0;
select scn_to_timestamp(${DR_SCN}) from dual;" |
    sqlplus -s "sys/${SYSPASSWD}@${PRIMARY_HOST}:${PRIMARY_PORT}/${PRIMARY_DB} as sysdba" 

echo "set echo off ver off feed off 
      col Primary for a32
      col DR for a32
      col wks for 999
      col days for 9999
select scn_to_timestamp(${SCN}) Primary
      ,scn_to_timestamp(${DR_SCN}) DR
      ,trunc(to_number(substr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),1,instr(scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN}),' ')))/7) Wks
      ,trunc(to_number(substr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),1,instr(scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN}),' '))))   Days
      ,substr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),instr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),' ')+1,2)                 Hrs
      ,substr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),instr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),' ')+4,2)                 Mins
      ,substr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),instr((scn_to_timestamp(${SCN})-scn_to_timestamp(${DR_SCN})),' ')+7,2)                 Secs
from dual;" |
    sqlplus -s "sys/${SYSPASSWD}@${PRIMARY_HOST}:${PRIMARY_PORT}/${PRIMARY_DB} as sysdba"