-
Executed on Primary dB "alter database stop logical standby apply"
I dont have any errors in DBA_LOGSTDBY_EVENTS.
v$logstdby_stats shows no job in Q and waiting nnnn seconds.
v$logstdby_process dosen't show movement in SCN.
trace file is as below:
/oradb/BANCSMIS/admin/BANCSMIS/bdump/bancsmis_p001_19522.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oradb/BANCSMIS/10.2
System name: SunOS
Node name: bancsmis
Release: 5.10
Version: Generic_138888-01
Machine: sun4u
Instance name: BANCSMIS
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 19522, image: oracle@bancsmis (P001)
*** SERVICE NAME:(SYS$BACKGROUND) 2009-09-06 17:38:43.828
*** SESSION ID:(1631.5) 2009-09-06 17:38:43.828
Cannot resolve kxidsqn for lcr:
++ LCR Dump Begin: 0x3d0eb5fb0
op: 7 : Original op: 7 : baseobjn: 0, objn: 0, objv: 0
DFlag: 0x02, MFlag: 0x200000, PFlag: 0x00
iotPrimaryKeyCount: 0x0, MergeFlag: 0x3
FilterFlag: 0x00
Id: 0 numChgRec = 0
NumCrSpilled: 0
RedoThread# = 1, rba: 0x002521.00006dff.0010
scn: 0x0000.3d9cd904
xid: 0x0002.024.ffffffff parent xid: 0x0002.024.ffffffff
newcount = 0, oldcount = 0
LUBA: 0x0.0.0.0.0
Cannot resolve kxidsqn for lcr:
++ LCR Dump Begin: 0x3d05d8760
op: 7 : Original op: 7 : baseobjn: 0, objn: 0, objv: 0
DFlag: 0x02, MFlag: 0x200000, PFlag: 0x00
iotPrimaryKeyCount: 0x0, MergeFlag: 0x3
FilterFlag: 0x00
Id: 0 numChgRec = 0
NumCrSpilled: 0
RedoThread# = 1, rba: 0x002521.00008c6a.0010
scn: 0x0000.3d9cde12
xid: 0x0004.00c.ffffffff parent xid: 0x0004.00c.ffffffff
newcount = 0, oldcount = 0
LUBA: 0x0.0.0.0.0
Cannot resolve kxidsqn for lcr:
++ LCR Dump Begin: 0x3d05b3b00
op: 7 : Original op: 7 : baseobjn: 0, objn: 0, objv: 0
DFlag: 0x02, MFlag: 0x200000, PFlag: 0x00
iotPrimaryKeyCount: 0x0, MergeFlag: 0x3
FilterFlag: 0x00
Id: 0 numChgRec = 0
NumCrSpilled: 0
RedoThread# = 1, rba: 0x002521.00008f76.0010
scn: 0x0000.3d9cde99
xid: 0x0008.00a.ffffffff parent xid: 0x0008.00a.ffffffff
newcount = 0, oldcount = 0
LUBA: 0x0.0.0.0.0
Cannot resolve kxidsqn for lcr:
++ LCR Dump Begin: 0x3d0541ad8
op: 7 : Original op: 7 : baseobjn: 0, objn: 0, objv: 0
DFlag: 0x02, MFlag: 0x200000, PFlag: 0x00
iotPrimaryKeyCount: 0x0, MergeFlag: 0x3
FilterFlag: 0x00
Id: 0 numChgRec = 0
NumCrSpilled: 0
RedoThread# = 1, rba: 0x002521.000095c4.0010
scn: 0x0000.3d9cdfe6
xid: 0x0006.00f.ffffffff parent xid: 0x0006.00f.ffffffff
newcount = 0, oldcount = 0
LUBA: 0x0.0.0.0.0
Cannot resolve kxidsqn for lcr:
++ LCR Dump Begin: 0x3d0186910
op: 7 : Original op: 7 : baseobjn: 0, objn: 0, objv: 0
DFlag: 0x02, MFlag: 0x200000, PFlag: 0x00
iotPrimaryKeyCount: 0x0, MergeFlag: 0x3
FilterFlag: 0x00
Id: 0 numChgRec = 0
NumCrSpilled: 0
RedoThread# = 1, rba: 0x002521.0000ca22.0010
scn: 0x0000.3d9ce8df
xid: 0x0005.017.ffffffff parent xid: 0x0005.017.ffffffff
newcount = 0, oldcount = 0
LUBA: 0x0.0.0.0.0
Cannot resolve kxidsqn for lcr:
Alert log as below:
LOGSTDBY Apply process P006 pid=28 OS id=19532 stopped
Sun Sep 6 19:03:56 2009
LOGSTDBY status: ORA-16128: User initiated stop apply successfully completed
Sun Sep 6 19:03:56 2009
Completed: alter database stop logical standby apply
Sun Sep 6 19:04:51 2009
alter database start logical standby apply skip failed transaction
Sun Sep 6 19:04:51 2009
ALTER DATABASE START LOGICAL STANDBY APPLY (BANCSMIS)
Sun Sep 6 19:04:51 2009
with optional part
TRY TO SKIP FAILED TRANSACTION
ORA-16220 signalled during: alter database start logical standby apply skip failed transaction...
Sun Sep 6 19:05:10 2009
alter database start logical standby apply immediate
Sun Sep 6 19:05:10 2009
ALTER DATABASE START LOGICAL STANDBY APPLY (BANCSMIS)
Sun Sep 6 19:05:10 2009
with optional part
IMMEDIATE
Attempt to start background Logical Standby process
LOGSTDBY Parameter: DISABLE_APPLY_DELAY =
LOGSTDBY Parameter: REAL_TIME =
LSP0 started with pid=21, OS id=23899
Sun Sep 6 19:05:11 2009
Completed: alter database start logical standby apply immediate
Sun Sep 6 19:05:12 2009
LOGSTDBY status: ORA-16111: log mining and apply setting up
Sun Sep 6 19:05:12 2009
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 3, Transaction Chunk Size = 201
LOGMINER: Memory Size = 30M, Checkpoint interval = 150M
LOGMINER: session# = 1, builder process P001 started with pid=23 OS id=19522
LOGMINER: session# = 1, reader process P000 started with pid=22 OS id=19520
LOGMINER: session# = 1, preparer process P002 started with pid=24 OS id=19524
Sun Sep 6 19:05:13 2009
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 9505, /oradb/BANCSMIS/archive/1_9505_671306117.arc
Sun Sep 6 19:05:13 2009
LOGMINER: Turning ON Log Auto Delete
LOGSTDBY Analyzer process P003 started with pid=25 OS id=19526
LOGSTDBY Apply process P005 started with pid=27 OS id=19530
LOGSTDBY Apply process P007 started with pid=29 OS id=19534
LOGSTDBY Apply process P006 started with pid=28 OS id=19532
LOGSTDBY Apply process P004 started with pid=26 OS id=19528
LOGSTDBY Apply process P008 started with pid=30 OS id=19536
Sun Sep 6 19:06:54 2009
Thread 1 advanced to log sequence 423 (LGWR switch)
Current log# 3 seq# 423 mem# 0: /oradb/BANCSMIS/redo/redo03.log
Sun Sep 6 19:07:39 2009
LOGMINER: End mining logfile: /oradb/BANCSMIS/archive/1_9505_671306117.arc
Sun Sep 6 19:07:39 2009
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 9506, /oradb/BANCSMIS/archive/1_9506_671306117.arc
Sun Sep 6 19:08:25 2009
Thread 1 advanced to log sequence 424 (LGWR switch)
Current log# 1 seq# 424 mem# 0: /oradb/BANCSMIS/redo/redo01.log
Sun Sep 6 19:09:53 2009
Thread 1 advanced to log sequence 425 (LGWR switch)
Current log# 2 seq# 425 mem# 0: /oradb/BANCSMIS/redo/redo02.log
Sun Sep 6 19:10:08 2009
LOGMINER: End mining logfile: /oradb/BANCSMIS/archive/1_9506_671306117.arc
Sun Sep 6 19:10:08 2009
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 9507, /oradb/BANCSMIS/archive/1_9507_671306117.arc
Sun Sep 6 19:11:29 2009
Thread 1 advanced to log sequence 426 (LGWR switch)
Current log# 3 seq# 426 mem# 0: /oradb/BANCSMIS/redo/redo03.log
Sun Sep 6 19:13:04 2009
-
-
1) DBA_LOGSTDBY_LOG dosent show movement in applied column,the current SCN dosent change for last 1 day.
2)v$logstdby_progress dosen't show movement in SCN.
3) all redo logs (from the primary) are getting accumulated.
4) Tried skipping transaction ... Msg ...no error to skip.
Tried starting .... logical standdby apply immediate.
THEN why no movement in SCN.
trace files shows ...
Cannot resolve kxidsqn for lcr:
THE TIMING "17:38" corresponds to the time when this command was executed on the primary(assuming it to be STDB...already aware of the mess...no wise comments please) "ALTER DATABASE stop logical standby apply"
TRACE FILE:
--------------
/oradb/BANCSMIS/admin/BANCSMIS/bdump/bancsmis_p001_19522.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oradb/BANCSMIS/10.2
System name: SunOS
Node name: bancsmis
Release: 5.10
Version: Generic_138888-01
Machine: sun4u
Instance name: BANCSMIS
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 19522, image: oracle@bancsmis (P001)
*** SERVICE NAME:(SYS$BACKGROUND) 2009-09-06 17:38:43.828
*** SESSION ID:(1631.5) 2009-09-06 17:38:43.828
Cannot resolve kxidsqn for lcr:
++ LCR Dump Begin: 0x3d0eb5fb0
op: 7 : Original op: 7 : baseobjn: 0
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
|