How do I set up oracle archivelog deletion policies?

richcoit
richcoit used Ask the Experts™
on
I would like to set up an archivelog deletion policy where after the backup to tape has been performed, the logs in the archivelog folder are moved to an alternative location. We have the standard edition of oracle 10G.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
if you use rman to backup archive logs you can backup them with DELETE INPUT option to remove them from disk after backup
http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc3.htm

And if you really want to move them to another location you can schedule OS script to move them after backup completion

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial