What are the Oracle 9i standby database hardware requirements? I know that the primary and the standby databases need to be the same base release level. But, do they have to be the same edition of the database, i.e. can the primary be the enterprise edition and the standby be the standard edition of the same release? Do they have to be of the same O/S, i.e. can the primary be installed on SUN Solaris and the standby be on Linux? And...
lastly, if the standby database is just sitting in a standby mode do I have to buy another license for the standby database?
I believe that the primary and standby database must both be Enterprise Edition. They do not need to be the same OS, so long as you transport the archived redo logs through TCP/IP. If you transport the logs through a crossmount, then they should be the same OS. And yes, you will have to buy a license for the standby database, even if it is sitting in standby mode. But check with your Oracle Sales representative to be sure.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.