A Oracle DBA's BLOG

Welcome to my ORACLE DBA blog. You will be Amazing!!!

Saturday, April 11, 2015

Oracle Dataguard Disable/Enable by DataGuard Broker



At this basic article I'll sampling to Disable and Enable Dataguard.

[oracle@veysi ]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - Production

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

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/*******
Connected.

DGMGRL> show configuration

Configuration - veysi_config

  Protection Mode: MaxPerformance
  Databases:
    istanbul- Primary database
    Germany - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS


Disable Transport LOG and Apply:


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

SUCCESS

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

Enable Transport LOG and Apply:


DGMGRL> edit database istanbul set state='ONLINE';
SUCCESS

DGMGRL> edit database Germany set state='ONLINE';
SUCCESS

Hope,its helps..

No comments:

Post a Comment