Skip to Content
0
Former Member
Jan 22, 2013 at 09:05 AM

Redo log shipping to Standby database very slow

776 Views

Dear Experts,

Redo log shipping to my Oracle standby database seems to be very slow.

Everything was fine till last week. Nothing has changed at database level. I have checked with the network team and they say there is no issue with the network and there is no bandwidth issues with the link. As a test, I have tried to move few archive log files manually from primary to dr, it took very less time when compared to ODG.

Please find env details and log shipment parameter.

Is there anyway, I can ask the Data Guard to utilize more bandwidth and move the logs faster?

Env:

Application: SAP ECC 6.05

Database : Oracle 11g - 11.2.0.3

OS : HP-UX 11.31

SQL> show parameter log_archive_dest_2

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2 string service=SID_DR ASYNC valid_for

=(online_logfiles,primary_role

) compression=enable db_unique

_name=SID_DR

Thanks,
Salman