Delete old DB logs

[TSch]

Hi folks,

currently we're using the following commands in a script to get rid of old DB logs:

find /usr/oracle/DB/flash_recovery_area/DB/archivelog/ -name *.arc -mtime +2 -exec rm {} \;
su - oracle -c /usr/oracle/cleanlogs

However ... I was wondering if this is the correct approach to this or if there's an official way using DB tools or DB settings to accomplish the same ...

Any ideas ?

Regards
Thomas

 

[LKBrwnDBA]

You should back them up with RMAN and let RMAN remove the logs. In fact you should use RMAN for database backups.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb