Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    2

    Unanswered: Logical database startup problem

    Hello members,

    I am new to oracle dataguard and I had configured a logical stand by database for testing purpose.

    after successful implementation I am testing it on my test environment.

    Since two days I am facing very strange error.

    *LOGSTDBY stmt: REVOKE SYSDBA FROM my *username*
    *LOGSTDBY status: ORA-01031: insufficient privileges*
    *LOGSTDBY id: XID 0x0006.007.00000208, hSCN 0x0000.0015acc3, lSCN 0x0000.0015acc3, Thread 1, RBA 0x00b3.000040cb.10, txnCscn 0x0000.0015acc6, PID 5184, ORACLE.EXE (P004)*
    *LOGSTDBY Apply process P004 pid=26 OS id=5184 stopped*

    I did restart logical standby database, an than after I start logical standby at first attempt it starts without ay problem
    but after this error standby automatically get shutdown.

    My work environment.

    O/S: windows server 2003, sp2.
    oracle version 10.2.0.

    alert.log file contains:



    *LOGSTDBY Apply process P005 pid=29 OS id=460 stopped*
    *LOGSTDBY Apply process P006 pid=30 OS id=5448 stopped*
    *LOGSTDBY Apply process P007 pid=33 OS id=5992 stopped*
    *LOGSTDBY Apply process P008 pid=34 OS id=1164 stopped*
    *LOGSTDBY Analyzer process P003 pid=27 OS id=5468 stopped*
    *Sat Aug 25 11:17:04 2012*
    *LOGSTDBY status: ORA-16222: automatic Logical Standby retry of last action*
    *LOGSTDBY status: ORA-16111: log mining and apply setting up*
    *Sat Aug 25 11:17:04 2012*
    *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=25 OS id=5584*
    *LOGMINER: session# = 1, reader process P000 started with pid=24 OS id=5232*
    *LOGMINER: session# = 1, preparer process P002 started with pid=26 OS id=5924*
    *LOGSTDBY Analyzer process P003 started with pid=27 OS id=5468*
    *LOGSTDBY Apply process P007 started with pid=33 OS id=5992*
    *LOGSTDBY Apply process P005 started with pid=29 OS id=460*
    *LOGSTDBY Apply process P008 started with pid=34 OS id=1164*
    *LOGSTDBY Apply process P004 started with pid=28 OS id=5064*
    *LOGSTDBY Apply process P006 started with pid=30 OS id=5448*
    *Sat Aug 25 11:17:05 2012*
    *LOGMINER: Begin mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_178_791922278.ARC*
    *Sat Aug 25 11:17:05 2012*
    *LOGMINER: Turning ON Log Auto Delete*
    *Sat Aug 25 11:17:05 2012*
    *LOGMINER: End mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_178_791922278.ARC*
    *Sat Aug 25 11:17:05 2012*
    *LOGMINER: Begin mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_179_791922278.ARC*
    *Sat Aug 25 11:17:05 2012*
    *LOGSTDBY stmt: REVOKE SYSDBA FROM VS*
    *LOGSTDBY status: ORA-01031: insufficient privileges*
    *LOGSTDBY id: XID 0x0006.007.00000208, hSCN 0x0000.0015acc3, lSCN 0x0000.0015acc3, Thread 1, RBA 0x00b3.000040cb.10, txnCscn 0x0000.0015acc6, PID 5064, ORACLE.EXE (P004)*
    *LOGSTDBY Apply process P004 pid=28 OS id=5064 stopped*
    *Sat Aug 25 11:17:05 2012*
    *Errors in file d:\oracle\product\10.2.0\admin\stby\bdump\stby_lsp 0_2576.trc:*
    *ORA-12801: error signaled in parallel query server P004*
    *ORA-01031: insufficient privileges*

    *LOGSTDBY Apply process P006 pid=30 OS id=5448 stopped*
    *LOGSTDBY Apply process P005 pid=29 OS id=460 stopped*
    *LOGSTDBY Apply process P008 pid=34 OS id=1164 stopped*
    *LOGSTDBY Apply process P007 pid=33 OS id=5992 stopped*
    *LOGSTDBY Analyzer process P003 pid=27 OS id=5468 stopped*
    *Sat Aug 25 12:05:20 2012*
    *RFS[2]: Possible network disconnect with primary database*
    *Closing latent archivelog for thread 1 sequence 183*
    *EOF located at block 7520 low SCN 0:1489453 next SCN 0:1492554*
    *Latent archivelog 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY \ARCHIVELOG\STANDBYARCH_1_183_791922278.ARC'*
    *If you wish to failover to this standby database, you should use the*
    *following command to manually register the archivelog for recovery:*
    *ALTER DATABASE REGISTER LOGICAL LOGFILE 'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY \ARCHIVELOG\STANDBYARCH_1_183_791922278.ARC';*
    *Sat Aug 25 12:18:09 2012*
    *ALTER DATABASE START LOGICAL STANDBY APPLY*
    *Sat Aug 25 12:18:09 2012*
    *No optional part*
    *Attempt to start background Logical Standby process*
    *LSP0 started with pid=21, OS id=6020*
    *LOGSTDBY status: ORA-16111: log mining and apply setting up*
    *Sat Aug 25 12:18:09 2012*
    *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=5464*
    *LOGMINER: session# = 1, preparer process P002 started with pid=24 OS id=3428*
    *LOGMINER: session# = 1, reader process P000 started with pid=22 OS id=3204*
    *Sat Aug 25 12:18:09 2012*
    *LOGMINER: Begin mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_178_791922278.ARC*
    *Sat Aug 25 12:18:09 2012*
    *LOGMINER: Turning ON Log Auto Delete*
    *Sat Aug 25 12:18:09 2012*
    *LOGMINER: End mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_178_791922278.ARC*
    *LOGSTDBY Analyzer process P003 started with pid=25 OS id=6016*
    *LOGSTDBY Apply process P004 started with pid=26 OS id=5184*
    *LOGSTDBY Apply process P005 started with pid=27 OS id=3572*
    *LOGSTDBY Apply process P007 started with pid=29 OS id=4764*
    *Sat Aug 25 12:18:09 2012*
    *LOGMINER: Begin mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_179_791922278.ARC*
    *LOGSTDBY Apply process P008 started with pid=30 OS id=2576*
    *Sat Aug 25 12:18:09 2012*
    *Completed: ALTER DATABASE START LOGICAL STANDBY APPLY*
    *LOGSTDBY Apply process P006 started with pid=28 OS id=4188*
    *Sat Aug 25 12:18:11 2012*
    *LOGSTDBY stmt: REVOKE SYSDBA FROM VS*
    *LOGSTDBY status: ORA-01031: insufficient privileges*
    *LOGSTDBY id: XID 0x0006.007.00000208, hSCN 0x0000.0015acc3, lSCN 0x0000.0015acc3, Thread 1, RBA 0x00b3.000040cb.10, txnCscn 0x0000.0015acc6, PID 5184, ORACLE.EXE (P004)*
    *LOGSTDBY Apply process P004 pid=26 OS id=5184 stopped*
    *Sat Aug 25 12:18:11 2012*
    *Errors in file d:\oracle\product\10.2.0\admin\stby\bdump\stby_lsp 0_6020.trc:*
    *ORA-12801: error signaled in parallel query server P004*
    *ORA-01031: insufficient privileges*

    *LOGSTDBY Apply process P005 pid=27 OS id=3572 stopped*
    *LOGSTDBY Apply process P006 pid=28 OS id=4188 stopped*
    *LOGSTDBY Apply process P008 pid=30 OS id=2576 stopped*
    *LOGSTDBY Apply process P007 pid=29 OS id=4764 stopped*
    *LOGSTDBY Analyzer process P003 pid=25 OS id=6016 stopped*
    *Sat Aug 25 12:18:16 2012*
    *LOGSTDBY status: ORA-16222: automatic Logical Standby retry of last action*
    *LOGSTDBY status: ORA-16111: log mining and apply setting up*
    *Sat Aug 25 12:18:16 2012*
    *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, preparer process P002 started with pid=24 OS id=3428*
    *LOGMINER: session# = 1, reader process P000 started with pid=22 OS id=3204*
    *LOGMINER: session# = 1, builder process P001 started with pid=23 OS id=5464*
    *LOGSTDBY Analyzer process P003 started with pid=25 OS id=6016*
    *LOGSTDBY Apply process P006 started with pid=28 OS id=4188*
    *LOGSTDBY Apply process P005 started with pid=27 OS id=3572*
    *LOGSTDBY Apply process P004 started with pid=26 OS id=5184*
    *LOGSTDBY Apply process P007 started with pid=29 OS id=4764*
    *LOGSTDBY Apply process P008 started with pid=30 OS id=2576*

    *Sat Aug 25 12:18:17 2012*
    *LOGMINER: Begin mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_178_791922278.ARC*
    *Sat Aug 25 12:18:17 2012*
    *LOGMINER: Turning ON Log Auto Delete*
    *Sat Aug 25 12:18:17 2012*
    *LOGMINER: End mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_178_791922278.ARC*
    *Sat Aug 25 12:18:17 2012*
    *LOGMINER: Begin mining logfile: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STBY\ ARCHIVELOG\STANDBYARCH_1_179_791922278.ARC*
    *Sat Aug 25 12:18:17 2012*

    *LOGSTDBY stmt: REVOKE SYSDBA FROM VS*
    *LOGSTDBY status: ORA-01031: insufficient privileges*
    *LOGSTDBY id: XID 0x0006.007.00000208, hSCN 0x0000.0015acc3, lSCN 0x0000.0015acc3, Thread 1, RBA 0x00b3.000040cb.10, txnCscn 0x0000.0015acc6, PID 5184, ORACLE.EXE (P004)*
    *LOGSTDBY Apply process P004 pid=26 OS id=5184 stopped*

    *Sat Aug 25 12:18:17 2012*
    *Errors in file d:\oracle\product\10.2.0\admin\stby\bdump\stby_lsp 0_6020.trc:*
    *ORA-12801: error signaled in parallel query server P004*
    *ORA-01031: insufficient privileges*

    *LOGSTDBY Apply process P005 pid=27 OS id=3572 stopped*
    *LOGSTDBY Apply process P008 pid=30 OS id=2576 stopped*
    *LOGSTDBY Apply process P006 pid=28 OS id=4188 stopped*
    *LOGSTDBY Apply process P007 pid=29 OS id=4764 stopped*
    *LOGSTDBY Analyzer process P003 pid=25 OS id=6016 stopped*




    Kindly Help me out.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >ORA-01031: insufficient privileges*
    above is reported multiple times. WHY?

    when was STANDBY last working without error?
    what changed since then?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2012
    Posts
    2
    Standby stop working on 25th August onward,



    .during implementation and testing it worked perfectly fine, but at same night due to power failure standby database shut down.

    3.In morning I checked v$logstdby table all processes were stopped,
    I issue
    ALTER DATABASE START LOGICAL STANDBY APPLY;

    All log mining processes started but
    Reader process status was

    ORA-16127: stalled waiting for additional transactions to be applied


    and after few seconds all log mining processes get stopped.

    In alert.log,
    ORA -01031 is logged, but

    that error is followed by

    REVOKE sysdba from VS; which I didn't executed.

    so I am curious what was happed after starting all log mining processes.

    kindly explain.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •