Automatically run script when archive_log_dest fills up
Hello everyone!
I would like to know if it would be possible, that when the archive_log_dest destination fills up with archived redo logs, some script is automatically run to clean it up?
The script would be a standard unix shellscript containg rman commands, ie:
---
backup archivelog all not backed up 2 times;
backup archivelog all not backed up 2 times;
delete noprompt archivelog all backed up 2 times to 'SBT_TAPE';
---
Could it be done by creating a job in dbms_scheduler that's triggered by this event? You can define a triggering event for jobs in dbms_scheduler, but it seems I can only pick from queues..
I would like to know if it would be possible, that when the archive_log_dest destination fills up with archived redo logs, some script is automatically run to clean it up?
The script would be a standard unix shellscript containg rman commands, ie:
---
backup archivelog all not backed up 2 times;
backup archivelog all not backed up 2 times;
delete noprompt archivelog all backed up 2 times to 'SBT_TAPE';
---
Could it be done by creating a job in dbms_scheduler that's triggered by this event? You can define a triggering event for jobs in dbms_scheduler, but it seems I can only pick from queues..
0