Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Standby db vs Replication

271168Oct 8 2002
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2002
Added on Oct 8 2002
2 comments
215 views