I have been facing one issue regarding DataGuard 10g(10.2.0.4), the RFS processes is not starting at DR end.
There was a n/w issue at my site on 3rd Oct and later it got resolved by 6th Oct. Later we had transferred all pending archives to DR server.
Then brought Dr in sync with prod by manual recovery
- Code: Select all
RECOVER STANDBY DATABASE;
Then started managed recovery process and confirmed prod and DR in sync.
- Code: Select all
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
later applied few log switches at prod.
i have checked with v$managed_standby view at Dr but there is no entry of RFS processes, even after 2 days it doesnt start.
- Code: Select all
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_LOG
At production there is no error showing in v$archive_dest view.
- Code: Select all
SQL> select error from v$archive_dest;
ERROR
-----------------------------------------------------------------
Nor any messages at v$dataguard_status view at production.
- Code: Select all
SQL> select message,timestamp from v$dataguard_status;
MESSAGE
-------------------------------------------------------------
TIMESTAMP
---------
ARC2: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
03-OCT-12
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
03-OCT-12
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
03-OCT-12
FAL[server, ARC3]: FAL archival, error 16041 closing archivelog file 'standby'
03-OCT-12
ARC5: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
03-OCT-12
ARC5: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
03-OCT-12
FAL[server, ARC2]: FAL archival, error 16041 closing archivelog file 'standby'
03-OCT-12
-- Connected User is Valid
05-OCT-12
Redo Shipping Client Connected as PUBLIC
05-OCT-12
-- Connected User is Valid
05-OCT-12
Redo Shipping Client Connected as PUBLIC
05-OCT-12
-- Connected User is Valid
05-OCT-12
I have tried recreating new Standby controlfile also.
Please suggest how to resolve this issue.
Regards,
Manish