scripts/LJCOPY/sbt.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 "DEBUG: is_not_guarded: PRIMARY - NODG : retval is .${retval}."
        echo "CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;"    
else    #P+DG
        echo -e "DEBUG: is_guarded: PRIMARY - DG  : retval is .${retval}."
        echo "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY;" 
        
fi