4

Does Oracle have any built-in features to support a master-slave mirroring mechanism ?

I am looking to mirror/replicate the production server on to a read-only database. The read-only database would be used for reporting and such purposes.

We are using Oracle 10gR2

Sathya
  • 157
  • 1
  • 1
  • 6

6 Answers6

3

Oracle Dataguard is what you want. It provides a master-slave configuration for up to 9 slaves (which is pretty impressive!)

Its expensive though, you need Oracle enterprise edition.

gbjbaanb
  • 3,892
  • 1
  • 23
  • 27
2

One thing about Oracle: I really really recomment NOT using RAC unless you are an Oracle guru. Everyone gets RAC horribly wrong.

I am not an Oracle guru, but from what I understand at least historically Oracle uses RAC for their clustering. That's two (or more) servers with the same storage, meaning you will probably need a SAN and another barrel full of money for the licensing.

I am not aware of a read-only-slave solution for Oracle. That doesn't mean that there isn't one.

Thomas
  • 1,476
  • 11
  • 16
1

dataguard in 10g doesnt support reading of data from the standby though. So you need "Active dataguard" available in 11g.

Also - About streams on the post above (comment isnt available for me yet!) streams is now deprecated and replaced with oracle goldengate.

Codek
  • 203
  • 2
  • 9
1

I don't believe you need DG to use a logical standby database. . However, you will need to license your standby database/server as well. Here is a pretty good description of the manual steps necessary to build one. It works - I've done it.

DCookie
  • 2,098
  • 1
  • 17
  • 18
  • You can create a physical standby without DataGuard-- you would just need to restore a database backup to a backup machine, copy the archived logs as they are generated and apply them. Creating a logical standby without DataGuard would be far more difficult. In theory, you could use Streams and apply the LCRs to the destination database, but that involves a lot more work than simply configuring a standby. And if you can use Streams, you've got the enterprise edition, so you already have DataGuard. Either way, the standby needs to be licensed. – Justin Cave Jun 30 '09 at 21:15
  • I stand corrected. I was apparently using a component of DG (real time apply) without actually realizing it was a part of DG. – DCookie Jun 30 '09 at 22:06
0

Look into Streams Replication - You won't need the additional Dataguard licensing. It takes a bit of practice to get it right, but if you're using Grid Control, it provides a wizard to help you set it up. You could also just create the scripts using the Enterprise Manager. I have used this for one way and two way replication.

Roqetman
  • 99
  • 2
  • Streams requires that the source database be running the enterprise edition. DataGuard is part of the enterprise edition license. So I'm not sure what licensing benefit you are expecting to get from Streams over DataGuard. You could use Streams to have standard edition slaves off of an enterprise edition master, but that would severely complicate failover. – Justin Cave Jun 30 '09 at 14:43
-1

You can set up 3 database servers and import start-up database into 3 servers, Please configure your insert and update application so that it writes on other servers (its mechanism is so easy) then you have mirrored exactly on other server...

Sorkhabi
  • 1