scripts/LJCOPY/ig.ksh

#!/bin/ksh

function is_not_guarded
{
return `${ORACLE_HOME}/bin/sqlplus -S / "as sysdba" <<-EOF
        set pagesize 0 feedback off verify off heading off termout off echo off
        select count(1) from sys.v\\$archive_dest where status = 'VALID' and target = 'STANDBY';
EOF`
}



get_db_role()
{
retval=`${ORACLE_HOME}/bin/sqlplus -S / "as sysdba" <<-EOF
        set pagesize 0 feedback off verify off heading off termout off echo off
        select  database_role from v\\$DATABASE;
EOF`
return $retval
}



get_db_role
if is_not_guarded
then    #P!DG
        echo -e "INFO: IS_NOT_guarded, and is ${retval}"
        #echo "CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;"    
else    #P+DG
        echo -e "INFO: IS_guarded, and is ${retval}"
        #echo "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY;" 
        
fi