How does direct path load work when dataguard is enabled?

Posted on

Question :

There’s a few posts about direct path and dataguard but I just want to understand exactly how it actually works.

How maybe I made an incorrect assumption, but if direct path means it writes to the data files (as per the docs) then doesnt that mean no redo is generated?

And if no redo is generated then how does dataguard work? ( which is soley based upon transferring redo to the standby machine right? )

Answer :

If the database is setup correct: no direct path load. If a standby database is depending on the changes captured on the primary database, the primary database should be setup with force logging.

If for some reason the force logging setting is not in place, after such an operation the affected datafiles should be transferred to the standby site[s]. Failing to do so will make queries on the loaded parts of the table[s] in the standby database to fail.

Leave a Reply

Your email address will not be published. Required fields are marked *