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

"Edwinah63" <edwinah_at_customercare.com.au> wrote in 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?
>
> code or link to code appreciated!
>
> Edwinah63
>

Have you read any of the Fine Manuals on RMAN that Oracle provides at http://tahiti.oracle.com

????????????????????????

You've said in other threads that this is a HOTBACK environment. As the current redo logfile fills up, the archiver process will archive it. This is an ongoing process.
You shouldn't backup the current redo log file, becuase it is not complete. Received on Tue Jul 05 2005 - 21:04:09 CDT