Oracle RMAN clears archived logs

Oracle RMAN clears archived logs 1. How to clear archived logs a. manually delete the logs using rm or find. After deletion, in RMAN, you can use crosscheck archivelog all to verify whether the archive is invalid. perform the following operations:

       rm -rf arch_816906485_1_10.arc     find /u02/database/GOBO1/archive/ -ctime +0 -delete    RMAN> crosscheck archivelog all

 

B. The RMAN cleanup method will automatically clear the archive log files on the disk and release the archive information of the corresponding archive logs in the control file. You can clear archived logs based on different conditions, such as SCN, SEQUENCE, and TIME. The preceding three methods can be used with clauses such as from, until, between... and so on to limit the scope. The method is flexible and variable. The following command is used to verify the validity of archived logs, list invalid archived logs, and how to clear archived logs to list several common:

Crosscheck archivelog all; ---> Check log availability list expired archivelog all; ---> list all invalid archive logs delete archivelog until sequence 16; ---> delete all archived logs whose log sequence is 16 or earlier. delete archivelog all completed before 'sysdate-7'; ---> delete archived logs whose system time is 7 days ago, delete archivelog all completed before 'sysdate-1'; ---> same as above, delete archivelog from time 'sysdate-1' before 1 day '; ---> note that this command deletes the archive logs generated within one day of the system. delete noprompt archivelog all completed before 'sysdate '; ---> delete noprompt archivelog all; ---> the same command

 

2. Use RMAN to clear archived logs

[python] robin@SZDB:~> export ORACLE_SID=GOBO1  robin@SZDB:~> rman target /    Recovery Manager: Release 10.2.0.3.0 - Production on Thu Jul 11 17:07:00 2013    Copyright (c) 1982, 2005, Oracle.  All rights reserved.    connected to target database: GOBO1 (DBID=733951103)    RMAN> host;    robin@SZDB:~> cd /u02/database/GOBO1/archive/  robin@SZDB:/u02/database/GOBO1/archive> ls        arch_816906485_1_10.arc      arch_816906485_1_12.arc    arch_816906485_1_11.arc      arch_816906485_1_13.arc        ............    robin@SZDB:/u02/database/GOBO1/archive> rm -rf arch_816906485_1_10.arc arch_816906485_1_11.arc arch_816906485_1_12.arc  robin@SZDB:/u02/database/GOBO1/archive> exit;  exit                                           host command complete                                                                         RMAN> crosscheck archivelog all;                   released channel: ORA_DISK_1                                                                         allocated channel: ORA_DISK_1                                                                        channel ORA_DISK_1: sid=1075 devtype=DISK                                                            archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_9.arc recid=2085 stamp=817211151   validation failed for archived log                                                                   archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_10.arc recid=2086 stamp=817250793        ..............  validation succeeded for archived log                                                                archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_90.arc recid=2166 stamp=820458049  Crosschecked 83 objects                        RMAN> list expired archivelog all;    List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2086    1    10      X 20130604 11:05:51 /u02/database/GOBO1/archive/arch_816906485_1_10.arc  2087    1    11      X 20130604 22:06:17 /u02/database/GOBO1/archive/arch_816906485_1_11.arc  2088    1    12      X 20130605 19:30:53 /u02/database/GOBO1/archive/arch_816906485_1_12.arc    RMAN> delete archivelog until sequence 16;    released channel: ORA_DISK_1  allocated channel: ORA_DISK_1  channel ORA_DISK_1: sid=1075 devtype=DISK    List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2084    1    8       A 20130604 09:53:17 /u02/database/GOBO1/archive/arch_816906485_1_8.arc                          .................  2092    1    16      A 20130607 22:03:23 /u02/database/GOBO1/archive/arch_816906485_1_16.arc    Do you really want to delete the above objects (enter YES or NO)? yes            ...............  deleted archive log  archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_16.arc recid=2092 stamp=817516861  Deleted 9 objects    RMAN> delete archivelog all completed before 'sysdate-7';    released channel: ORA_DISK_1  allocated channel: ORA_DISK_1  channel ORA_DISK_1: sid=1075 devtype=DISK    List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2093    1    17      A 20130608 00:01:00 /u02/database/GOBO1/archive/arch_816906485_1_17.arc  2094    1    18      A 20130608 18:00:17 /u02/database/GOBO1/archive/arch_816906485_1_18.arc              ...........  deleted archive log  archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_72.arc recid=2148 stamp=819847035  Deleted 56 objects                RMAN> list copy of database archivelog all;      List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2149    1    73      A 20130703 23:17:13 /u02/database/GOBO1/archive/arch_816906485_1_73.arc  2150    1    74      A 20130704 22:00:19 /u02/database/GOBO1/archive/arch_816906485_1_74.arc  2151    1    75      A 20130704 22:04:40 /u02/database/GOBO1/archive/arch_816906485_1_75.arc                         ...............  2164    1    88      A 20130709 23:19:34 /u02/database/GOBO1/archive/arch_816906485_1_88.arc  2165    1    89      A 20130710 13:00:34 /u02/database/GOBO1/archive/arch_816906485_1_89.arc  2166    1    90      A 20130710 22:02:44 /u02/database/GOBO1/archive/arch_816906485_1_90.arc    RMAN> delete archivelog from time 'sysdate-1';    released channel: ORA_DISK_1  allocated channel: ORA_DISK_1  channel ORA_DISK_1: sid=1075 devtype=DISK    List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2165    1    89      A 20130710 13:00:34 /u02/database/GOBO1/archive/arch_816906485_1_89.arc  2166    1    90      A 20130710 22:02:44 /u02/database/GOBO1/archive/arch_816906485_1_90.arc    Do you really want to delete the above objects (enter YES or NO)? yes  deleted archive log  archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_89.arc recid=2165 stamp=820447373  deleted archive log  archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_90.arc recid=2166 stamp=820458049  Deleted 2 objects    RMAN> delete archivelog all completed before 'sysdate - 1';    released channel: ORA_DISK_1  allocated channel: ORA_DISK_1  channel ORA_DISK_1: sid=1075 devtype=DISK    List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2149    1    73      A 20130703 23:17:13 /u02/database/GOBO1/archive/arch_816906485_1_73.arc                .......................  2164    1    88      A 20130709 23:19:34 /u02/database/GOBO1/archive/arch_816906485_1_88.arc    Do you really want to delete the above objects (enter YES or NO)? yes       ................  archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_88.arc recid=2164 stamp=820414835  Deleted 16 objects    RMAN> sql " alter system archive log current";    sql statement:  alter system archive log current    RMAN> list copy of archivelog all;      List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2167    1    91      A 20130711 01:00:48 /u02/database/GOBO1/archive/arch_816906485_1_91.arc    RMAN> delete noprompt archivelog all completed before 'sysdate';    released channel: ORA_DISK_1  allocated channel: ORA_DISK_1  channel ORA_DISK_1: sid=1075 devtype=DISK    List of Archived Log Copies  Key     Thrd Seq     S Low Time          Name  ------- ---- ------- - ----------------- ----  2167    1    91      A 20130711 01:00:48 /u02/database/GOBO1/archive/arch_816906485_1_91.arc  deleted archive log  archive log filename=/u02/database/GOBO1/archive/arch_816906485_1_91.arc recid=2167 stamp=820517964  Deleted 1 objects  

 

3. Clear simple shell scripts for archiving logs

[Python] # For RAC environments or ASM, it is appropriate to use shell scripts to call RMAN. # Second, if your archive is located in the flash back area, make a reasonable retention policy, it can also make Oracle automatically aging useless archive logs robin @ SZDB :~ /Dba_scripts/custom/bin> more clean_arch.sh # + commands ++ # + Clean archived log as specified time |#+ Author: Robinson |#+ Blog: http://blog.csdn.net/robinson_0612 | # + Usage: | # + clean_arch.sh $ ORACLE_SID | # + ----------------------------------------------------- + ##! /Bin/bash # -------------------- # Define variable # ------------------ if [-f ~ /. Bash_profile]; then .~ /. Bash_profile fi if [-z "$ {1}"]; then echo "Usage:" echo "'basename $ 0' ORACLE_SID" exit 1 fi ORACLE_SID = $1; export ORACLE_SID $ ORACLE_HOME/bin/rman log =/users/robin/log/rman. log <EOF connect target/run {crosscheck archivelog all; delete noprompt expired archivelog all; delete noprompt archivelog all completed before 'sysdate-1';} exit; EOF

 

Exit