Already a member?
Sign in
Location: Editions
Discussion: How do you replicate if you are using Oracle Database SE and RAC?
Watch
 caffeinated24x7 |
How do you replicate if you are using Oracle Database SE and RAC?
Jan 12 2008, 1:10 AM EST I have a two-node cluster on 10gR2 Linux x86 with 1-dual core chip in each node. I am interested in creating a DR environment in Atlanta. Since Oracle Database SE RAC allows up to 4-cpus with that cover licensing? Also, since Dataguard and Advanced Replication are now available with SE, what do you suggest is the next best practice for replicating to the new DR site? 3 out of 5 found this valuable. Do you? |
|
adran007 adran007 |
RE: How do you replicate if you are using Oracle Database SE and RAC?
Jan 15 2008, 4:11 AM EST Dataguard and Advanced Replication is not included in DB SE. It's only in DB EE. 0 out of 2 found this valuable. Do you? |
|
peningda peningda |
RE: How do you replicate if you are using Oracle Database SE and RAC?
Feb 7 2008, 8:01 PM EST The SE license requires the whole cluster to be physically in a single room. Since you are using SE, perhaps the "You Probably Don’t Need DataGuard" presentation from Niall Litchfield will be of interest http://www.niall.litchfield.dial.pipex.com/DataGuard.zip 0 out of 2 found this valuable. Do you? |
|
brinsmem brinsmem |
RE: How do you replicate if you are using Oracle Database SE and RAC?
May 4 2008, 11:03 PM EDT You *can* build a physical standby database with SE, and this is almost certainly what you want for disaster recovery. The only catch is that you cannot use DATA GUARD to maintain the physical standby -- it is not available with Standard Edition. Happily, all you really need is a couple shell scripts to transfer archived redo logs, and apply them at the DR site. The only catch here, is that with this technique, you *will* lose some data when you failover to the DR site, because the standby database can on be as current as the last *archived* redo log. You can probably fix this, though, by using some sort of block-level replication to synchronously maintain the online redologs at the DR site. It will probably be expensive, and has the potential to slow down the primary database -- perhaps significantly -- so do this only if you really need to. 1 out of 1 found this valuable. Do you? |
