data guard
A reader, June 06, 2003 - 12:37 pm UTC
Please give me the link. I want to know more about data guard.
June 06, 2003 - 12:58 pm UTC
Excellent Definitions of FailSafe and DataGuard
A reader, June 12, 2003 - 10:23 am UTC
Tom, Thanks for giving us a *very clear and easy* understanding of these products.
Can you please fit 9i RAC into this picture?
A reader, June 12, 2003 - 10:38 am UTC
Tom,
You said:
"Failsafe is HA (high availability) Data guard is DR (disaster recovery)". How would you define RAC - high availability + scalability?
If we want Scalibility and DR, we would need RAC + Dataguard? Can RAC and DataGuard co-exist?
June 12, 2003 - 11:14 am UTC
RAC is HA+scaling up.
RAC and DG can (and do) coexist.
clarifications ....
reader, February 18, 2004 - 9:42 am UTC
Tom,
(1) Is switchover concept new in 9i dataguard?
(2) Creating standby redologs new feature in 9i? If so how was it in 8i standby configuration?
Thanks.
February 18, 2004 - 8:54 pm UTC
1) yes
2) yes
in 8i, there was just the archive log transfer (fill a log on prod, ship to standby, apply)
RAC in a room
bob, July 12, 2004 - 9:08 pm UTC
You say "RAC in a room". Is this link an attempt to show RAC plus data mirroring can work well over a distance?
</code>
http://www.veritas.com/van/articles/6748.jsp <code>
Can you think of any good reason for RAC across some kind of WAN, or more likely many reasons why you might not want to do this?
I enjoyed what you wrote about why failover for dataguard shouldn't be automatic, and found your points to be quite valuable.
July 13, 2004 - 12:01 am UTC
spell latency for me.
buy anyway, we are talking a distance less than my average commute here. is that truly "DR". to me, DR is hundreds of miles.
No, i would not -- using todays conventional technology, even dream about doing RAC over a long cable.
I would urge you to look at the ongoing costs of such a thing (somewhat expensive network)
A reader, July 14, 2004 - 2:27 pm UTC
Good explanation Tom!!
Is Fail Safe Just for Windows?
A Reader, October 14, 2004 - 12:32 pm UTC
Hi Tom,
Is Fail Safe just for Windows? Can we do similar setting in UNIX? Can you point to a document that details the HA and Fail Safe?
Thanks in advance.
October 14, 2004 - 7:32 pm UTC
RAC interested
Dave Bargeron, February 07, 2005 - 3:47 am UTC
Excellent - clears some of the fog of misconception.
Just one question: is RAC (for DR) between two data-centres over 10 miles apart with GB Ethernet Interconnect - high update activity being mis-guided ?
February 07, 2005 - 4:54 am UTC
not going to happen.
they sort of share disk -- it would not make sense to separate the computers (speed of light starts to become the bottleneck) since there is but one DATABASE.
Enter -- standby database, now you have two databases - and you have failover. And they should be separated by 10's or hundreds of miles (The standbys)
RAC is in a room (to make sure the room, that data center can stay up and running).
Standby is for failing over when the room goes boom.
RAC is not for DR (disaster recovery), RAC is HA (Highly available)
extending the RAC Cluster
Dave Bargeron, February 11, 2005 - 9:51 am UTC
If we are extending the RAC cluster, using dark fibre for the interconnects and PPRC in the SAN, I've heard that RAC can start to creak, as the number of nodes in the cluster increase and trans volumes goes up. Is there a point when performance will start to noticibly degrade ?
February 11, 2005 - 8:31 pm UTC
"creak"?
depends on the OS, implementation, what you do -- how you do it. I can make performance degrade noticably on a single instance by hard parsing like mad (eg: it takes one node to show you can build things that don't scale).
A reader, January 24, 2010 - 5:08 pm UTC
Hi
Assume, maximum performance mode, and no standby redologs.
Let say my primary database is crashed and my redologs is half-filled.
I have decided to failover, since current log is not being archived in primary database, I will lose data if I open standby database.
If I copy the redologs from primary to standby, can I apply them to standby database?
January 26, 2010 - 1:50 am UTC
yes, you can.
Alexander, July 12, 2012 - 1:00 pm UTC
Could I argue that since Dataguard does offer smooth, automatic failovers to the standby that we could use this as HA and DR and save a boatload of money and administration headaches (RAC is a PITA I don't care what anyone says...)?
That is of course implying we are fine with not being able to scale horizontally and get the load balancing benefits of RAC.
July 12, 2012 - 6:24 pm UTC
If you can stand a small bit of downtime during your failure and if you keep your data guard site way far away - sure.
RAC is much more instantaneous, no need to decide "should we failover", it just happens.