oracle归档日志删除方法

心已赠人 2022-03-20 13:37 593阅读 0赞

## oracle归档日志处理方法 ##

归档日志如果不定期删除，会越来越多，有很大部分在备份或者过期后都是无用的，只会浪费大量磁盘空间，所以需要定期删除。因为archivelog的相关信息是记录在controlfile中的，并且可以从相关的动态视图(例如v$archived\_log)查询，archivelog文件从OS层直接物理删除后，该部分日志仍然标注为存在，也就是说Oracle并不认为这些日志被删除了，所以在删除archivelog的时候，需要做一些设置。

### 一、OS层定期删除 ###

1、物理删除archivelog  
2、进入RMAN

[oraarp@bjb ~]$ rman target /
    Recovery Manager: Release 10.2.0.1.0 - Production on Thu Feb 14 16:31:19 2019
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    connected to target database: ARPDB (DBID=3035516155)

3、检查所有归档日志

RMAN> crosscheck archivelog all;
    
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=606 devtype=DISK
    validation failed for archived log
    archive log filename=/arp/oraarp/archivelog/1_7638_704132477.dbf recid=4735 stamp=998460520
    validation failed for archived log
    archive log filename=/arp/oraarp/archivelog/1_7639_704132477.dbf recid=4736 stamp=998478034
    validation succeeded for archived log
    archive log filename=/arp/oraarp/archivelog/1_7640_704132477.dbf recid=4737 stamp=998517613
    validation succeeded for archived log
    
    ·······

3、列出失效的归档日志

RMAN> list expired archivelog all;
    
    List of Archived Log Copies
    Key     Thrd Seq     S Low Time  Name
    ------- ---- ------- - --------- ----
    4735    1    7638    X 24-JAN-19 /arp/oraarp/archivelog/1_7638_704132477.dbf
    4736    1    7639    X 25-JAN-19 /arp/oraarp/archivelog/1_7639_704132477.dbf

4、删除失效的归档日志

RMAN> delete expired archivelog all;
    
    released channel: ORA_DISK_1
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=606 devtype=DISK
    
    List of Archived Log Copies
    Key     Thrd Seq     S Low Time  Name
    ------- ---- ------- - --------- ----
    4735    1    7638    X 24-JAN-19 /arp/oraarp/archivelog/1_7638_704132477.dbf
    4736    1    7639    X 25-JAN-19 /arp/oraarp/archivelog/1_7639_704132477.dbf
    
    Do you really want to delete the above objects (enter YES or NO)? yes
    deleted archive log
    archive log filename=/arp/oraarp/archivelog/1_7638_704132477.dbf recid=4735 stamp=998460520
    deleted archive log
    archive log filename=/arp/oraarp/archivelog/1_7639_704132477.dbf recid=4736 stamp=998478034
    Deleted 2 EXPIRED objects
    
    RMAN>

OS删除命令，以及rman命令，可以都放在shell脚本中，定期执行。以下是rman命令脚本

#!/bin/bash
    DATE=`date +%Y%m%d%H`
    source /home/oracle/.bash_profile
    $ORACLE_HOME/bin/rman log=/u01/app/rman_${ DATE}.log <<EOF
    connect target/
    run{ 
    crosscheck archivelog all;
    delete noprompt expired archivelog all; 
    }
    exit;
    EOF
    exit

### 二、RMAN直接删除 ###

RMAN>DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; //删除七天前的归档
    RMAN>DELETE ARCHIVELOG FROM TIME 'SYSDATE-7'; //删除七天到现在的归档(慎用)

### 三、RMAN备份后，直接删除归档 ###

RMAN>backup format '/u01/arch_%T_%s_%U' archivelog all delete input;