Shulou(Shulou.com)05/31 Report--

How to automatically clean up the oracle archive script, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Crontab content:

19 1, 8, 8, 16 * sh / home/oracle/rman_del_arch_all.sh > / home/oracle/rman_del_arch_all.sh.out

The content of the script rman_del_arch_all.sh:

Export ORACLE_BASE=/database/oracle/product

Export ORACLE_HOME=/database/oracle/product/rdbms/11.2.0

Export ORACLE_SID=hnpay1

Export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Export PATH=.:$ {PATH}: $HOME/bin:$ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/oracle/app/grid/bin:/bin:/usr/bin/X11:/usr/local/bin

Export PATH=$ {PATH}: / opt/oracle/ogg/ggircn:$ORACLE_HOME/OPatch:$ORACLE_BASE/common/oracle/bin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Rman target /

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.