Re: ORA-00271: there are no logs that need archiving

"Edwinah63" <edwinah_at_customercare.com.au> wrote in message news:1120611079.759159.241310_at_o13g2000cwo.googlegroups.com...
> 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?

Just use alter system archive log current; instead of alter system switch logfile; alter system archive log all; It's enough!

RTM:
SQL Reference
ALTER SYSTEM
CURRENT Clause

Specify CURRENT to manually archive the current redo log file group of the specified thread, _forcing a log switch_. If you omit the THREAD parameter, then Oracle archives all redo log file groups from all enabled threads, _including logs previous to current logs_. You can specify CURRENT only when the database is open.

>
> code or link to code appreciated!
>
> Edwinah63
>
Received on Wed Jul 06 2005 - 02:01:13 CDT