|
主库上
SQL> show parameter archive
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
archive_lag_target integer 0
log_archive_config string dg_config=(DG_M,DG_S)
log_archive_dest string
log_archive_dest_1 string location=/oracle/archive_log/a
rch_%t_%s_%r.arc valid_for=(al
l_logfiles,all_roles) db_uniqu
e_name=DG_M
log_archive_dest_10 string
log_archive_dest_2 string service=DGS reopen=120 lgwr as
ync valid_for=(online_logfiles
,primary_role) db_unique_name=
DG_S
SQL> SELECT STATUS,DESTINATION, ERROR FROM V$ARCHIVE_DEST;
STATUS DESTINATION ERROR
----------------------------------------------------------------------------------------------
VALID /oracle/archive_log/arch_%t_%s_%r.arc
VALID DGS
备库上
SQL> SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM
V$MANAGED_STANDBY WHERE CLIENT_PROCESS='LGWR' OR PROCESS='MRP0'; 2
CLIENT_PROCESS PROCESS THREAD# SEQUENCE# STATUS
------------------------ --------------------------- ---------- ---------- ------------------------------------
LGWR RFS 1 28 IDLE //这儿缺MRP0进程
然后再备库上起这个进程
SQL> alter database recover managed standby database disconnect from session;
Database altered.
再次查看这个进程还是没有。
alert日志里边有
alter database recover managed standby database disconnect from session
Thu Mar 26 01:10:12 2015
Attempt to start background Managed Standby Recovery process (DG)
MRP0 started with pid=18, OS id=1414
Thu Mar 26 01:10:12 2015
MRP0: Background Managed Standby Recovery process started (DG)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 2 processes
Thu Mar 26 01:10:17 2015
Waiting for all non-current ORLs to be archived...
Thu Mar 26 01:10:17 2015
Errors in file /oracle/admin/DG/bdump/dg_mrp0_1414.trc:
ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+14774] [SIGSEGV] [Address not mapped to object] [0x000000060] [] [] //这个地方发生了错误
Thu Mar 26 01:10:18 2015
Completed: alter database recover managed standby database disconnect from session
/oracle/admin/DG/bdump/dg_mrp0_1414.trc这个文件 部分内容如下:
/oracle/admin/DG/bdump/dg_mrp0_1414.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/10.2
System name: Linux
Node name: ora2
Release: 2.6.32-358.el6.x86_64
Version: #1 SMP Fri Feb 22 00:31:26 UTC 2013
Machine: x86_64
Instance name: DG
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 1414, image: oracle@ora2 (MRP0)
*** SERVICE NAME ) 2015-03-26 01:10:12.600
*** SESSION ID 151.3) 2015-03-26 01:10:12.600
ARCH: Connecting to console port...
*** 2015-03-26 01:10:12.601 62692 kcrr.c
MRP0: Background Managed Standby Recovery process started
*** 2015-03-26 01:10:17.602 1118 krsm.c
Managed Recovery: Initialization posted.
*** 2015-03-26 01:10:17.602 62692 kcrr.c
Managed Standby Recovery not using Real Time Apply
Recovery target incarnation = 2, activation ID = 1788472964
Influx buffer limit = 22230 (50% x 44460)
Successfully allocated 2 recovery slaves
Using 550 overflow buffers per recovery slave
Start recovery at thread 1 ckpt scn 693149 logseq 26 block 2
*** 2015-03-26 01:10:17.690
Media Recovery add redo thread 1
*** 2015-03-26 01:10:17.690 1118 krsm.c
Managed Recovery: Active posted.
*** 2015-03-26 01:10:17.692
Media Recovery Log /oracle/archive_log/arch_%t_%s_%r.arcarch_1_26_875137348.arc
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x60, PC: [0x7f804c67dc06, _IO_vfprintf_internal()+14774]
*** 2015-03-26 01:10:17.692
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+14774] [SIGSEGV] [Address not mapped to object] [0x000000060] [] []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7F804C633D50 ? 7F804C633DB0 ?
7F804C633CF0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7F804C633D50 ? 7F804C633DB0 ?
7F804C633CF0 ? 000000000 ?
ssexhd()+629 call ksedmp() 000000003 ? 000000001 ?
7F804C633D50 ? 7F804C633DB0 ?
7F804C633CF0 ? 000000000 ?
__restore_rt()+0 call ssexhd() 00000000B ? 7F804C634D70 ?
7F804C634C40 ? 7F804C633DB0 ?
7F804C633CF0 ? 000000000 ?
_IO_vfprintf_intern signal __restore_rt() 000000060 ? 000000000 ?
al()+14774 7FFF2DD89580 ?
FFFFFFFFFFFFFFFF ?
7FFF2DD895F8 ? 000000060 ?
_IO_vsnprintf()+162 call _IO_vfprintf_intern 7FFF2DD8A590 ? 7FFF2DD8ECC3 ?
al() 7FFF2DD8B848 ?
FFFFFFFFFFFFFFFF ?
7FFF2DD895F8 ? 000000060 ?
ksdwra()+257 call _IO_vsnprintf() 7FFF2DD8A6F0 ? 7FFF2DD8ECC3 ?
7FFF2DD8EC74 ? 7FFF2DD8B848 ?
7FFF2DD895F8 ? 000000060 ?
kcrrfmw()+812 call ksdwra() 7FFF2DD8EC74 ? 000000060 ?
07FB845F8 ? 000000000 ?
000000000 ? 00000001A ?
kcrrwra()+136 call kcrrfmw() 000000000 ? 000000060 ?
07FB845F8 ? 000000000 ?
00000117A ? 000000000 ?
krddmr()+11990 call kcrrwra() 000000000 ? 000000060 ?
07FB845F8 ? 000000000 ?
00000117A ? 000000000 ?
krsmdp()+1873 call krddmr() 0080DE210 ? 000000001 ?
7FFF2DD92F94 ? 000000000 ?
7F804C4970E0 ?
80DE21000000001 ?
ksbrdp()+794 call krsmdp() 0600173C0 ? 000000001 ?
000000000 ? 000000000 ?
7F804C4970E0 ?
80DE21000000001 ?
opirip()+616 call ksbrdp() 0600173C0 ? 000000001 ?
000000001 ? 0600173C0 ?
7F804C4970E0 ?
80DE21000000001 ?
.........
下边全是些底层的东西了!
|
|