High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center