Resyncing standby db after a large import on phyical db
We are on 10.2.0.4 Ent Edition; using Dataguard (primary and physical standby). We will be doing a 50GB import which will include creating new schema and tablespaces prior to the import.
What is best method for updating the standby database:
Could we simply disable Dataguard before the import and enable after the import is compete? Is it better to rebuild the standby db?
Disable Data Guard:
On Standby DB:
i) SQL>alter database recover managed standby database cancel;
ii) SQL> alter system set log_archive_dest_state_2=DEFER;
On Primary DB:
i) SQL> alter system set log_archive_dest_state_2=DEFER;