Flash归档自动调度-CSDN博客

本文介绍了一个用于自动调度Oracle RMAN进行日志归档的Shell脚本。该脚本会检查闪回恢复区域的利用率，当利用率超过10%时，自动运行RMAN命令来清理过期的日志文件并备份日志直到前一天。适用于AIX 6.1及Oracle 10g环境。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

先判断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