Oracle归档日志清理

1

rman target /

1

RMAN> list archivelog all;	#显示所有的日志及日志地址

1
2

cd /data/oracle
ls

1

find /data/oracle/ -xdev -mtime +7 -name "*.dbf" -exec rm -f {} \;

1

RMAN> crosscheck archivelog all;	#把无效的expired的archivelog标出来

1

RMAN> delete expired archivelog all;	#删除所有的无效日志

1

RMAN> delete archivelog all completed before 'sysdate-7';

1

RMAN> delete archivelog from time 'sysdate-7';	# 删除从7天前所有日志,慎用

1

SQL> show parameter log_archive_dest_1

1

SQL> alter system set log_archive_dest_1='location=/data/oracle/archivelog/';

1

SQL> show parameter log_archive_format

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

#!/bin/bash

set -e
set -x

source /home/oracle/.bash_profile
ORACLE_SID=orcl
table='v$archived_log'
deldir='/databak/shell'

sqlplus -silent "/ as sysdba" <<EOF > ${deldir}/deleteorclarch.sh
set heading off;
set pagesize 0;
set term off;
set feedback off;
set linesize 32767;
select 'rm -rf '||name from ${table} where DELETED='NO' and APPLIED='YES' and name!='standbydb';
exit;
EOF
sh ${deldir}/deleteorclarch.sh
rman target /<<END
crosscheck archivelog all;
delete noprompt expired archivelog all;
exit;
END

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

#!/bin/bash
set -e
#set -x

source /home/oracle/.bash_profile

DATE=`date +%Y%m%d%H`
rman target / <<EOF
run{
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog all completed before 'sysdate-7'; 
}
exit;
EOF
exit