Re: Backup script exception handling - code please

Edwinah63 wrote:
> 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

You can run the "alter" statement inside a PL/SQL anonymous block via dynamic sql and capture the error e.g.

• Use prompt to show what is about to happen prompt Archive log all begin execute immediate 'alter system archive log all'; exception when others then null; -- This just bypasses the error if that is what you are after. end; /

Regards
/Rauf Received on Wed Jun 22 2005 - 03:42:12 CDT