If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Delete old archivelogs automatically

Hi,

Is there a way to delete old archive logs automatically, lets say older than one week? I dont want to backup or use older than one week archives and I want them to be deleted automatically.
I am using oracle 10g and Sun solaris 10.

I guess there is a misunderstanding, I dont want any backup, I just wanted them to be deleted automatically.
I know how to delete at RMAN, but I needed this to be done automatic in specified time period.
Thanks

If I do this, Oracle will not know those files were deleted and when the DB_RECOVERY_FILE_DEST_SIZE reaches, database will not open. This was happened on one of our servers and my boss wanted that archive logs must be deleted AUTOMATICALLY.

Oracle has no archive log memory

Originally Posted by Zenryou

If I do this, Oracle will not know those files were deleted and when the DB_RECOVERY_FILE_DEST_SIZE reaches, database will not open. This was happened on one of our servers and my boss wanted that archive logs must be deleted AUTOMATICALLY.

If you are using ASM, you need to use RMAN to remove the archive logs.

In any case, once the archive logs are written, Oracle does not care if you remove them or not (unless you need to recover the db).

Add gandolf989's suggested command to crontab.

"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb