On Oct 11, 2005, at 3:50 PM, Denny Koovakattu wrote:
All,
I am trying to catch up on my email, so this might have already been discussed.
Version: 9.2.0.4 Protection: MAXIMUM PERFORMANCE log_archive_max_processes=2 log_archive_dest_2="SERVICE=standby_alias LGWR ASYNC REOPEN=60" log groups = 3 log file size = 1G
I have seen this behavior recently with a really slow (NOT broken) network.
All the archiver processes were busy copying the archive log files over to the
standby and none were available to archive the last log group. The database was
hung until we manually archived the logfiles. (Haven't experimented to find a
workaround since we are working on fixing the network.)
Regards, Denny -- Denny Koovakattu
Sten
_______________ Sten Rognes Berkeley, CA -- //www.freelists.org/webpage/oracle-l