Home » RDBMS Server » Performance Tuning » Slow Archive Apply in Physical Standby (Oracle EE 12.2 , Linux 7)
Slow Archive Apply in Physical Standby [message #684849] Tue, 07 September 2021 08:08 Go to next message
Akmmhto
Messages: 36
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 Go to previous messageGo to next message
John Watson
Messages: 8641
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 Go to previous messageGo to next message
Akmmhto
Messages: 36
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 Go to previous messageGo to next message
John Watson
Messages: 8641
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

Re: Slow Archive Apply in Physical Standby [message #684857 is a reply to message #684856] Thu, 09 September 2021 01:14 Go to previous messageGo to next message
Akmmhto
Messages: 36
Registered: September 2018
Member
Mission of convincing customer was successful Smile
I created More SRLs to reduce checkpoints and Enabled RFS/MRP.

Report message to a moderator

Re: Slow Archive Apply in Physical Standby [message #684858 is a reply to message #684857] Thu, 09 September 2021 02:44 Go to previous message
John Watson
Messages: 8641
Registered: January 2010
Location: Global Village
Senior Member
Customer administration! Often much harder than database administration Smile

Report message to a moderator

Previous Topic: Percentage of CPU utilization per instance
Next Topic: Long running queries
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 03 07:20:24 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.