Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dataguard RFS process not started up

555329May 2 2007 — edited Oct 9 2007
Please,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2007
Added on May 2 2007
8 comments
13,110 views