Archive for September, 2013

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 - 64bit Production

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

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

Configuration - TESTADG

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

Fast-Start Failover: DISABLED

Configuration Status:

Continue reading