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
> Logical stand by out of Sync
killerDBA
post Jul 24 2017, 04:16 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 18-July 17
Member No.: 52,082



Hello Experts,

Currently we are facing a logical stand by(11.2.0.4) out of sync issue.

Current situation

1. Both primary and logical standby is running on same server(may not be relevant in this case, still..)

2. The last applied SCN on the Logical stand by was on 2nd_March-2017(The team did not notice the stand by sql apply has stopped after a restart)

3. The archive logs from March 2nd to 26th have been lost.


Is there any possibility that we can re-sync the primary and logical stand by again or is it a clear logical stand by rebuild scenario? sad.gif

Any scope for 'instantiate_table' option?

Please advice,

Thanks
Go to the top of the page
 
+Quote Post
burleson
post Jul 24 2017, 07:06 AM
Post #2


Advanced Member
***

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



Hi,

Given the loss of logs, I would re-clone the standby;

http://dba-oracle.com/googlesearchsite_pro...5564j3510652j10

Also see here:

http://dbaforums.org/oracle/index.php?showtopic=22324

What is the benefit to having a standby server on the same hardware as the primary?

Here are my notes on instiantiate-table:

http://www.dba-oracle.com/t_oracledataguar...tiate_table.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
killerDBA
post Jul 25 2017, 06:48 AM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 18-July 17
Member No.: 52,082



Dear Don...

Thanks for your prompt reply, Let me check the options which you have suggested.


Best Regards,
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: 20th October 2017 - 04:21 PM