Quote Originally Posted by bazza
Rather than writing pl/sql, can't you just set up a threshold/notifcation (in grid - I know you use it!!) for when the file system/archive area hits x% full? If you still want to automatically kick the rman job, then set a response action up.
Either that or more space ;-)

Bazza
Yea, Great suggestion. I'd love to do this. I'm just not real comfortable with the alerting system 10g OEM. We've been running it side by side with other systems and they have been 100% right on, while OEM has missed some really big problems 50% of the time. That's probably me, but I think it needs help.

I also have the addition of not wanting to fire this when an rman backup (datafile or archivelog) is already running.

There's probably a sql query that could tell me if the db is currently being backed up through rman.

I'm working along the lines of a cron job that counts the rows in v$archived_log where status = 'A' ('D' is deleted), and if rman isn't already running (grep rman or something) and I've got 20 archived logs or so, then kick off the rman process.

Any thoughts/opinions are greatly appreciated.

-Ken