Archivelog

[andimfeeble]

Good evening!

I use a tool to back up on Oracle that is in the "mode archivelog", but gave a problem and the folder flash_recovery_area\ORACLE\ARCHIVELOG is full, starting the bank, so I had to Increase the space size of this area with the command:

Select all

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=4294967296 SCOPE=BOTH;

I would like to know how do I delete the archives folder archivelog and empty it?

Thanks ...


Oracle 11g R1:
Windows Server 2008 R2:

[elidias7]

Oops.

I advise you to use RMAN to do this, because with this you synchronize the controlling to what really exists in the directory.

RMAN> Delete Archivelog Until Time 'sysdate-n'

Hugs,

[crishpg]

It is the tip for people who delete the archivelogs by the operating system.
Rotate the commands below.

Select all

crosscheck archivelog all; 
delete expired archivelog all;