#!/bin/ksh

function is_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()
{
database_role=`${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 sys.v\\$database;
EOF`
}

is_guarded
retval=$?
# echo "is_guarded returned ---${retval}---"
get_db_role
echo "${retval}:$database_role"

if   [ $retval -eq 0 ]; then
        echo -e "BACKUP HERE"
else
        echo -e "No Backup here......."
fi