Using RMAN to delete Archivelog files in Oracle 11g

The following process is very useful when you're working with express Oracle database version, due to the limited size for log archives in this versions when you reach the limit the listener service will continue to operate correctly but the databases won't be able to start.

Entering RMAN and cleaning all the log archives:

1.- Open RMAN tool from CMD, you just need to execute the instruction rman without moving to any directory:

2.-Login to your database:

CONNECT TARGET /

Using this command you login using windows authentication.

3.- View the archive log files:

RMAN>list archivelog all;
RMAN>list copy of archivelog until time ‘SYSDATE-10′;
RMAN>list copy of archivelog from time ‘SYSDATE-10′
RMAN>list copy of archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>list copy of archivelog from sequence 1000;
RMAN>list copy of archivelog until sequence 1500;
RMAN>list copy of archivelog from sequence 1000 until sequence 1500;

4.- Delete the archive log files:

RMAN>delete archivelog all;
RMAN>delete archivelog until time ‘SYSDATE-10′;
RMAN>delete archivelog from time ‘SYSDATE-10′
RMAN>delete archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;
RMAN>delete archivelog from sequence 1000;
RMAN>delete archivelog until sequence 1500;
RMAN>delete archivelog from sequence 1000 until sequence 1500;