Oracle 19c CDB RAC To RAC ActiveDataguard部署方案

更多数据库资源请访问 美河学习在线 www.eimhe.com

Oracle 19c CDB RAC To RAC ActiveDataguard 部署方案

目录

基础环境信息：

1.主库：生成参数

2.备库：准备参数：

3.备库：启动 nomount 状态

4.主库：准备密码文件

备节点测试：

10.备库：执行恢复

11.备库：将参数 pfile 文件恢复到 asm 中

12.备库：将密码文件恢复到 asm 中

13.备库：添加 rac 资源

14.主备库：还原备库 dgrac1 上的监听 listener.ora 和所有主备库上的 tnsnames.ora

15.备库：重启数据库到 mount 状态

16.主备库：配置 dg_borker

17.备库：启用 adg 实时同步查询：

测试数据同步：

Oracle 版本 Oracle 19.5.0.0.0

操作系统 CentOS 7.6 x64 最小化安装

最低配置建议 cpu 2c mem 8g swap 8g / 50G 3 个 1G 共享磁盘 asm-crs1/2/3 3 个

10G 共享磁盘 asm-data1-3（不安装 mgmt，如果安装则需要再加单独 50G 盘）

/etc/hosts 内容:

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

####orcl#####

#public

更多数据库资源请访问 美河学习在线 www.eimhe.com

192.168.5.53 rac2-vip

#priv

192.168.6.50 rac1-priv

192.168.6.51 rac2-priv

#scan

#vip

192.168.5.62 dgrac1-vip

192.168.5.63 dgrac2-vip

#priv

192.168.6.60 dgrac1-priv

192.168.6.61 dgrac2-priv

#scan

private ip 192.168.6.50/192.168.6.51

vip 192.168.5.52/192.168.5.53

scan-ip 192.168.6.54

数据库名

db_name orcl

db_unique_name orcl

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

更多数据库资源请访问 美河学习在线 www.eimhe.com

节点 1/节点 2

主机名 dgrac1/dgrac2

public ip 192.168.5.60/192.168.5.61

private ip 192.168.6.62/192.168.6.63

vip 192.168.5.60/192.168.5.61

scan-ip 192.168.6.64

SQL> !cat /home/oracle/o.txt

*.adg_redirect_dml=TRUE

*.audit_file_dest='/oracle/app/oracle/admin/orcl/adump'

*.audit_trail='none'

*.cluster_database=true

*.compatible='19.0.0'

*.control_files='+DATA/ORCL/CONTROLFILE/current.265.1026902749'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_name='orcl'

*.diagnostic_dest='/oracle/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.enable_pluggable_database=true

*.fal_server=''

family:dw_helper.instance_mode='read-only'

orcl1.instance_number=1

orcl2.instance_number=2

*.local_listener='-oraagent-dummy-'

*.log_archive_config='nodg_config'

*.log_archive_dest_1='location=+DATA'

更多数据库资源请访问 美河学习在线 www.eimhe.com

*.pga_aggregate_target=780m

*.processes=320

*.remote_login_passwordfile='exclusive'

*.resource_manager_plan='DEFAULT_CDB_PLAN'

*.sga_target=2340m

*.standby_file_management='AUTO'

orcl2.thread=2

参数当中

2.备库：准备参数：

两个节点 oracle 用户执行：

mkdir -p /oracle/app/oracle/admin/dgorcl/adump

cat /home/oracle/o.txt

*.adg_redirect_dml=TRUE

*.audit_file_dest='/oracle/app/oracle/admin/dgorcl/adump'

*.audit_trail='none'

*.cluster_database=true

*.db_recovery_file_dest_size=10737418240

*.db_recovery_file_dest='+DATA'

*.db_unique_name='dgorcl'

*.diagnostic_dest='/oracle/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.enable_pluggable_database=true

*.fal_server=''

family:dw_helper.instance_mode='read-only'

orcl1.instance_number=1

orcl2.instance_number=2

更多数据库资源请访问 美河学习在线 www.eimhe.com

*.nls_language='AMERICAN'

*.nls_territory='AMERICA'

*.open_cursors=300

*.pga_aggregate_target=780m

*.processes=320

*.remote_login_passwordfile='exclusive'

*.resource_manager_plan='DEFAULT_CDB_PLAN'

*.log_file_name_convert='+DATA','+DATA'

*.db_file_name_convert='+DATA','+DATA'

3.备库：启动 nomount 状态

[oracle@dgrac1 ~]$ sqlplus /nolog

SQL> conn /as sysdba

SQL> startup nomount pfile='/home/oracle/adg.txt';

SQL> exit

4.主库：准备密码文件

Password file: +DATA/ORCL/PASSWORD/pwdorcl.269.1026902735

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA

Mount point paths:

Services: