This discussion is archived
6 Replies Latest reply: Apr 9, 2013 4:34 AM by Sunny kichloo RSS

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

847798 Newbie
Currently Being Moderated
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....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points