Oracle 7.3 - ORA-03114 - auto recovery?

From: Dick Bennion <dbennion_at_my-deja.com>
Date: Mon, 07 Jun 1999 06:20:49 GMT
Message-ID: <7jfobr$ff4$1@nnrp1.deja.com>

We have a commercial application that uses Oracle, MSSQL or SQL Anywhere. The product runs in a Fault Tolerant Mode. There is a primary database and a standby database.

One of the tests is to disconnect the machine where our master program runs (using the primary db on a different machines) for 30 secs and then reconnect. Nasty Nasty thing to do to a database. Well we get ORA-03113 and ORA-03114 error messages. Is there a way I can automatically recover from this kind of error?

Any help would be much appreciated.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 07 1999 - 01:20:49 CDT