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&#
Steve,
It's pretty simple. No need to record anything - see the Order By
Descending in the SQL below.
Here are a batch file and a SQL script I used on an 8.1.7 Standby DB under
Win2k. It ran reliably for months as a Scheduled Task once every hour and
got rid of all applied logs, assuming that
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,
