Oracle 19c DataGuard搭建以及使用dg_broker管理.docx

目录

 搭建以及使用  管理

目标

环境配置

主库添加 

主库修改文件转换参数

主库开启 闪回归档

主库拷贝密码文件并传输给备库

'()* 创建 +#$

'()* 创建 ,)'-*. 实例"

 检查参数以及文件"

 配置%

 文件路径配置%

开启 (*&

连接主库创建 

添加 +#$,)'-*./

 配置 $ 保护模式

"将 +#$ 转换为使用 $ 实例传输归档

Oracle 19c DataGuard 搭建以及使用 dg_broker 管理

目标

数据库 软件版本 实例类型

tns alias

orcl.rac.libai   +!'). 4#!

czhstd.rac.libai  

+#$ 单实例

4#$

1 环境配置

1.2 主库修改文件转换参数

由于我们使用  管理，所以 #1$ 参数我们不手工修改。

$$!$!1:64#$6;67)<)'.=)<),>=?6;6

4#$6;67)<)'.=)/)."/@"?&.?/ /@..)&./%%)<),>=?6;64#$6;67)<)

'.=)/)&&.%)%???/ /@..)&./@..)<),>=?6;64#$6;67)<)'.=

)/?/?""%"%?/ /...)&./%@ &)<),>=?6;64#$6;67)<)'.=<?(+,>=?6;6

4#$6;67)<)'.=)/)."/@"?&.?/ /@..)&./%%<?(+,>=?6;64#$6;67)<)

'.=)/)&&.%)%???/ /@..)&./@..<?(+,>=?6;64#$6;67)<)'.=

)/?/?""%"%?/ /...)&./%@ &<?(+,>=?6$:$$:6A69

$$!$!1:64#$6;67)<)'.=*=>*?=6$:$

)=<?'-<?(?<1$$4:G$4H9

)=<?'-<?(?<1$:G0$H9

)=<?')<)@)?,=)B@).E*9

)=<?')<)@)?,'.?=>*9

)=<?')<)@)?+?*9

1.3 主库拷贝密码文件并传输给备库

)(.(H2 "/&"/ !2

7$$22 "/&"/ 0H!2

)(.(HI

J30KLM$!2"&/"N!

A2$$#!P$://////

A$$:$

A!:6//6

A$:64#$6

A$4:&

A$:66

A!:66

A!:66

A$$:6/6

A$#$:65+'<.=:<.+85?'F>.?:4#$Q@86

A://!

A$$$://

A!$$2:6I$16

A$!:6,'.?N6

A$: //!

A$:6C*<@6

A$!!:S)C<T

1.5 备库创建 adump 以及其他目录

J30KLM!0!4#$!

J30KLM!04#$

<$!) &" $

,I4"%/$

F4&/ /%$

$@P$ //"$

'@P$%"$

1.7 创建监听并启动

可以使用  创建监听，也可以手工编辑 $ 创建静态监听，然后启动监听查看实例是否注册

J3$LM$$$

1.8 将主库密码修改成对应实例

J3$LM!2M').=?B(?$24#$