关闭同步库的app进程 hr_app_stream

Fri Dec 30 13:14:16 2011

AP01: warning — apply server 3, sid 35 waiting for event (since 75768 seconds):

AP01: warning — apply server 2, sid 38 waiting for event (since 75768 seconds):

AP01: warning — apply server 1, sid 17 waiting for event (since 75768 seconds):

Fri Dec 30 13:24:13 2011

Streams Apply Server AS02 for HR_APP_STREAM with pid=28 OS id=14483 stopped

Fri Dec 30 13:24:13 2011

Streams Apply Server AS03 for HR_APP_STREAM with pid=29 OS id=14485 stopped

Fri Dec 30 13:24:13 2011

Streams Apply Server AS04 for HR_APP_STREAM with pid=30 OS id=14487 stopped

Fri Dec 30 13:24:13 2011

Streams Apply Server AS05 for HR_APP_STREAM with pid=31 OS id=14489 stopped

Fri Dec 30 13:24:13 2011

Streams Apply Reader AS01 for HR_APP_STREAM with pid=27 OS id=14481 stopped

Fri Dec 30 13:24:16 2011

Streams APPLY AP01 for HR_APP_STREAM with pid=26, OS id=14479 stopped

downstream库的日志变化

Fri Dec 30 13:17:28 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_15_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Fri Dec 30 13:17:28 2011

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 15, /u01/arch/1_15_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 15, /u01/arch/1_15_771076032.dbf

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_15_771076032.dbf’ for ‘hr_cap_stream’

–正常的情况

Fri Dec 30 13:25:31 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_16_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Fri Dec 30 13:25:31 2011

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 16, /u01/arch/1_16_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 16, /u01/arch/1_16_771076032.dbf

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_16_771076032.dbf’ for ‘hr_cap_stream’

Fri Dec 30 13:25:32 2011

knlbmEnq: all subscribers are inactive – stop enqueuing

–发现问题,因为无法从本地传播到远端

关闭downstream库的cap进程 HR_CAP_STREAM

Fri Dec 30 13:29:24 2011

LOGMINER: session#=1 (HR_CAP_STREAM), reader MS00 pid=28 OS id=7898 sid=23 stopped

Fri Dec 30 13:29:24 2011

LOGMINER: session#=1 (HR_CAP_STREAM), builder MS01 pid=29 OS id=7900 sid=30 stopped

Fri Dec 30 13:29:24 2011

LOGMINER: session#=1 (HR_CAP_STREAM), preparer MS02 pid=30 OS id=7902 sid=32 stopped

Fri Dec 30 13:29:29 2011

Streams CAPTURE CP01 for HR_CAP_STREAM with pid=25, OS id=7802 stopped

继续注册日志,发现可以成功,但是无法挖掘

Fri Dec 30 13:30:17 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_23_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_23_771076032.dbf’ for ‘hr_cap_stream’

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_24_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_24_771076032.dbf’ for ‘hr_cap_stream’

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_25_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_25_771076032.dbf’ for ‘hr_cap_stream’

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_26_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_26_771076032.dbf’ for ‘hr_cap_stream’

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_27_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Completed: ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_27_771076032.dbf’ for ‘hr_cap_stream’

开启2边的进程

开启同步库的app进程 hr_app_stream

Fri Dec 30 13:33:17 2011

Streams APPLY AP01 for HR_APP_STREAM started with pid=27, OS id=18819

Fri Dec 30 13:33:17 2011

Streams Apply Reader for HR_APP_STREAM started AS01 with pid=28 OS id=18821

Fri Dec 30 13:33:17 2011

Streams Apply Server for HR_APP_STREAM started AS02 with pid=29 OS id=18823

Fri Dec 30 13:33:17 2011

Streams Apply Server for HR_APP_STREAM started AS03 with pid=30 OS id=18825

Fri Dec 30 13:33:17 2011

Streams Apply Server for HR_APP_STREAM started AS04 with pid=31 OS id=18827

Fri Dec 30 13:33:17 2011

Streams Apply Server for HR_APP_STREAM started AS05 with pid=32 OS id=18829

Fri Dec 30 13:33:47 2011

Propagation Receiver (CCA) for Streams Capture HR_CAP_STREAM and Apply HR_APP_STREAM with pid=25, OS id=18812, objnum=74500 started.

开启downstream库的cap进程 HR_CAP_STREAM

Fri Dec 30 13:31:45 2011

Streams CAPTURE CP01 for HR_CAP_STREAM started with pid=25, OS id=18079

Fri Dec 30 13:31:46 2011

Propagation Sender (CCA) HR_PRO_STREAM for Streams Capture and Apply [on destination INERAPP.ORACLE.COM] with pid=26, OS id=18081 started.

Fri Dec 30 13:33:47 2011

Propagation Sender (CCA) HR_PRO_STREAM for Streams Capture HR_CAP_STREAM successfully re-connected to Apply HR_APP_STREAM (objnum=74500) with pid=26, OS id=18081.

挖掘进程又开始正常工作

downstream库的日志变化

Fri Dec 30 13:33:47 2011

Streams CAPTURE CP01 for HR_CAP_STREAM with pid=25, OS id=18079 is in combined capture and apply mode.

Capture HR_CAP_STREAM is handling 1 applies.

Streams downstream capture HR_CAP_STREAM uses downstream_real_time_mine: FALSE

Starting persistent Logminer Session with sid = 1 for Streams Capture HR_CAP_STREAM

LOGMINER: Parameters summary for session# = 1

LOGMINER: Number of processes = 3, Transaction Chunk Size = 1

LOGMINER: Memory Size = 15M, Checkpoint interval = 1000M

LOGMINER: SpillScn 0, ResetLogScn 972274

LOGMINER: summary for session# = 1

LOGMINER: StartScn: 1148785 (0×0000.00118771)

LOGMINER: EndScn: 0

LOGMINER: HighConsumedScn: 1148785 (0×0000.00118771)

LOGMINER: session_flag 0×0

LOGMINER: LowCkptScn: 1107658 (0×0000.0010e6ca)

LOGMINER: HighCkptScn: 1107659 (0×0000.0010e6cb)

LOGMINER: SkipScn: 1107658 (0×0000.0010e6ca)

Fri Dec 30 13:33:48 2011

LOGMINER: session#=1 (HR_CAP_STREAM), reader MS00 pid=27 OS id=18744 sid=32 started

Fri Dec 30 13:33:48 2011

LOGMINER: session#=1 (HR_CAP_STREAM), builder MS01 pid=28 OS id=18746 sid=46 started

Fri Dec 30 13:33:48 2011

LOGMINER: session#=1 (HR_CAP_STREAM), preparer MS02 pid=29 OS id=18748 sid=30 started

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 12, /u01/arch/1_12_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 12, /u01/arch/1_12_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 13, /u01/arch/1_13_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 13, /u01/arch/1_13_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 14, /u01/arch/1_14_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 14, /u01/arch/1_14_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 15, /u01/arch/1_15_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 15, /u01/arch/1_15_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 16, /u01/arch/1_16_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 16, /u01/arch/1_16_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 17, /u01/arch/1_17_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 17, /u01/arch/1_17_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 18, /u01/arch/1_18_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 18, /u01/arch/1_18_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 19, /u01/arch/1_19_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 19, /u01/arch/1_19_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 20, /u01/arch/1_20_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 20, /u01/arch/1_20_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 21, /u01/arch/1_21_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 21, /u01/arch/1_21_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 22, /u01/arch/1_22_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 22, /u01/arch/1_22_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 23, /u01/arch/1_23_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 23, /u01/arch/1_23_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 24, /u01/arch/1_24_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 24, /u01/arch/1_24_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 25, /u01/arch/1_25_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 25, /u01/arch/1_25_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 26, /u01/arch/1_26_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 26, /u01/arch/1_26_771076032.dbf

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 27, /u01/arch/1_27_771076032.dbf

LOGMINER: End mining logfile for session 1 thread 1 sequence 27, /u01/arch/1_27_771076032.dbf

–对之前注册的日志,开完挖掘,并传播




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

only 1 comment untill now

  1. gallery@nations.misty” rel=”nofollow”>.…

    ñýíêñ çà èíôó!!…

Add your comment now

无觅相关文章插件