Solved

Oracle data guard using crossover cable ok?

Posted on 2011-09-30
8
744 Views
Last Modified: 2012-05-12
Hi,

I see that Oracle RAC does not support the use of crossover cables, but what about if I just want to use Data Guard with plain old Oracle Enterprise edition? I will have two Oracle 11g servers right beside each other and want to use Data Guard for disaster situations. I thought this would be better than just taking frequent backups with a 3rd party tool. Is crossover ok or do I seriously need a switch?

Thanks.
0
Comment
Question by:Gandharva_Guy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 36893931
I haven't actually done it, but I would think you should be able to do it with just a crossover.

As long as you can get the listener to make connections across it and log shipping to move the logs, it should be fine.

I would think it would be a pretty quick test.  You don't actually have to build the standby, just start the log shipping and make sure they start going across.
0
 

Author Comment

by:Gandharva_Guy
ID: 36893967
Well, yes I think it would work, but I guess what I am really asking is whether Data Guard is subject to the same kind of risks as RAC whereby using crossover cables isn't supported due to some NIC cards which hang when the link goes down (media sensing) on the far end, say due to a reboot, blue screen, etc.

From what I am reading, Data Guard should just pick up where it left off once both servers are back up.
0
 

Author Comment

by:Gandharva_Guy
ID: 36894003
Here's a discussion of what I am referring to. I can see how this is an issue for clusters but I am wondering if this applies to Data Guard use also.

https://forums.oracle.com/forums/thread.jspa?threadID=2243978
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

Author Comment

by:Gandharva_Guy
ID: 36894061
Further, the whole reason I am wondering is because the public network I have is a wimpy 10Mb/s (and not easily upgraded) so I need something a lot faster between the two servers.
0
 
LVL 35

Accepted Solution

by:
johnsone earned 50 total points
ID: 36894154
Data Guard does not have a heartbeat that it needs.  If one side of the link goes down, then the logs don't get shipped.  You just need to make sure that the destination over the link is an optional destination.  As I recall, the data guard documentation pushes you in that direction anyway.

The link you provided discusses the interconnect used for the heartbeat for RAC.  Data Guard doesn't use anything like that.  It shouldn't be an issue.

If there is some underlying hardware/firmware reason that locks up the interface (or machine) or crashes the machine, that is not something that Oracle can do anything about.  You may need to correct that before your primary and/or standby can continue to function.
0
 

Author Comment

by:Gandharva_Guy
ID: 36894321
Would you happen to have a link to where the docs talk about an "optional destination" as you mentioned?

Is there a way I can specify the preferred route for it to use and still have both routes available if one or the other goes down?
0
 
LVL 35

Expert Comment

by:johnsone
ID: 36896653
Here is the link to the LOG_ARCHIVE_DEST parameter that you would set for log shipping:

http://download.oracle.com/docs/cd/E11882_01/server.112/e24448/initparams122.htm#I1010086

This link is for the section in the Data Guard doc that describes setting up redo transport (aka log shipping):

http://download.oracle.com/docs/cd/E11882_01/server.112/e22491/log_transport.htm#i1148216


The route that will be taken is specified by the service you set up in the tnsnames.ora file.  I would suggest that route rather than specifying the full connect string in the log archive destination.  You would need 2 listeners running on the destination, one on the interconnect and one on the public interface.  If one goes down, simply switching the tnsnames.ora entry would force the connection to the other interface.

Alternately, you could set up 2 log destinations on the standby server.  One through the interconnect and one through the public interface.  If one goes down, the other should continue to function.  You may have to manually move around some files in this case, but everything should get there.

Be aware that in the event of a hung server, neither destination would work.
0
 

Author Comment

by:Gandharva_Guy
ID: 36897085
Thanks a lot for this info! This pretty much answers it I think, just need to try it out when the time comes.

Cheers!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pivoting oracle table 9 92
HP 2530 switch and routing 4 100
Select the 2 most recent visit dates 5 31
How to separate mgmt & production vm network 8 79
Hello All, I have been training on Multicast for a while now and whenever I start the topic , I find out that my friends /  Colleagues mention that they do not know how to test Multicast Joins. As most of the multicast would be video traffic and …
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question