Home » Server Options » Data Guard » Standby testing (
Standby testing [message #376711] Thu, 18 December 2008 06:03
Messages: 30
Registered: October 2007
Location: India
I have the following configuration of my Primary & Standby Databases
PRIMARY SERVER SunOS 5.9 & Oracle version

STANDBY SERVER SunOS 5.10 & Oracle version

The problem is when i open my standby database in read only mode ,i get following error:---

Errors in file /home/oracle/admin/spd/udump/spd_ora_1422.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1422
ORA-1092 signalled during: alter database open read only...

Trace file attached ---

can any one suggest me this solution ...

Previous Topic: ORA-16004: backup database requires recovery -Standby database
Next Topic: Data Guard Implementation
Goto Forum:

Current Time: Tue Oct 27 19:06:16 CDT 2020