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

STANDBY SERVER SunOS 5.10 & Oracle version 9.2.0.1.0


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: Thu Mar 28 10:44:14 CDT 2024