DG搭建物理备库 - 数据库编程

oker_start=true;----打开主库、备库的DG broker

System altered.

备库执行如下操作：

[oracle@localhost ~]$ db11g

[oracle@localhost ~]$ dgmgrl sys/123456@pjadl11g ----连接到远程的主库上

DGMGRL for Linux: Version 11.2.0.3.0 -64bit Production

Welcome to DGMGRL, type "help"for information.

Connected.

DGMGRL> help create

Creates a broker configuration

Syntax:

CREATE CONFIGURATION AS

PRIMARY DATABASE IS

CONNECT IDENTIFIER IS ;

DGMGRL> create configuration dgc as primary database ispjadl11g connect identifier is pjadl11g; --创建主库

Configuration "dgc" created withprimary database "pjadl11g"

DGMGRL> help add --帮助

Adds a standby database to the brokerconfiguration

Syntax:

ADDDATABASE

[AS CONNECT IDENTIFIER IS ]

[MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> add database sjadl11g as connect identifier issjadl11g maintained as physical; ---增加备库

Database "sjadl11g" added

DGMGRL> enable configuration ---是配置生效，自动修改一些参数

Enabled.

DGMGRL> show configuration ---查看DG是否成功搭建

Configuration - dgc

Protection Mode: MaxPerformance

Databases:

pjadl11g - Primary database

sjadl11g - Physical standbydatabase

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

DGMGRL>

DG搭建物理备库(三)