I'm using Oracle 10.2.0.4 on linux and found errors in alert log in the standby. The primary database uses "ARCH" to transfer archived log files to logical standby database. Also, I set the
sga_max_size,
sga_target,
pga_aggregate_target to 2G on the 32bit linux.
It occurs when quite a large transactions received from the logical standby
Doing block recovery for file 23 block 368047
Doing block recovery for file 23 block 368047
Tue Jul 21 14:14:29 2009
Errors in file /u01/ora10/admin/ORCL/bdump/ORCL_p004_23022.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 4024 bytes (knas:shtrans,knas: rpc arguments)
ORA-04030: out of process memory when trying to allocate 124 bytes (knas:sh,knas: rpc arguments)
Tue Jul 21 14:14:34 2009
Doing block recovery for file 23 block 368047
Block recovery from logseq 139, block 122446 to scn 5154981
Tue Jul 21 14:14:34 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 139 Reading mem 0
Mem# 0: /u01/oradata/ORCL/redo_log01.dbf
Block recovery completed at rba 139.123014.16, scn 0.5154982
Tue Jul 21 14:14:35 2009
Errors in file /u01/ora10/admin/ORCL/bdump/ORCL_lsp0_22926.trc:
ORA-12805: parallel query server died unexpectedly
Tue Jul 21 14:14:35 2009
TLCR process death detected. Shutting down TLCR
Tue Jul 21 14:14:35 2009
logminer process death detected, exiting logical standby
LOGSTDBY Apply process P006 pid=21 OS id=23026 stopped
LOGSTDBY Apply process P008 pid=23 OS id=23030 stopped
LOGSTDBY Analyzer process P003 pid=18 OS id=23020 stopped
LOGSTDBY Apply process P007 pid=39 OS id=19384 stopped
LOGSTDBY Apply process P005 pid=20 OS id=23024 stopped
SQL> show parameter parallel
NAME TYPE VALUE
------------------------------------ -------------------- ------------------------------
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_execution_message_size integer 2148
parallel_instance_group string
parallel_max_servers integer 80
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
Does anybody know the cause and resolution of it?
Thanks!