Title: RE: Purging Managed Standby Database Archive Logs
For pre 9i release2 there is following Note on
metalink
Doc
ID:
Note:190311.1
Subject:
** How to delete an Operating System file from
PL/SQL
This uses a java stored
Title: RE: Purging Managed Standby Database Archive Logs
Hello Steve
If you are on 9.2 you can use utl_file.fremove directly
from the sql.
Yechiel AdarMehish
- Original Message -
From:
Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 12
Title: RE: Purging Managed Standby Database Archive Logs
Hi John,
Keeping things simple sometimes complicates things when they go haywire. I thought about the simple shotgun approach but wanted something a little more robust and I didn't want to risk deleting an archive log that hadn
[EMAIL PROTECTED] Subject: Purging Managed Standby
Database Archive Logs
Keep it simple. If you are on unix put this in your crontab.
30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc"
-mtime +0 -exec rm -f {} \;
This will run every hour on the half hour and purge everything over 24
hours old.
Modify as you like. (-mtime +1 gives you 48 hours) Yes,
Title: Purging Managed Standby Database Archive Logs
Any one have a ready-made routine to purge the unneeded archives which have been automagically applied to a managed standby database?
I figure it needs to:
1. Query v$archived_log and v$log_history to get a list of the archive logs (v