Problem solve Get help with specific problems with your technologies, process and projects.

Synchronizing primary and standby databases

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

This was last published in May 2003

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.