Executed on Primary dB "alter database stop logical standby apply"
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Executed on Primary dB "alter database stop logical standby apply"

Hybrid View

  1. #1
    Join Date
    Sep 2009
    Posts
    2

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    so whats the problem?

  3. #3
    Join Date
    Sep 2009
    Posts
    2
    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
  •  



Click Here to Expand Forum to Full Width