I have a question regarding a standby database and data guard. We are on 24/7 operation, and we want to have a
primary database and standby database. Is it possible that we have our primary database doing batch processing, while the standby database is open for users to do transactions and updates? How can we synchronize the primary database and standby database? Is there a way that we can apply the changes done in the standby database after batch processing on the primary database to make them synchronized?
A standby database, as it's name implies, is strictly for "standby" purposes. You cannot use both databases at the same time UNLESS you open the secondary in READ-ONLY mode. At that point you could use the standby for reporting purposes or other read-only purposes but while it's open as read-only it will not be updating itself with the log files from the primary database. When you take it out of read-only mode it will have to then get "re-synched" with the primary in order to see all the transactions that occurred on the primary while the standby was in read-only mode.
It sounds more like you want to do some kind of two-replication or something similar, but not standby database.
See the oracle docs on Standby Databases and Replication for more information.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton 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.