Oracle Database Discussions

Hi all ,

i have 10.2.0.2 DB runs on Redhat , i use DG conf . i have primary and standby servers.

sometimes DMON process terminated abnormally on primary DB and getting started after 3-4 seconds. after new start everything works fine. Unfortuantely i dont know why it behaves like that.

i search dataguard log , alert log trace file etc. Unfortunately not clear information.

i just can see these logs on dataguard log ;

DG 2013-03-02-11:06:25 0 2 0 NSV1: No DMON process running, NetSlave exiting...
DG 2013-03-02-11:06:25 0 2 0 NSV1: NetSlave shutting down.
DG 2013-03-02-11:06:27 0 2 0 PMON: DMON terminated abnormally, beginning cleanup
DG 2013-03-02-11:06:27 0 2 0 PMON Deregistering service PRM_DGB with listener(s)
DG 2013-03-02-11:06:27 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]
DG 2013-03-02-11:06:27 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully
DG 2013-03-02-11:06:27 0 2 0 PMON: Terminating RSM processes
DG 2013-03-02-11:06:27 0 2 0 RSM0: delete state object for RSM0
DG 2013-03-02-11:06:28 0 2 0 INSV: No DMON process running, Instance Slave exiting...
DG 2013-03-02-11:06:28 0 2 0 Instance Slave shutting down
DG 2013-03-02-11:06:28 0 2 0 PMON: RSM0 successfully terminated
DG 2013-03-02-11:06:28 0 2 0 PMON: Terminating NetSlave processes
DG 2013-03-02-11:06:28 0 2 0 PMON: Terminating Instance Slave process
DG 2013-03-02-11:06:28 0 2 0 PMON: Zeroing metadata root pointer
DG 2013-03-02-11:06:28 0 2 0 PMON: Clearing Primary State
DG 2013-03-02-11:06:28 0 2 0 PMON: Freeing Broker SGA heap
DG 2013-03-02-11:06:28 0 2 0 PMON: Zeroing DMON's PGA heap pointer
DG 2013-03-02-11:06:28 0 2 0 PMON: Removing DMON's state object
DG 2013-03-02-11:06:28 0 2 0 PMON: Resetting DMON context structure
DG 2013-03-02-11:06:28 0 2 0 PMON: >> Broker cleanup complete <<
DG 2013-03-02-11:06:28 0 2 0 PMON: restart Data Guard Broker Process, DMON
DG 2013-03-02-11:06:31 0 2 0 DMON: >> Starting Data Guard Broker bootstrap <<
DG 2013-03-02-11:06:31 0 2 0 DMON: Attach state object
DG 2013-03-02-11:06:31 0 2 0 DMON: chief lock convert for bootstrap
DG 2013-03-02-11:06:31 0 2 0 DMON Registering service PRM_DGB with listener(s)
DG 2013-03-02-11:06:31 0 2 0 Executing SQL [ALTER SYSTEM REGISTER]
DG 2013-03-02-11:06:31 0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully
DG 2013-03-02-11:06:31 0 2 0 DMON: Broker Configuration csp_dg
DG 2013-03-02-11:06:31 0 2 0 Protection Mode: Maximum Availability
DG 2013-03-02-11:06:31 0 2 0 Primary Database: PRM (01010000)
DG 2013-03-02-11:06:31 0 2 0 Standby Database: STDDG, Enabled Physical Standby (02010000)
DG 2013-03-02-11:06:31 0 2 0 #### NSV network timeout value set to 0 seconds by NSV1




alert log ;

Thread 1 advanced to log sequence 28002
Current log# 1 seq# 28002 mem# 0: /u01/app/oracle/oradata/PRM/redo1_01.dbf
Sat Mar 2 11:06:28 2013
Completed: Data Guard Broker shutdown
DMON started with pid=20, OS id=1220
Starting Data Guard Broker (DMON)
NSV1 started with pid=16, OS id=1222
INSV started with pid=21, OS id=1224
RSM0 started with pid=22, OS id=1242
Sat Mar 2 11:06:44 2013



thanks for your help.