7 Replies Latest reply: Apr 9, 2013 7:19 AM by Sunny kichloo RSS

    Redo is not shipping to DR server which is on same server as production.

    847798
      Hi All,

      I have configured DR server on the same server as production , but log shipping and recovery process has been stopped from DR end.

      OS = windows 7
      production instance name = test
      DR instance name = drtest
      db name = test


      Even i created password file with sys password and renamed it in $ORACLE_HOME/dbs location as "orapwDRTEST"

      Production database password file name = orapwTEST
      DR database password file name = orapwDRTEST


      Got below error from primary end.


      SQL> select DEST_NAME,DEST_ID,STATUS,error from v$archive_dest where dest_id=2;

      DEST_NAME
      -------------------------------------------------------------------------------

      DEST_ID STATUS
      ---------- ---------
      ERROR
      -----------------------------------------------------------------
      LOG_ARCHIVE_DEST_2
      *2 ERROR*
      ORA-01031: insufficient privileges



      Please help me where i am missing and leads to this error....


      Regards,
      Vamsi....