If you use OEM (or similar) - you can schedule a job to perform:
LIST ARCHIVELOG UNTIL TIME 'SYSDATE - 7';
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE - 7';
(will keep 7 days worth of logs on the server for immediate access)
Adjust to your needs...
-----Original Message-----
From: LeRoy Martin
[mailto:oracledba-ezmlmshield-x53523874.[Email address protected]
Sent: Wednesday, June 28, 2006 3:36 PM
To: LazyDBA Discussion
Subject: Automated removal of archive logs
Hello All,
Oracle 9.2.0.7
Windows 2003
What determines when old archive logs are removed/purged from the
archive_log_dest? Is this something that can be set in Oracle via an
init.ora param, or do I need to schedule a job to run that removes files
older than a number of days from that directory....etc.
Thank you,
Martin
------------------------------------------------------------------------
------
This message is intended only for the personal and confidential use of
the designated recipient(s) named. If you are not the intended recipient
of this message, you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be
regarded as an offer to sell or as a solicitation of an offer to buy any
financial product, an official confirmation of any transaction, or as an
official statement of Aurora Loan Services. Email transmission cannot be
guaranteed to be secure or error-free. Therefore, we do not represent
that this information is complete or accurate and it should not be
relied upon as such. All information is subject to change without
notice.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page