#!/bin/ksh
#*******************************************************************************
#                          KSH PROGRAM
#*******************************************************************************
#
#    PROGRAM ID           : dgstat.ksh
#
#D   DESCRIPTION          : Show dataguard overview
#D
#
#    INPUT PARAMETERS     : none
#
#    OUTPUT PARAMETERS    : none
#
#
#    INPUT FILES          : none
#
#    OUTPUT FILES         : none
#
#
#    SPECIAL LOGIC NOTES  : alias -x dgstat='/app/istp/dump/bin/dgstat.ksh'
#
#*******************************************************************************
#                        MODIFICATION LOG
#
#
#    DATE                               SE
#       DESCRIPTION
#    ---------------------------------------------------------------------------
#    Wed May  4 14:08:32 CEST 2016      (Hajo)
#       initial version
#    ---------------------------------------------------------------------------
#
#*******************************************************************************

#------------------------------
# init variables
#------------------------------
export s_myName=`basename $0`                               # remember my name
export s_myNameBase=$(echo ${s_myName} | sed -e's/\.ksh//')

export s_nas_path=/app/istp/dump
export s_mod_path=${s_nas_path}/bin/MODG


#------------------------------
# get environment
#------------------------------
. ${s_mod_path}/gmod_getenv -s
export s_dbenv=$(echo $s_env | tr '[:upper:]' '[:lower:]')
echo "-------------------"
echo "Instance: ${s_curr_db}"
echo "Host....: ${s_curr_host}"
echo "ISTP-Env: ${s_dbenv}"

. ${s_cfg_path}/cfg_istp_${s_dbenv}.ksh


#*******************************************************************************
# MAIN
#*******************************************************************************
echo "-------------------"
sqlplus -s app_dba/${s_app_dba} <<-EOSQL01

        set pages 0
        set lines 100
        set feedback off
        set heading off
        set serveroutput on

        alter session set NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';

        select 'Database Role.....: ' || database_role      from v\$database;
        select 'Protection Mode...: ' || protection_mode    from v\$database;
        select 'Switch Over Status: ' || switchover_status  from v\$database;
        select 'DG Broker.........: ' || dataguard_broker   from v\$database;
        select 'Force Logging.....: ' || force_logging      from v\$database;

        select distinct 'Arch. Sequence....: ' || sequence# from v\$archived_log where sequence# = (select max(sequence#) from v\$archived_log);
        select distinct 'Applied...........: ' || applied   from v\$archived_log where sequence# = (select max(sequence#) from v\$archived_log);

        -- select distinct sequence#, first_time, next_time from v\$archived_log where sequence# = (select max(sequence#) from v\$archived_log);

        -- select 'Protection Level..: ' || protection_level   from v\$database;
        -- select 'Remote Archive....: ' || remote_archive     from v\$database;
        -- select 'Activation #......: ' || activation#        from v\$database;
        -- select 'Switch Over #.....: ' || switchover#        from v\$database;
        -- select 'Guard Status......: ' || guard_status       from v\$database;

        -- select protection_mode, protection_level, remote_archive, activation#, switchover#, database_role, switchover_status, dataguard_broker, guard_status, force_logging from v\$database;


        quit
        EOSQL01


#*******************************************************************************
# FINE
#*******************************************************************************
#echo "-------------------"
exit