oracle自动清理归档,Oracle rman 自动清理归档日志

一、背景：

数据库开启归档日志，若不及时清理归档日志，系统就会报

ORA-00257: archiver error. Connect internal only, until freed

有没有自动清理归档脚本，不需要每次都手动清理呢？

当然有，实现自动清理归档日志，可以通过 Linux crontab,Oracle rman。

二、编写删除rman脚本

新建一个脚本clearLog.sh

${ORACLE_HOME}/bin/rman nocatalog log=/home/oracle/del_arch$(date +%Y-%m-%d).log <

三、手动测试脚本

赋权：chomd +x clearLog.sh

执行：./clearLog.sh

ok,,查看del_arch.log,能删除归档。

四、添加至corntab

在oracle 用户下执行crontab -e

42 20 * * * /home/oracle/clearLOG.sh晚上20:42分执行clearLog.sh

五、测试与验证

修改crontab中的clearLog.sh运行时间为系统时候后的1分钟 。

1、查看运行日志： more del_arch文件，并无内容

2、查看cron运行日志

more /var/log/cron

Jul 4 18:40:01 orac1 CROND[632]: (root) CMD (/usr/lib64/sa/sa1 1 1)

Jul 4 18:41:18 orac1 crontab[1415]: (oracle) BEGIN EDIT (oracle)

Jul 4 18:41:37 orac1 crontab[1415]: (oracle) REPLACE (oracle)

Jul 4 18:41:37 orac1 crontab[1415]: (oracle) END EDIT (oracle)

Jul 4 18:42:01 orac1 crond[3515]: (oracle) RELOAD (/var/spool/cron/oracle)

Jul 4 18:42:02 orac1 CROND[1604]: (oracle) CMD (/home/oracle/clearLOG.sh)

发现脚本在指定时间运行了，但为什么没有清除归档？百度一下，发现有两种解决方案

1、使用su - oracle -c

2、添加oracle 环境变量

六、添加oracle 环境变量

切换至oracle 用户

more .bash_profile

将oracle 相关的环境变量粘贴至clearLog.sh文件中

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/db

export ORACLE_SID=orcl1

export ORACLE_UNQNAME=orcl

export ORACLE_TERM=xterm

export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"

export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/oui/bin:/usr/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/sdbms/jlib

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

${ORACLE_HOME}/bin/rman nocatalog log=/home/oracle/del_arch$(date +%Y-%m-%d).log

<

七、再次测试与验证

[oracle@orac1 ~]$ ls

backup clearLOG.sh_bak core.14518 del_arch2014-07-04.log

clearLOG.sh core.14076 core.14561

[oracle@orac1 ~]$ wc -l del_arch2014-07-04.log

79 del_arch2014-07-04.log

[oracle@orac1 ~]$ more del_arch2014-07-04.log

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jul 4 20:31:04 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

RMAN>

connected to target database: ORCL (DBID=1367727099)

using target database control file instead of recovery catalog

RMAN> 2> 3>

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=174 instance=orcl1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=190 instance=orcl1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=217 instance=orcl1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=113 instance=orcl1 device type=DISK

List of Archived Log Copies for database with db_unique_name ORCL

=====================================================================

Key Thrd Seq S Low Time

------- ---- ------- - -------------------

68984 1 39462 A 2014-06-23 18:07:21

Name: +ARV1/orcl/archivelog/2014_06_23/thread_1_seq_39462.2542.851021325

68988 1 39463 A 2014-06-23 18:48:44

Name: +ARV1/orcl/archivelog/2014_06_23/thread_1_seq_39463.2548.851023995

68992 1 39464 A 2014-06-23 19:33:15

Name: +ARV1/orcl/archivelog/2014_06_23/thread_1_seq_39464.2555.851027033

68983 2 29516 A 2014-06-23 18:37:56

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29516.2545.851021323

68985 2 29517 A 2014-06-23 18:48:42

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29517.2543.851022017

68986 2 29518 A 2014-06-23 19:00:15

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29518.2546.851022997

68987 2 29519 A 2014-06-23 19:16:37

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29519.2550.851023995

68989 2 29520 A 2014-06-23 19:33:14

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29520.2549.851025009

68990 2 29521 A 2014-06-23 19:50:08

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29521.2552.851025979

68991 2 29522 A 2014-06-23 20:06:18

Name: +ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29522.2558.851027033

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_1_seq_39462.2542.851021325 RECID=68984 STAMP=851021324

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_1_seq_39463.2548.851023995 RECID=68988 STAMP=851023995

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_1_seq_39464.2555.851027033 RECID=68992 STAMP=851027033

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29516.2545.851021323 RECID=68983 STAMP=851021322

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29517.2543.851022017 RECID=68985 STAMP=851022017

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29518.2546.851022997 RECID=68986 STAMP=851022998

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29519.2550.851023995 RECID=68987 STAMP=851023995

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29520.2549.851025009 RECID=68989 STAMP=851025010

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29521.2552.851025979 RECID=68990 STAMP=851025980

deleted archived log

archived log file name=+ARV1/orcl/archivelog/2014_06_23/thread_2_seq_29522.2558.851027033 RECID=68991 STAMP=851027032

Deleted 10 objects

RMAN>

Recovery Manager complete.

ok 祝你好运。