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
Reply With Quote