ORA-604/ORA-1092

From: <Rhojel_Echano_at_sgs.com>
Date: Wed, 30 Jun 2004 18:02:19 +0800
Message-ID: <OFC1E158C8.690AA5B4-ON48256EC3.00362516-48256EC3.00371D8E@sgs.com>

Hi everyone,
I got this error when I tried to open read only our standby database:
(from a 10046 trace)

ORA-00604: error occurred at recursive SQL level 1
ORA-00372: file 1 cannot be modified at this time
ORA-01110: data file 1: 'F:\XPCWEB\DB\DATA\TBS_SYSTEM_01.DBF'

(from alert log)

ORA-01092: ORACLE instance terminated. Disconnection forced

I saw documents that describe workarounds for this but mostly on primary instances.
Standby is a different case, apparently. I've scoured Metalink for an answer and I saw this forum in which an Oracle support
personnel tried to point a customer to Note 222460.1 but it doesn't seem to exist.
(the customer in that forum also informed the Support personnel that he
can't find
the said Note).

Anyone experienced this in the past? I would appreciate any help.

TIA
Rhojel Echano

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 30 2004 - 05:15:19 CDT