Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA -16014 - Error in archiving, no available destination

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

From: srivenu <srivenu_at_hotmail.com>
Date: 23 Mar 2004 05:26:59 -0800
Message-ID: <1a68177.0403230526.5f566f8d@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.

regards
Srivenu Received on Tue Mar 23 2004 - 07:26:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US