OracleStudy之–LogicalStandby日志应用错误案例

Oracle Study之–Logical Standby日志应用错误案例 系统环境： 操作系统：RedHat EL54 数据库： Oracle 11gR2 一、错误现象：（在逻辑备库应用日志时） LOGMINER:session#=1(Logical_Standby$),preparerMS02pid=34OSid=4241sid=37startedLOGSTDBYstatus:ORA-

Oracle Study之–Logical Standby日志应用错误案例

系统环境：

操作系统：RedHat EL54

数据库： Oracle 11gR2

一、错误现象：（在逻辑备库应用日志时）

LOGMINER: session#=1 (Logical_Standby$), preparer MS02 pid=34 OS id=4241 sid=37 startedLOGSTDBY status: ORA-00604: error occurred at recursive SQL level 1ORA-01658: unable to create INITIAL extent for segment in tablespace LOGMNRTBSORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1300ORA-06512: at line 1Errors in file /u01/app/oracle/diag/rdbms/bjdb/TestDB12/trace/TestDB12_lsp0_4228.trc:ORA-00604: error occurred at recursive SQL level 1ORA-01658: unable to create INITIAL extent for segment in tablespace LOGMNRTBSORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1300ORA-06512: at line 1LOGMINER: session#=1 (Logical_Standby$), reader MS00 pid=32 OS id=4237 sid=43 stoppedLOGMINER: session#=1 (Logical_Standby$), builder MS01 pid=33 OS id=4239 sid=41 stoppedLOGMINER: session#=1 (Logical_Standby$), preparer MS02 pid=34 OS id=4241 sid=37 stopped^[[AThu Mar 12 05:01:49 2015Starting background process SMCOThu Mar 12 05:01:49 2015SMCO started with pid=31, OS id=4260查看logmnr应用：SYS@ TestDB12>select * from v$logstdby_stats;no rows selectedlogmnr没有任何动作。

二、分析问题原因

1、查看trace文件

oracle@bjsrv:/home/oracle> more /u01/app/oracle/diag/rdbms/bjdb/TestDB12/trace/TestDB12_lsp0_4228.trc

Trace file /u01/app/oracle/diag/rdbms/bjdb/TestDB12/trace/TestDB12_lsp0_4228.trcOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing optionsORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1System name:    LinuxNode name:      bjsrvRelease:        2.6.18-194.el5Version:        #1 SMP Tue Mar 16 21:52:39 EDT 2010Machine:        x86_64Instance name: TestDB12Redo thread mounted by this instance: 1Oracle process number: 31Unix process pid: 4228, image: oracle@bjsrv (LSP0)*** 2015-03-12 04:58:11.426*** SESSION ID:(38.1) 2015-03-12 04:58:11.426*** CLIENT ID:() 2015-03-12 04:58:11.426*** SERVICE NAME:(SYS$BACKGROUND) 2015-03-12 04:58:11.426*** MODULE NAME:() 2015-03-12 04:58:11.426*** ACTION NAME:() 2015-03-12 04:58:11.426 knahcapplymain: encountered error=604*** 2015-03-12 04:58:11.426dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)----- Error Stack Dump -----ORA-00604: error occurred at recursive SQL level 1ORA-01658: unable to create INITIAL extent for segment in tablespace LOGMNRTBSORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1300ORA-06512: at line 1KNACDMP: *******************************************************KNACDMP: Dumping apply coordinator's context at 830931c0KNACDMP: Apply Engine # 0KNACDMP: Apply Engine name KNACDMP: Coordinator's Watermarks ------------------------------KNACDMP: Apply High Watermark            = 00000014572d (SCN=0x0000.0014572d)KNACDMP: Apply Low Watermark             = 00000014572d (SCN=0x0000.0014572d)KNACDMP: Recovery Low Watermark          =  (SCN=0x0000.00000000)KNACDMP: Fetch Low Watermark             =  (SCN=0x0000.00000000)KNACDMP: Fetch Low Watermark Time        = 0KNACDMP: Oldest SCN                      =  (SCN=0x0000.00000000)KNACDMP: Oldest XID                      = KNACDMP: Oldest Create Time              = 0KNACDMP: Last replicant syncpoint SCN    = 0x0000.00000000KNACDMP: Last syncpoint at primary  SCN  = 0x0000.00000000KNACDMP: First partition max pos         =  (SCN=0x0000.00000000)KNACDMP: Last  partition max pos         =  (SCN=0x0000.00000000)KNACDMP: Last  processed                 = 00000014572e (SCN=0x0000.0014572e)KNACDMP: Conservative pos                =  (SCN=0x0000.00000000)KNACDMP: Recovery start pos              =  (SCN=0x0000.00000000)KNACDMP: Recovery high watermark         =  (SCN=0x0000.00000000)KNACDMP: Spill LWM                       =  (SCN=0x0000.00000000)KNACDMP: Spill LWM Create Time           = 0KNACDMP: Coordinator's constants -------------------------------KNACDMP: number of apply slaves          = 5KNACDMP: min number of apply slaves          = 5KNACDMP: max number of apply slaves          = 5KNACDMP: safety level (K)                = 1KNACDMP: max txns in memory              = 400KNACDMP: max constraints per table       = 620KNACDMP: hash table size (in entries)    = 10000000KNACDMP: Coordinator's intervals -------------------------------KNACDMP: syncpoint interval (ms)         = 0KNACDMP: write low watermark interval(ms)= 1KNACDMP: Coordinator's timers/counters -------------------------KNACDMP: current time                    = 1426150690KNACDMP: low watermark timer             = 0KNACDMP: syncpoint timer                 = 0KNACDMP: txnbufsize timer                = 0KNACDMP: Coordinator's txn counts -------------------------KNACDMP: total txns applied              = 0KNACDMP: number of unassigned comp txns  =<p style="color:transparent">本文来源gao!%daima.com搞$代*!码网1</p> 0KNACDMP: number of unassigned incomp txns= 0KNACDMP: avg number of unassigned txns   = 0.00KNACDMP: total applied at last plwm write= 0KNACDMP: apply prog. entries below plwm  = 0KNACDMP: total unassigned lcrs           = 0KNACDMP: Coordinator's State/Flags -----------------------------KNACDMP: Coordinator's State             = KNACST_APPLY_UNTIL_ENDKNACDMP: Coordinator's Flags             = 0x8000KNACDMP: Slave counts ------------------------------------------KNACDMP: number of reserved slaves       = 1KNACDMP: number of admin slaves          = 0KNACDMP: number of slaves in wait cmt    = 0KNACDMP: number of slaves suspended      = 0KNACDMP: number of safe slaves           = 0KNACDMP: avg number of idle slaves       = 0.00KNACDMP: number of slaves initializing   = 0KNACDMP: number of slaves terminating    = 0KNACDMP: Slave Lists -------------------------------------------KNACDMP: Dumping All Slaves :-Slave id = 0, State = 8, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 1, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 2, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 3, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 4, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 5, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsKNACDMP: End dumping all slavesKNACDMP: syncdep slaves = { }KNACDMP: cont chunk slaves = { }KNACDMP: cont slaves = { }KNACDMP: exec txn slaves = { }KNACDMP: Active slaves (0) = { }KNACDMP: Idle slaves (5) = { 1 2 3 4 5 }KNACDMP: Txn Lists ---------------------------------------------KNACDMP: Dumping all txns :-KNACDMP: End dumping all txns.KNACDMP: Complete txns = { ** NO UNASS ** }KNACDMP: Unassigned txns = { }KNACDMP: *******************************************************Warning:  Apply error received:  ORA-26714: User Error  encountered during apply process.  Clearing.*** 2015-03-12 04:58:11.994knahcapplymain: encountered error=604*** 2015-03-12 04:58:11.994dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)----- Error Stack Dump -----ORA-00604: error occurred at recursive SQL level 1ORA-01658: unable to create INITIAL extent for segment in tablespace LOGMNRTBSORA-06512: at "SYS.LOGMNR_KRVRDLUID3", line 1300ORA-06512: at line 1KNACDMP: *******************************************************KNACDMP: Dumping apply coordinator's context at 830931c0KNACDMP: Apply Engine # 0KNACDMP: Apply Engine name KNACDMP: Coordinator's Watermarks ------------------------------KNACDMP: Apply High Watermark            = 00000014572d (SCN=0x0000.0014572d)KNACDMP: Apply Low Watermark             = 00000014572d (SCN=0x0000.0014572d)KNACDMP: Recovery Low Watermark          =  (SCN=0x0000.00000000)KNACDMP: Fetch Low Watermark             =  (SCN=0x0000.00000000)KNACDMP: Fetch Low Watermark Time        = 0KNACDMP: Oldest SCN                      =  (SCN=0x0000.00000000)KNACDMP: Oldest XID                      = KNACDMP: Oldest Create Time              = 0KNACDMP: Last replicant syncpoint SCN    = 0x0000.00000000KNACDMP: Last syncpoint at primary  SCN  = 0x0000.00000000KNACDMP: First partition max pos         =  (SCN=0x0000.00000000)KNACDMP: Last  partition max pos         =  (SCN=0x0000.00000000)KNACDMP: Last  processed                 = 00000014572e (SCN=0x0000.0014572e)KNACDMP: Conservative pos                =  (SCN=0x0000.00000000)KNACDMP: Recovery start pos              =  (SCN=0x0000.00000000)KNACDMP: Recovery high watermark         =  (SCN=0x0000.00000000)KNACDMP: Spill LWM                       =  (SCN=0x0000.00000000)KNACDMP: Spill LWM Create Time           = 0KNACDMP: Coordinator's constants -------------------------------KNACDMP: number of apply slaves          = 5KNACDMP: min number of apply slaves          = 5KNACDMP: max number of apply slaves          = 5KNACDMP: safety level (K)                = 1KNACDMP: max txns in memory              = 400KNACDMP: max constraints per table       = 620KNACDMP: hash table size (in entries)    = 10000000KNACDMP: Coordinator's intervals -------------------------------KNACDMP: syncpoint interval (ms)         = 0KNACDMP: write low watermark interval(ms)= 1KNACDMP: Coordinator's timers/counters -------------------------KNACDMP: current time                    = 1426150691KNACDMP: low watermark timer             = 0KNACDMP: syncpoint timer                 = 0KNACDMP: txnbufsize timer                = 0KNACDMP: Coordinator's txn counts -------------------------KNACDMP: total txns applied              = 0KNACDMP: number of unassigned comp txns  = 0KNACDMP: number of unassigned incomp txns= 0KNACDMP: avg number of unassigned txns   = 0.00KNACDMP: total applied at last plwm write= 0KNACDMP: apply prog. entries below plwm  = 0KNACDMP: total unassigned lcrs           = 0KNACDMP: Coordinator's State/Flags -----------------------------KNACDMP: Coordinator's State             = KNACST_APPLY_UNTIL_ENDKNACDMP: Coordinator's Flags             = 0x8200KNACDMP: Slave counts ------------------------------------------KNACDMP: number of reserved slaves       = 1KNACDMP: number of admin slaves          = 0KNACDMP: number of slaves in wait cmt    = 0KNACDMP: number of slaves suspended      = 0KNACDMP: number of safe slaves           = 0KNACDMP: avg number of idle slaves       = 0.00KNACDMP: number of slaves initializing   = 0KNACDMP: number of slaves terminating    = 0KNACDMP: Slave Lists -------------------------------------------KNACDMP: Dumping All Slaves :-Slave id = 0, State = 8, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 1, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 2, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 3, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 4, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsSlave id = 5, State = 0, Flags = 0, Not Assigned 0 txns  0 lcrsKNACDMP: End dumping all slavesKNACDMP: syncdep slaves = { }KNACDMP: cont chunk slaves = { }KNACDMP: cont slaves = { }KNACDMP: exec txn slaves = { }KNACDMP: Active slaves (0) = { }KNACDMP: Idle slaves (5) = { 1 2 3 4 5 }KNACDMP: Txn Lists ---------------------------------------------KNACDMP: Dumping all txns :-KNACDMP: End dumping all txns.KNACDMP: Complete txns = { ** NO UNASS ** }KNACDMP: Unassigned txns = { }KNACDMP: *******************************************************Warning:  Apply error received:  ORA-26714: User Error  encountered during apply process.  Clearing.oracle@bjsrv:/home/oracle>

喜欢 (0)赏

[搞代码]

分享 (0)