-- 構成の解除
dgmgrl
connect sys/oracle
show configuration;
disable configuration;
show configuration;
REMOVE CONFIGURATION;
show configuration;
-- 初期化パラメータ修正 (act, stb)
show parameter dg
alter system set dg_broker_config_file1 = '/home/oracle/dr1.dat' scope=spfile sid='*';
alter system set dg_broker_config_file2 = '/home/oracle/dr2.dat' scope=spfile sid='*';
shutdown immediate
startup
show parameter dg
-- 構成の作成
dgmgrl
connect sys/oracle
show configuration;
CREATE CONFIGURATION 'act.example.com' AS
PRIMARY DATABASE IS 'act'
CONNECT IDENTIFIER IS ACT;
SHOW CONFIGURATION;
ADD DATABASE 'stb' AS
CONNECT IDENTIFIER IS STB;
SHOW CONFIGURATION;
ENABLE CONFIGURATION;
SHOW CONFIGURATION;
show database verbose act;
show database verbose stb;