Standby database problem

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Fri, 8 Mar 2002 09:56:31 -0500
Message-ID: <a6ajf0$d4i98$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

I have an 8.1.7 managed standby database that occasionally gets placed into read-only mode and then brought back into managed standby mode. Some time after being put back into standby mode, the production database fails to send a log over to it. It's usually the 2nd or 3rd archived log generated after putting the database back into standby mode that fails to ship over. The error in the production database's v$archive_dest view is always the same: "ORA-03113 end of file on communication channel". What is causing this and is there a way to prevent it? Is there an easy solution to have Oracle automatically retry to ship the log? Upgrading to 9i is not an option. The platform is SGI which is desupported after 8i.

-----BEGIN PGP SIGNATURE-----

Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPIjRHGm5A4kkb4ZsEQI+dgCfVzJo2E8TTniL7dKV7A9ENLd47MYAnig5 wtOHkAcG6B63QWbfFw4/jT1I
=P9dO
-----END PGP SIGNATURE-----
Received on Fri Mar 08 2002 - 08:56:31 CST