exec DBMS_CAPTURE_ADM.BUILD();

Thu Dec 29 13:19:00 2011

ALTER SYSTEM ARCHIVE LOG

Thu Dec 29 13:19:00 2011

Thread 1 advanced to log sequence 9 (LGWR switch)

Current log# 3 seq# 9 mem# 0: /u01/app/oracle/oradata/outer/redo03.log

Thu Dec 29 13:21:38 2011

Archived Log entry 6 added for thread 1 sequence 8 ID 0×24456dbc dest 1:

Archived Log entry 7 added for thread 1 sequence 8 ID 0×24456dbc dest 2:

knlciWaitForInflightTxns: wait for inflight txns at this scn:

scn: 0×0000.0010c997

[1100183]

knlciWaitForInflightTxns: Done with waiting for inflight txns at this scn:

scn: 0×0000.0010c997

[1100183]

Thu Dec 29 13:21:38 2011

Logminer Bld: Build started

ALTER SYSTEM SWITCH ALL LOGFILE start (outer)

ALTER SYSTEM SWITCH ALL LOGFILE complete (outer)

Thu Dec 29 13:21:39 2011

Thread 1 advanced to log sequence 10 (LGWR switch)

Current log# 1 seq# 10 mem# 0: /u01/app/oracle/oradata/outer/redo01.log

Thu Dec 29 13:21:39 2011

Logminer Bld: Lockdown Complete. DB_TXN_SCN is 0 1100188 LockdownSCN is 1100188

Thu Dec 29 13:21:39 2011

Archived Log entry 8 added for thread 1 sequence 9 ID 0×24456dbc dest 1:

Archived Log entry 9 added for thread 1 sequence 9 ID 0×24456dbc dest 2:

ALTER SYSTEM ARCHIVE LOG

Thread 1 cannot allocate new log, sequence 11

Checkpoint not complete

Current log# 1 seq# 10 mem# 0: /u01/app/oracle/oradata/outer/redo01.log

Thread 1 advanced to log sequence 11 (LGWR switch)

Current log# 2 seq# 11 mem# 0: /u01/app/oracle/oradata/outer/redo02.log

Thu Dec 29 13:22:43 2011

Archived Log entry 10 added for thread 1 sequence 10 ID 0×24456dbc dest 1:

Archived Log entry 11 added for thread 1 sequence 10 ID 0×24456dbc dest 2:

Thu Dec 29 13:22:43 2011

Logminer Bld: Done

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

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

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

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

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

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

Thu Dec 29 16:08:01 2011

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

Thu Dec 29 16:10:37 2011

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

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

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

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

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

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

Thu Dec 29 16:10:40 2011

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: 1100936 (0×0000.0010cc88)

LOGMINER: EndScn: 0

LOGMINER: HighConsumedScn: 1100188 (0×0000.0010c99c)

LOGMINER: session_flag 0×0

LOGMINER: LowCkptScn: 0 (0×0000.00000000)

LOGMINER: HighCkptScn: 0 (0×0000.00000000)

LOGMINER: SkipScn: 1100188 (0×0000.0010c99c)

Thu Dec 29 16:10:41 2011

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

Thu Dec 29 16:10:41 2011

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

Thu Dec 29 16:10:41 2011

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

LOGMINER: Begin mining logfile during dictionary load for session 1 thread 1 sequence 10, /u01/arch/1_10_771076032.dbf

Thu Dec 29 16:10:52 2011

Thread 1 advanced to log sequence 6 (LGWR switch)

Current log# 3 seq# 6 mem# 0: /u01/app/oracle/oradata/mid/redo03.log

Thread 1 advanced to log sequence 7 (LGWR switch)

Current log# 1 seq# 7 mem# 0: /u01/app/oracle/oradata/mid/redo01.log

Thu Dec 29 16:11:00 2011

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_TAB$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_TS$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_OBJ$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_IND$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_ICOL$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_COL$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_USER$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_CDEF$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_CCOL$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_LOB$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_PROPS$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_ENC$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_COLTYPE$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_SUBCOLTYPE$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_ATTRCOL$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_TYPE$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_ATTRIBUTE$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_NTAB$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_REFCON$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_OPQTYPE$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_KOPM$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_PARTOBJ$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_TABPART$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_INDPART$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_TABSUBPART$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_INDSUBPART$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_TABCOMPART$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_INDCOMPART$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_LOBFRAG$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_LOGMNR_BUILDLOG have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_SEED$ have been marked unusable

Some indexes or index [sub]partitions of table SYSTEM.LOGMNR_DICTIONARY$ have been marked unusable

Indexes of table SYSTEM.LOGMNR_ATTRCOL$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_ATTRIBUTE$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_CCOL$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_CDEF$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_COL$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_COLTYPE$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_DICTIONARY$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_ENC$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_ICOL$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_IND$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_INDCOMPART$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_INDPART$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_INDSUBPART$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_KOPM$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_LOB$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_LOBFRAG$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_LOGMNR_BUILDLOG have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_NTAB$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_OBJ$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_OPQTYPE$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_PARTOBJ$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_PROPS$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_REFCON$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_SEED$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_SUBCOLTYPE$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_TAB$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_TABCOMPART$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_TABPART$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_TABSUBPART$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_TS$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_TYPE$ have been rebuilt and are now usable

Indexes of table SYSTEM.LOGMNR_USER$ have been rebuilt and are now usable

Thu Dec 29 16:11:19 2011

LOGMINER: End mining logfiles during dictionary load for session 1

Thu Dec 29 16:11:23 2011

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

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

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

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




Related posts

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

no comment untill now

Add your comment now

无觅相关文章插件