Thanks for the question, Daniel.
Asked: February 08, 2017 - 5:54 pm UTC
Last updated: February 08, 2017 - 9:35 pm UTC
Version: 11.1.0.7.0 64bit
Viewed 1000+ times
You Asked
Hello,
If I alter an user table (add a new column) in a dataguard environment from the active node, will that be reflected on the mounted DB of the passive node?
Regards,
Daniel
and Connor said...
Yes. DataGuard (we're talking physical standby here) is a "binary copy" of the source database. So it's not like we apply DDL - we simply take every single modification to the database (ddl, dml, etc) and apply that modification to the standby in the same way that we would do a normal database recovery.
That is one of the good things of DataGuard - it is like a continuous test of reliability of your redo logs for recovery purposes.
Is this answer out of date? If it is, please let us know via a Comment