Home » Server Options » Replication » Standby DB vs Replication
Standby DB vs Replication [message #75277] Tue, 08 October 2002 11:50
Tom
Messages: 67
Registered: June 1998
Member
We are running Oracle 8.1.7 on Solaris in Production. We have a business resumption server (same DB and OS) that we will use to back up our database. This will only be used as a backup due to licensing restrictions. The Production server is in Minnesota while the resumption server is in Arizona. Now, we would also like to create a reporting/query database, but that would end up on the same box as Production due to the licensing requirements again. Management does not want to pay the extra fees for additional licenses, our original recommendation was to use the business resumption servers as reporting servers as well. They will not do this.

So, the options they seem to like initially are replication or stand-by database, for both the resumption and reporting databases. Has anybody done any analysis on the two? I am looking for people's experiences, general thoughts, possibly some data on what is required for the two options (time commitment, cost, etc) so we can make a good decision. Or are other alternatives better? Any info is appreciated! Thanks!
Previous Topic: ORA-00232 snapshot controlfile is nonexistent, corrupt, or unreadable
Next Topic: Oracle AIX with MQSeries on NT
Goto Forum:
  


Current Time: Mon May 23 00:02:11 CDT 2022