How to clear the archive log

Some time, the archive is full, we have to clear the archive log and then make the database normal.

The following way, maybe is useful to you.

1. For NO-DATAGUARD:

--- 1. Check the archivelog folder

# df -k

# su - oracle

$ sqlplus / as  sysdba

SQL> archive log  list;

 

--- 2. Move some old history archivelog files to the  other folder which have enough free space

Maybe sometimes, we  can't login the database or the rman, so, we must move some old archivelog  files to the other folder, so that we can login the rman.

 

--- 3. Clear the history archivelog

# su - oracle

$ rman target /

RMAN> delete  noprompt archivelog until time 'sysdate-1';

RMAN> crosscheck  archivelog all;

RMAN> delete  obsolete;

RMAN> exit;

$ sqlplus / as sysdba

SQL> alter  system switch logfile;

 

--- 4. Please finish a FULL backup for the current  database.

The old full backup  have become to invalid, we must backup the current database.

 

 

 

2. For DATAGUARD:

--- 1. Check the following on the  primary database and the standby database

On the primary database:

# su - oracle

$ sqlplus / as sysdba

SQL> archive log list;

On the standby database:

# su - oracle

$ sqlplus / as sysdba

SQL> set linesize 400

SQL> archive log list;

SQL> select process,status,thread#,sequence#,block#,blocks from  v$managed_standby;

 

--- 2. If the archivelog folder  close to full on the standby database

On the standby database:

You can clear archive log using the above steps.

 

--- 3. If the archivelog folder  close to full on the primary database

On the primary database:

# su - oracle

$ rman target /

RMAN> delete noprompt archivelog until time 'sysdate -1'backed up 1 times to device type disk;  <===== If there  are some archvielog files which didn’t move to the standby database after had  finished the full rman backup in the primary database, will be move, and have to rebuild the  standby database.

If there are some old history archivelog can't delete, and show  warning:RMAN-08137

Please don't remove them directly, because of they didn't were moved to  the standby database, we have to check status of the standby database.

RMAN> crosscheck archivelog all;

RMAN> delete obsolete;

RMAN> exit;