Re: ORA -16014 - Error in archiving, no available destination

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 24 Mar 2004 05:54:00 +1100
Message-ID: <406087ca$0$8356$afc38c87@news.optusnet.com.au>

"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0403230526.5f566f8d_at_posting.google.com...
> Prem,
> You may get the reason for failure in V$ARCHIVE_DEST and
> V$ARCHIVE_DEST_STATUS.
> You need not bounce the database to restart archiving.
> you can
> 1) issue the command alter system archive log start to '<[current
> destination]>';
> 2) Stop and restart the archiver process.
> 3) give the REOPEN parameter in log_archive_dest_n
> If the REOPEN clause is not specified, it is automatically set to 0.
> This means that if an error of archiving occurs, the database still
> operates until it tries to overrite the corresponding log at which
> time, the database hangs.
> If a destination is MANDATORY, Oracle Corporation recommends that you
> specify REOPEN. If you do not specify seconds, the default value is
> 300 seconds.

"If the reopen clause is not specified it is automatically set to 0" "If you do not specify seconds the default value is 300"

These two statements don't make sense together.

SQL> alter system set log_archive_dest_1="LOCATION=C:\" scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 68229684 bytes

Fixed Size                   453172 bytes
Variable Size              41943040 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.

SQL> select reopen_secs from v$archive_dest;

REOPEN_SECS

---

        300
          0

etc etc etc

Not specified, yet the 300 (thanks for the correction) default still applies.

Regards
HJR Received on Tue Mar 23 2004 - 12:54:00 CST