Temporarily disable data guard using data guard broker

Those are some handy dgmgrl Commands to stop Log Transport in Primary Database and Log Apply in Standby Database.


bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys
Password:
Connected.
DGMGRL> show configuration

Configuration - TESTADG

  Protection Mode: MaxPerformance
  Databases:
    prim - Primary database
    stnd - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS


To stop Transport and Apply:


DGMGRL> edit database prim set state='LOG-TRANSPORT-OFF';

DGMGRL> edit database stnd set state='LOG-APPLY-OFF';


To start Transport and Apply:


DGMGRL> edit database prim set state='ONLINE';

DGMGRL> edit database stnd set state='ONLINE';

Thanks
A Rahim Khan

Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: