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
