2024年4月28日发(作者：)

长天科技 QQ:569461366

Oracle 12c Dataguard

部署实施

长天科技-刘磊 2017-08

1

长天科技 QQ:569461366

目录

1.

2.

3.

4.

5.

6.

7.

8.

9.

环境说明 ................................................................................................................................... 3

环境配置及先决条件 ............................................................................................................... 3

（主库）启动FORCE LOGGING ............................................................................................... 3

（主库）启动归档模式 ........................................................................................................... 4

（主库）添加 standby redo logfile ......................................................................................... 5

5.1. 查看 Primary 库的 REDO 相关信息： ..................................................................... 5

（主备库）分别配置监听并启动 ........................................................................................... 6

（主备库）分别配置 ........................................................................................ 6

（备库）创建必要的目录 ....................................................................................................... 6

（主库）创建pfile 文件并修改pfile 内容 ........................................................................... 7

9.1. 创建pfile ...................................................................................................................... 7

9.2. 修改pfile ...................................................................................................................... 7

9.3. （主库）用新参数重启数据库： ............................................................................... 7

（主库）将主库的口令文件copy到备库 ......................................................................... 8

将主库的参数文件copy到备库并修改 ............................................................................. 8

（备库）用spfile 将备库启动到nomount 状态 ............................................................. 8

（备库）开始进行Active duplicate .................................................................................... 8

（备库）打开备库并并启动apply ..................................................................................... 9

验证DG ............................................................................................................................... 10

15.1. 主库CDB表T实验 ................................................................................................ 10

15.2. 备库实验 ................................................................................................................. 11

15.3. 主库CDB表pdb实验 ............................................................................................ 11

15.4. 主库PDB表T实验 ................................................................................................ 13

附录..................................................................................................................................... 15

16.1. .bash_profile（Oracle用户：orcl-p.） .................................................................. 15

16.2. （两节点）/etc/hosts ............................................................................................ 16

16.3. （两节点） ........................................................................................ 16

16.4. （两节点） ........................................................................................... 17

16.5. (主库) ..................................................................................................... 17

16.6. (备库) ..................................................................................................... 18

10.

11.

12.

13.

14.

15.

16.

2