Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Dataguard with compression. Uneven transfer of log sequences numbers
Geelwortel
post Jul 17 2017, 05:09 AM
Post #1


Newbie
*

Group: Members
Posts: 7
Joined: 3-July 17
Member No.: 52,057



Hi All

We noticed something very interesting. We enabled Dataguard with compression between two databases over a fairly slow network. The dataguard works and is shipping and applying the logs BUT the shipping part is not done in the correct order of sequence numbers.
Let me use and example:
Seq# 1 - shipped and applied
Seq# 2 - shipped and applied
Seq# 3 - shipped and applied
Seq# 4 - shipped and applied
Seq# 5 - Not shipped
Seq# 6 - shipped but not applied
Seq# 7 - shipped but not applied
Seq# 8 - shipped but not applied
Seq# 9 - shipped but not applied
Seq# 10 - shipped but not applied
After a while the missing sequence is shipped and applied and then all logs that is shipped is applied as well until it reaches a missing sequence# again.

Can someone please give me more information or a solution for this.

Thank you in advance.
Go to the top of the page
 
+Quote Post
burleson
post Jul 20 2017, 11:36 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,492
Joined: 26-January 04
Member No.: 13



Hi Geelwortel,

Sorry about the delay in replying!

I suspect that the primary had a burst of DML. And the redo transferred faster than the secondary could process them.

As to the out-of-sequence shipping , I have seen this before. This may help:

http://www.dba-oracle.com/t_physical_stand...og_scenario.htm

Also read here:

http://www.dba-oracle.com/t_oracledataguar...archive_gap.htm

Good luck!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Geelwortel
post Jul 21 2017, 12:28 AM
Post #3


Newbie
*

Group: Members
Posts: 7
Joined: 3-July 17
Member No.: 52,057



Thank you Mr Burleson

The second link in particular is very helpful.
Go to the top of the page
 
+Quote Post
burleson
post Jul 21 2017, 05:24 AM
Post #4


Advanced Member
***

Group: Members
Posts: 13,492
Joined: 26-January 04
Member No.: 13



Hi Geelwortel,

Glad that the link helped!

You live near JHB, correct?


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Geelwortel
post Jul 21 2017, 06:20 AM
Post #5


Newbie
*

Group: Members
Posts: 7
Joined: 3-July 17
Member No.: 52,057



QUOTE (burleson @ Jul 21 2017, 12:24 PM) *
Hi Geelwortel,

Glad that the link helped!

You live near JHB, correct?


Yes, I live in Jhb.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2017 - 02:24 AM