Dataguard RFS process not started up
555329May 2 2007 — edited Oct 9 2007Please,
Using Oracle 10g release 2 on Windows.
I set up physical Dataguard that was working perfectly, until I decided to:
On the primary database
1. DEFER to Remotely send Archive log to standby database
SQL.> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER
2. IMPORT data into the primary database, via IMP tool.
When I RE-ENABLED archiving data to remote standy and started the MRP process if found that the RFS process on the standy database is not running.
SQL.> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE
On the primary database I verify if the the destination is OK, below is the output I got.
SQL> SELECT DEST_NAME, STATUS, BINDING, ARCHIVER FROM V$ARCHIVE_DEST WHERE DEST_ID=2;
DEST_NAME STATUS BINDING ARCHIVER
-------------------- --------- --------- ----------
LOG_ARCHIVE_DEST_2 ERROR OPTIONAL LGWR
[b]But from the primary database
tnsping acces_seco_orcl works
from the secondary database
tnsping acces_prim_orlc works
So What else can cause the RFS process on the standby database to not startup ?
Because for me It sound like the ERROR status is because the LGWR process cannot contact the RFS on standby to send redo data created during the IMP process in order to update both database.
Thanks for your help
Thanks