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 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

Continue reading