2 Replies Latest reply: Feb 9, 2014 2:32 AM by Renu-Oracle RSS

    logical standby issue after adding a new user at production db server

    Achyot

      Hello Experts,

       

      I am facing a issue related to logical standby db server where after adding a new user at production db server logical standby has stopped sql apply. Can anybody give some idea to find out the root cause and give some tips to resolve the issue.

       

      tried below .....

       

      SELECT EVENT_TIME, STATUS, EVENT FROM DBA_LOGSTDBY_EVENTS

      ORDER BY EVENT_TIMESTAMP, COMMIT_SCN, CURRENT_SCN;

       

      got error

       

      ..........................

      ORA-16227: DDL skipped due to missing object

      ...................

      ORA-01403: no data found

      ................................

      ORA-00942: table or view does not exist

       

       

       

      OS : RHEL 4 (IBM P5)

      DB : Oracle 10g (10.2.0.1)

       

       

      Achyot