|
-
nope, didn't find any ORA-26040's
************************************************
Dump file d:\LSTDBY1\bdump\LSTDBY12_lsp0_1352.trc
Thu Jan 21 22:59:15 2010
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:5970M/8089M, Ph+PgF:4473M/9694M
Instance name: LSTDBY12
Redo thread mounted by this instance: 2
Oracle process number: 63
Windows thread id: 1352, image: ORACLE.EXE (LSP0)
*** 2010-01-21 22:59:17.062
*** SERVICE NAME:(SYS$BACKGROUND) 2010-01-21 22:59:14.265
*** SESSION ID:(262.2) 2010-01-21 22:59:14.265
knahcapplymain: encountered error=12801
*** 2010-01-21 22:59:17.562
ksedmp: internal or fatal error
ORA-12801: error signaled in parallel query server P001, instance RAC6:LSTDBY12 (2)
ORA-01578: ORACLE data block corrupted (file # 3, block # 78089)
ORA-01110: data file 3: 'D:\LSTDBY1\SYSAUX01.DBF'
KNACDMP: *******************************************************
KNACDMP: Dumping apply coordinator's context at 3198d720
KNACDMP: Apply Engine # 0
KNACDMP: Apply Engine name
KNACDMP: Coordinator's Watermarks ------------------------------
KNACDMP: Apply High Watermark = 0x0000.01bc5d25
KNACDMP: Apply Low Watermark = 0x0000.01bc5d25
KNACDMP: Recovery Low Watermark = 0x0000.01bc5d25
KNACDMP: Fetch Low Watermark = 0x0000.01bc5df5
KNACDMP: Fetch Low Watermark Time = 708851746
KNACDMP: Oldest SCN = 0x0000.00000000
KNACDMP: Oldest XID = 0x0000.000.00000000
KNACDMP: Last replicant syncpoint SCN = 0x0000.028ff6d6
KNACDMP: Last syncpoint at primary SCN = 0x0000.01bc5d25
KNACDMP: First partition max SCN = 0x0000.01bc5dde
KNACDMP: Last partition max SCN = 0x0000.01bde47e
KNACDMP: Last processed SCN = 0x0000.01bc5df5
KNACDMP: Conservative SCN = 0x0000.01bc5df5
KNACDMP: Recovery start SCN = 0x0000.00000000
KNACDMP: Recovery high watermark = 0x0000.01bc5d25
KNACDMP: Coordinator's constants -------------------------------
KNACDMP: number of apply slaves = 5
KNACDMP: safety level (K) = 1
KNACDMP: max txns in memory = 400
KNACDMP: max constraints per table = 246
KNACDMP: hash table size (in entries) = 1000000
KNACDMP: Coordinator's intervals -------------------------------
KNACDMP: syncpoint interval (ms) = 0
KNACDMP: write low watermark interval(ms)= 1
KNACDMP: Coordinator's timers/counters -------------------------
KNACDMP: current time = 1264085960
KNACDMP: low watermark timer = 0
KNACDMP: syncpoint timer = 1264085953
KNACDMP: Coordinator's txn counts -------------------------
KNACDMP: total txns applied = 0
KNACDMP: total applied at last plwm write= 0
KNACDMP: apply prog. entries below plwm = 0
KNACDMP: Coordinator's State/Flags -----------------------------
KNACDMP: Coordinator's State = KNACST_APPLY_UNTIL_END
KNACDMP: Coordinator's Flags = 0x4
KNACDMP: Slave counts ------------------------------------------
KNACDMP: number of reserved slaves = 1
KNACDMP: number of admin slaves = 0
KNACDMP: number of slaves in wait cmt = 0
KNACDMP: number of slaves suspended = 0
KNACDMP: number of safe slaves = 0
KNACDMP: Slave Lists -------------------------------------------
KNACDMP: Dumping All Slaves :-
Slave id = 0, State = 8, Flags = 0, Not Assigned
Slave id = 1, State = 0, Flags = 0, Not Assigned
Slave id = 2, State = 0, Flags = 0, Not Assigned
Slave id = 3, State = 0, Flags = 0, Not Assigned
Slave id = 4, State = 0, Flags = 0, Not Assigned
Slave id = 5, State = 0, Flags = 0, Not Assigned
KNACDMP: End dumping all slaves
KNACDMP: syncdep slaves = { }
KNACDMP: cont chunk slaves = { }
KNACDMP: cont slaves = { }
KNACDMP: exec txn slaves = { }
KNACDMP:Idle slaves (5) ={ 1 2 3 4 5 }
*** 2010-01-21 22:59:27.593
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 while applying. Clearing.
*** 2010-01-21 23:00:10.859
knahcapplymain: encountered error=12801
*** 2010-01-21 23:00:11.031
ksedmp: internal or fatal error
ORA-12801: error signaled in parallel query server P001, instance RAC6:LSTDBY12 (2)
ORA-01578: ORACLE data block corrupted (file # 3, block # 78089)
ORA-01110: data file 3: 'D:\LSTDBY1\SYSAUX01.DBF'
KNACDMP: *******************************************************
KNACDMP: Dumping apply coordinator's context at 3198d720
KNACDMP: Apply Engine # 0
KNACDMP: Apply Engine name
KNACDMP: Coordinator's Watermarks ------------------------------
KNACDMP: Apply High Watermark = 0x0000.01bc5d25
KNACDMP: Apply Low Watermark = 0x0000.01bc5d25
KNACDMP: Recovery Low Watermark = 0x0000.01bc5d25
KNACDMP: Fetch Low Watermark = 0x0000.01bc5d25
KNACDMP: Fetch Low Watermark Time = 708851746
KNACDMP: Oldest SCN = 0x0000.00000000
KNACDMP: Oldest XID = 0x0000.000.00000000
KNACDMP: Last replicant syncpoint SCN = 0x0000.028ff6d6
KNACDMP: Last syncpoint at primary SCN = 0x0000.01bc5d25
KNACDMP: First partition max SCN = 0x0000.01bc5dde
KNACDMP: Last partition max SCN = 0x0000.01bde47e
KNACDMP: Last processed SCN = 0x0000.01bc5df5
KNACDMP: Conservative SCN = 0x0000.01bc5df5
KNACDMP: Recovery start SCN = 0x0000.00000000
KNACDMP: Recovery high watermark = 0x0000.01bc5d25
KNACDMP: Coordinator's constants -------------------------------
KNACDMP: number of apply slaves = 5
KNACDMP: safety level (K) = 1
KNACDMP: max txns in memory = 400
KNACDMP: max constraints per table = 246
KNACDMP: hash table size (in entries) = 1000000
KNACDMP: Coordinator's intervals -------------------------------
KNACDMP: syncpoint interval (ms) = 0
KNACDMP: write low watermark interval(ms)= 1
KNACDMP: Coordinator's timers/counters -------------------------
KNACDMP: current time = 1264086010
KNACDMP: low watermark timer = 0
KNACDMP: syncpoint timer = 1264086010
KNACDMP: Coordinator's txn counts -------------------------
KNACDMP: total txns applied = 0
KNACDMP: total applied at last plwm write= 0
KNACDMP: apply prog. entries below plwm = 0
KNACDMP: Coordinator's State/Flags -----------------------------
KNACDMP: Coordinator's State = KNACST_APPLY_UNTIL_END
KNACDMP: Coordinator's Flags = 0x204
KNACDMP: Slave counts ------------------------------------------
KNACDMP: number of reserved slaves = 1
KNACDMP: number of admin slaves = 0
KNACDMP: number of slaves in wait cmt = 0
KNACDMP: number of slaves suspended = 0
KNACDMP: number of safe slaves = 0
KNACDMP: Slave Lists -------------------------------------------
KNACDMP: Dumping All Slaves :-
Slave id = 0, State = 8, Flags = 0, Not Assigned
Slave id = 1, State = 0, Flags = 0, Not Assigned
Slave id = 2, State = 0, Flags = 0, Not Assigned
Slave id = 3, State = 0, Flags = 0, Not Assigned
Slave id = 4, State = 0, Flags = 0, Not Assigned
Slave id = 5, State = 0, Flags = 0, Not Assigned
KNACDMP: End dumping all slaves
KNACDMP: syncdep slaves = { }
KNACDMP: cont chunk slaves = { }
KNACDMP: cont slaves = { }
KNACDMP: exec txn slaves = { }
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 while applying. Clearing.
************************************************
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|