Data Guard Command-Line

si01:/home/oracle
DGLABS - oracle: dgmgrlDGMGRL for Linux: Version 11.2.0.2.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.

DGMGRL> show configuration
Configuration - DGLABS
  Protection Mode: MaxPerformance
  Databases:
    DGLABS - Primary database
    STBYLAB - Physical standby database

Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS


DGMGRL> show database 'DGLABS'
Database - DGLABS
  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    DGLABS

Database Status:
SUCCESS


DGMGRL> edit database 'DGLABS' set property logshipping='OFF';
DGMGRL> edit database 'DGLABS' set property logshipping='ON';
DGMGRL> show database 'DGLABS' logshipping;
DGMGRL> edit database STBYLAB set state='APPLY-OFF';
DGMGRL> edit database 'STBYLAB' set state='APPLY-ON';

....

No comments:

Post a Comment