Backup script exception handling - code please

i would like some help with exception handling for my backup script.

when i issue the command:

alter system archive log all;

i sometimes get the error:

ora-00271

ora-00271: there are no logs that need archiving

the script still keeps executing fine, but i would like an elegant error handler that if the ora-00271 error occurs, just continue as normal and don't raise an error.

here is an edit of my backup script:

alter system switch logfile;
alter system archive log all;
alter system archive log current;
host copy F:\oracle\assist\archive\*.* F:\oracle\Backups\Assist\*.*

have had a google around but can only find sql exception handling and am not sure if it applies in this instance.

applicable error handling sample code would be greatly appreciated.

Edwinah63 Received on Wed Jun 22 2005 - 00:25:57 CDT