Dataguard replication issue
edited Jul 27, 2016 5:06AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 10 commentsAnswered
Hello Folks,
I need your assistance, the replication of our production db has stopped, ive been trying to troubleshut but im failing the transport lag is now about 2 days 15 hours
I doubt about the configs in the trasport log destinations
on primary I have
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=T24DR ASYNC valid_for=
(ALL_LOGFILES,ALL_ROLES) db_un
ique_name=T24DR
the state of log_archive_dest is enable
on the standby
| log_archive_dest_2 string | service=T24PROD ASYNC valid_for= |
| (ALL_LOGFILES,ALL_ROLES) db_unique_name=T24PROD |
Tagged:
1