Author:Yuchong.Xu Email:vc.123@qq.com 测试文档,若有问题请及时沟通
12c Data Guard Far Sync-07
2
,更改日志传输模式
--
SYNC AFFIRM
DGMGRL> EDIT DATABASE pdb SET PROPERTY RedoRoutes='(LOCAL : far01pdb
sync)' ;
Property "redoroutes" updated
ALTER SYSTEM SET log_archive_dest_3='service="far01"','SYNC AFFIRM delay=0
optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="far01pdb" net_timeout=30','valid_for=(online_log<le,all_roles)'
SCOPE=BOTH;
Fast SYNC
配置
1
,更改日志传输模式
-- SYNC NOAFFIRM
1,
通过修改
RedoRoutes
参数
DGMGRL> EDIT DATABASE pdb SET PROPERTY RedoRoutes='(LOCAL : far01pdb
FastSync)';
Property "redoroutes" updated
----
对应数据库命令:
ALTER SYSTEM SET log_archive_dest_3='service="far01"','SYNC NOAFFIRM delay=0
optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="far01pdb" net_timeout=30','valid_for=(online_log<le,all_roles)'
SCOPE=BOTH;
2
,
通过修改
Logxptmode
参数
DGMGRL>edit database <name> set property Logxptmode = ‘FastSync’;
Congures REDO transport with SYNC NOAFFIRM
show far_sync far01pdb LogXptMode
show database pdb LogXptMode
edit database pdb set property Logxptmode ='FastSync';
EDIT DATABASE pdb SET PROPERTY RedoRoutes='(LOCAL : far01pdb)';
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxPerformance;
DGMGRL> EDIT DATABASE pdb SET PROPERTY RedoRoutes='(LOCAL : far01pdb)'
2 / 2
评论