rman的脚本

 

先判断flash_recovery_area的利用率，如果超过10%则自动调度rman对日志进行归档

AIX Version 6.1,Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi

 

#!/bin/sh
echo "---------------begin date-------------"
date
export  ORACLE_HOME=/oracle/product/10.2
export ORACLE_SID=orcl
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
/oracle/product/10.2/bin/sqlplus -s / "as sysdba" <<EOF
set heading off feedback off pagesize 0 verify off echo off numwidth 4
WHENEVER SQLERROR EXIT FAILURE
col used new_value s_used
select ceil(sum(percent_space_used)) used from v\$flash_recovery_area_usage;
exit s_used
EOF
TJS_RETURN_CODE=$?
date
echo  $TJS_RETURN_CODE

if [ $TJS_RETURN_CODE -gt 10 ]
then
/oracle/product/10.2/bin/rman target  / <<EOF
crosscheck archivelog all;
delete noprompt expired archivelog all;
backup archivelog until time 'sysdate-1/96' delete all input;
delete noprompt obsolete; 
exit;
EOF
echo "backup end"
date
else
        date
        echo "------------------------end date-------"
fi

转载于:https://www.cnblogs.com/rambler/archive/2012/02/21/2361471.html