How can I update a remote Oracle 8i database, using the redo logs of the local Oracle 8i database? I want to use redo logs to minimize network traffic and to be sure that the insert, update, and delete posted on the local database have been committed.

    Requires Free Membership to View

You can set up a Standby Database. With a Standby Database, you can ship the archived redo logs to the remote database and then have the contents of those logs applied to the Standby Database. The only downside is that the Standby Database cannot be opened for use while redo is being applied. This is an Oracle 8i restriction. I would highly recommend upgrading to Oracle 9i or 10g. The Standby Database underwent a major facelift, so much so that the product was renamed Data Guard. Oracle 9i Data Guard lets you open the Standby Database in READ ONLY mode so that your applications can use both databases.

If you want to have your applications always use both databases, then you'll have to use Oracle Advanced Replication. This will cause network traffic that is not as nice as shipping archived redo logs. But both databases can be opened for business.

This was first published in December 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: