scripts/LJCOPY/d2.ksh

#!/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`
}



get_db_role

if    [ is_guarded -gt 0  -a  "${database_role}" = "PRIMARY" ]; then 
	echo -e "1. Guarded and Primary ($database_role) - NO BACKUP HERE"
elif [ is_guarded -gt 0  -a  "${database_role}" = "PHYSICAL STANDBY" ]; then
	echo -e "2. Not Guarded and Primary ($database_role) - BACKUP HERE"
elif [ is_guarded -eq 0  -a  "${database_role}" = "PRIMARY" ]; then   # OK: SIT3, UAT3, SYSTST2.......
        echo -e "3. Not Guarded and Primary ($database_role) - BACKUP HERE"
else
	echo -e "ERROR Unknown Configuration"
fi



# value=`function "fnordness"`