DG测试—Failover
[oracle@lfdz1 ~]$ dgmgrlDGMGRL for Linux: Version 11.2.0.3.0 - ProductionCopyright (c) 2000, 2009, Oracle. All rights reserved.Welcome to DGMGRL, type "help" for information.DGMGRL> connect sys/oracle@sbdb1Connected.DGMGRL> DGMGRL> failover to 'SBDB1';Performing failover NOW, please w...
DG测试—Switchover
DGMGRL> show database verbose 'PROD1';Database - PROD1 Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): PROD1 Properties: DGConnectIdentifier = ...
DG—dgmglr failover配置
主库、备库都开启dg_brokerSYS@PROD1> show parameter dg_broker;NAME TYPE VALUE------------------------------------ ----------- ------------------------------d...
DG测试—Snapshot standby
SYS@SBDB1> show parameter recover;NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest ...
11g手工搭建ADG
主库:开启归档模式SYS@PROD1> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination /u01/app/oracle/product/11.2.0/dbhome...