OraFAQ Forum: Performance Tuning » Slow Archive Apply in Physical Standby

Home » RDBMS Server » Performance Tuning » Slow Archive Apply in Physical Standby (Oracle EE 12.2 , Linux 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Slow Archive Apply in Physical Standby [message #684849]

Tue, 07 September 2021 08:08

Akmmhto
Messages: 38
Registered: September 2018

Member

MRP is not enabled , Also RFS is disabled.

We copy Archives to DR with automated scripts.

My 300+ archives are successfully copied there but when i start recovering DR , it is taking almost 9-10 minutes for single archive.

Each archive size = approx 1 GB

Can you suggest , what i need to check ?

Report message to a moderator

Re: Slow Archive Apply in Physical Standby [message #684850 is a reply to message #684849]

Tue, 07 September 2021 08:22

John Watson
Messages: 8995
Registered: January 2010
Location: Global Village

Senior Member

Recovering the way you are doing it will be slow. You should configure Data Guard correctly, so that the redo is sent across in (near) real time to an RFS and applied as soon as it arrives by MRP. MRP can parallelize the apply, which you can't do your way.

Report message to a moderator

Re: Slow Archive Apply in Physical Standby [message #684851 is a reply to message #684850]

Tue, 07 September 2021 08:24

Akmmhto
Messages: 38
Registered: September 2018

Member

Yes , I have suggested this solution to customer to allow me to apply the best practice for DG.

But i want to know that , Is there any possibility to tune its performance without enabling MRP..

Report message to a moderator

Re: Slow Archive Apply in Physical Standby [message #684856 is a reply to message #684851]

Thu, 09 September 2021 01:03

John Watson
Messages: 8995
Registered: January 2010
Location: Global Village

Senior Member

300 archives at 9 minutes each will take nearly 19 days to apply. During the 19 days there will be more archives generated. The way to "tune" this process is to destroy the standby and create a new one configured correctly. Telling your customer that if you do that, you will invoice him for 1 day's work instead of 19 may persuade him.

Report message to a moderator