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$archived_log.name) where sequence# > [the max number you purged the last time];
2. Cycle through the above list and remove the files;
3. Record the max(sequence#) from v$log_history for the next purge.
Any other ideas/suggestions?
AtDhVaAnNkCsE!!!
Steve Orr
Standing by in Bozeman, Montana