ORA-00271: there are no logs that need archiving

edit from backup script:

alter system switch logfile;
alter system archive log all;
alter system archive log current;
host copy Q:\myDB\archive\*.* Q:\Backups\myDB\*.* exit;
alter system archive log all
*
ERROR at line 1:
ORA-00271: there are no logs that need archiving

when i look in the alert logs i find messages like this:

ARCH: Unable to archive log 1 thread 1 sequence 7243

      Log actively being archived by another process

my question is: is there any code where i can check that the archiving process has completed before i proceed to the next step in the script?

code or link to code appreciated!

Edwinah63 Received on Tue Jul 05 2005 - 19:51:19 CDT