downstream库日志

Fri Dec 30 14:07:58 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_32_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_32_771076032.dbf’ for ‘hr_cap_stream’

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

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

Fri Dec 30 14:07:58 2011

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

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

Errors in file /u01/app/oracle/diag/rdbms/mid/mid/trace/mid_ms00_18744.trc (incident=3817):

ORA-00353: log corruption near block 2200 change 1150502 time 12/30/2011 14:00:22

ORA-00334: archived log: ‘/u01/arch/1_31_771076032.dbf’

Incident details in: /u01/app/oracle/diag/rdbms/mid/mid/incident/incdir_3817/mid_ms00_18744_i3817.trc

LOGMINER: WARNING: error 354 encountered, failed to read corrupt logfile /u01/arch/1_31_771076032.dbf

Errors in file /u01/app/oracle/diag/rdbms/mid/mid/trace/mid_ms00_18744.trc:

ORA-00354: corrupt redo log block header

ORA-00353: log corruption near block 2200 change 1150502 time 12/30/2011 14:00:22

ORA-00334: archived log: ‘/u01/arch/1_31_771076032.dbf’

Fri Dec 30 14:08:02 2011

Sweep [inc][3817]: completed

Fri Dec 30 14:08:02 2011

Dumping diagnostic data in directory=[cdmp_20111230140802], requested by (instance=1, osid=18744 (MS00)), summary=[incident=3817].

发现注册的日志是坏的

ORA-00353: log corruption near block 2200 change 1150502 time 12/30/2011 14:00:22

ORA-00334: archived log: ‘/u01/arch/1_31_771076032.dbf’

然后后续的日志可以继续注册,但是却不会挖掘

Fri Dec 30 14:08:04 2011

Sweep [inc2][3817]: completed

Fri Dec 30 14:08:09 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_33_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_33_771076032.dbf’ for ‘hr_cap_stream’

Fri Dec 30 14:09:32 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_34_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_34_771076032.dbf’ for ‘hr_cap_stream’

Fri Dec 30 14:11:58 2011

ALTER DATABASE REGISTER LOGICAL LOGFILE ‘/u01/arch/1_35_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_35_771076032.dbf’ for ‘hr_cap_stream’

这个时候通过

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

是无法注册成功的,因为在系统中已经存在’/u01/arch/1_31_771076032.dbf’这个日志

所以需要通过

ALTER DATABASE REGISTER or replace LOGICAL LOGFILE ‘/u01/arch/1_31_771076032.dbf’ for ‘hr_cap_stream’

来注册。

继续观察日志

Fri Dec 30 14:30:03 2011

ALTER DATABASE REGISTER or replace LOGICAL LOGFILE ‘/u01/arch/1_31_771076032.dbf’ for ‘hr_cap_stream’

There are 1 logfiles specified.

ALTER DATABASE REGISTER [LOGICAL] LOGFILE

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

Fri Dec 30 14:30:03 2011

LOGMINER: corrupt file /u01/arch/1_31_771076032.dbf recovered. Reader waiting for apply to finish

krvxerpt: Errors detected in process 27, role reader.

krvxmrs: Leaving by exception: 1375

Errors in file /u01/app/oracle/diag/rdbms/mid/mid/trace/mid_ms00_18744.trc:

ORA-01375: Corrupt logfile /u01/arch/1_31_771076032.dbf recovered

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

Errors in file /u01/app/oracle/diag/rdbms/mid/mid/trace/mid_ms00_18744.trc:

ORA-01375: Corrupt logfile /u01/arch/1_31_771076032.dbf recovered

Fri Dec 30 14:30:06 2011

LogMiner process death detected

Fri Dec 30 14:30:06 2011

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

Fri Dec 30 14:30:06 2011

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

Fri Dec 30 14:30:18 2011

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

Errors in file /u01/app/oracle/diag/rdbms/mid/mid/trace/mid_cp01_18079.trc:

ORA-01280: Fatal LogMiner Error.

虽然日志被修复了,但是logMiner进程死了,于是手动启动挖掘进程

又开始挖掘

Fri Dec 30 15:11:23 2011

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

Fri Dec 30 15:11:23 2011

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

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

Streams CAPTURE CP01 for HR_CAP_STREAM with pid=25, OS id=11265 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: 1151723 (0×0000.001192eb)

LOGMINER: EndScn: 0

LOGMINER: HighConsumedScn: 1151723 (0×0000.001192eb)

LOGMINER: session_flag 0×0

LOGMINER: LowCkptScn: 1149807 (0×0000.00118b6f)

LOGMINER: HighCkptScn: 1149808 (0×0000.00118b70)

LOGMINER: SkipScn: 1149807 (0×0000.00118b6f)

Fri Dec 30 15:11:28 2011

LOGMINER: session#=1 (HR_CAP_STREAM), reader MS00 pid=31 OS id=11689 sid=43 started

Fri Dec 30 15:11:28 2011

LOGMINER: session#=1 (HR_CAP_STREAM), builder MS01 pid=33 OS id=11691 sid=33 started

Fri Dec 30 15:11:28 2011

LOGMINER: session#=1 (HR_CAP_STREAM), preparer MS02 pid=34 OS id=11693 sid=32 started

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

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

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

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

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

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

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

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

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

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

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

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




Related posts

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

no comment untill now

Add your comment now

无觅相关文章插件