没有合适的资源？快使用搜索试试~ 我知道了~

文库首页数据库Oracleoracle19c cdb rac to rac adg部署20200307.pdf

oracle19c cdb rac to rac adg部署20200307.pdf

oracle

dataguard

需积分: 49 74 下载量 17 浏览量 2020-03-07 10:52:50 上传评论 5 收藏 593KB PDF 举报

温馨提示

试读

60页

oracle 19c容器多租户 rac to rac的adg测试部署方案，完全实测步骤。使用了DG_BROCKER管理，方便switchover。

资源推荐

资源详情

资源评论

oracle19c cdb rac to rac adg

部署方案

基础环境信息：

主备库：

密码 sys/system 所有初始化密码为：oracle

oracle 版本

oracle19.5.0.0.0

操作系统 centos7.6x64 最小化安装

最低配置建议

cpu 2c mem 8g swap 8g

/ 50G

3 个 1G 共享磁盘 asm-crs1/2/3

3 个 10G 共享磁盘 asm-data1-3（不安装 mgmt，如果安装则需要

再加单独 50G 盘）

/etc/hosts

/etc/hosts 内容:

127.0.0.1 localhost localhost.localdomain localhost4

localhost4.localdomain4

::1 localhost localhost.localdomain localhost6

localhost6.localdomain6

####orcl#####

#public

192.168.52.150 rac1

192.168.52.151 rac2

#vip

192.168.52.152 rac1-vip

192.168.52.153 rac2-vip

#priv

192.168.161.150 rac1-priv

192.168.161.151 rac2-priv

#scan

192.168.52.154 rac-scan

####dgorcl#####

#public

192.168.52.160 dgrac1

192.168.52.161 dgrac2

#vip

192.168.52.162 dgrac1-vip

192.168.52.163 dgrac2-vip

#priv

192.168.161.160 dgrac1-priv

192.168.161.161 dgrac2-priv

#scan

192.168.52.164 dgrac-scan

主库：

节点 1 节点 2

主机名

rac1 rac2

public ip 192.168.52.150 192.168.52.151

private ip 192.168.161.150 192.168.161.151

vip 192.168.52.152 192.168.52.153

scan-ip

192.168.161.154

数据库名

db_name orcl

db_unique_name orcl

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

4 PDBORCL READ WRITE NO

备库:

节点

主机名

dgrac1

dgrac2

public ip

192.168.52.160

192.168.52.161

private ip

192.168.161.162

192.168.161.163

vip

192.168.52.160

192.168.52.161

scan-ip 192.168.161.164

数据库名

db_name orcl

db_unique_name dgorcl

主库：生成参数

SQL> create pfile='/home/oracle/o.txt' from spfile;

File created.

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

orcl2.__data_transfer_cache_size=0

orcl1.__data_transfer_cache_size=0

orcl1.__db_cache_size=1644167168

orcl2.__db_cache_size=1677721600

orcl2.__inmemory_ext_roarea=0

orcl1.__inmemory_ext_roarea=0

orcl2.__inmemory_ext_rwarea=0

orcl1.__inmemory_ext_rwarea=0

orcl2.__java_pool_size=0

orcl1.__java_pool_size=0

orcl2.__large_pool_size=16777216

orcl1.__large_pool_size=16777216

orcl1.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment

orcl2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment

orcl2.__pga_aggregate_target=822083584

orcl1.__pga_aggregate_target=822083584

orcl2.__sga_target=2466250752

orcl1.__sga_target=2466250752

orcl2.__shared_io_pool_size=117440512

orcl1.__shared_io_pool_size=117440512

orcl1.__shared_pool_size=671088640

orcl2.__shared_pool_size=637534208

orcl2.__streams_pool_size=0

orcl1.__streams_pool_size=0

orcl2.__unified_pga_pool_size=0

orcl1.__unified_pga_pool_size=0

*.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'

*.db_recovery_file_dest_size=10737418240

*.db_recovery_file_dest='+DATA'

*.db_unique_name='orcl'

*.dg_broker_config_file1='+DATA/orcl/dr3orcl.dat'

*.dg_broker_config_file2='+DATA/orcl/dr4orcl.dat'

*.dg_broker_start=TRUE

*.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'

*.log_archive_dest_2=''

*.log_archive_dest_state_2='ENABLE'

*.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'

*.sga_target=2340m

*.standby_file_management='AUTO'

orcl2.thread=2

orcl1.thread=1

*.undo_tablespace='UNDOTBS1'

orcl2.undo_tablespace='UNDOTBS2'

orcl1.undo_tablespace='UNDOTBS1'

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

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

参数当中

备库：准备参数：

两个节点 oracle 用户执行：mkdir -p /oracle/app/oracle/admin/dgorcl/adump

*.adg_redirect_dml=TRUE

*.audit_file_dest='/oracle/app/oracle/admin/dgorcl/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'

*.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

*.local_listener='-oraagent-dummy-'

*.log_archive_config='nodg_config'

*.log_archive_dest_1='location=+DATA'

*.log_archive_dest_2=''

*.log_archive_dest_state_2='ENABLE'

*.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'

*.sga_target=2340m

*.standby_file_management='AUTO'

orcl2.thread=2

orcl1.thread=1

orcl2.undo_tablespace='UNDOTBS2'

orcl1.undo_tablespace='UNDOTBS1'

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

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

备库：启动

nomount

状态

[oracle@dgrac1 ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 6 11:22:31 2020

Version 19.5.0.0.0

SQL> conn /as sysdba

Connected to an idle instance.

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

ORACLE instance started.

Total System Global Area 2466250400 bytes

Fixed Size 9137824 bytes

Variable Size 603979776 bytes

Database Buffers 1845493760 bytes

Redo Buffers 7639040 bytes

剩余59页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

好记忆不如烂笔头abc

粉丝: 425
资源: 40

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

oracle19c cdb rac to rac adg部署20200307.pdf

Oracle19c RAC+ RACDG配置详细部署文档

阿里云ECS环境下CentOS-linux 7.6系统Oracle 19C RAC双节点集群安装部署-优化-维护手册.pdf

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

Oracle 19c CDB RAC to RAC for Active Dataguard部署

构建最高可用Oracle数据库系统 RAC和ADG环境搭建文档

Oracle 19c rac+adg.docx

Linux 7.7 平台 Oracle 19.3 物理Data Guard 搭建手册.pdf

（绝对干货）Oracle ADG数据库完整部署、切换、备份、运维手册

19c_dg单实例搭建.txt

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

ORACLE 19C RAC 搭建部署（全网最详细）

Redhat7.6 Oracle 19C RAC部署手册

RHEL 8.4 安装Oracle 19c RAC+RU 19.13 文档.docx

CentOS7.5+Oracle 19c+RAC.pdf

CentOS 7.8 Oracle 19C RAC安装部署

Oracle19c RAC for Centos7.6最详细安装文档.pdf

rac+单实例adg搭建步骤

(可参考)ORACLE 12C DATAGUARD环境搭建和主从切换.docx

【ADG】12c cdb,pdb Datagard 搭建（rac to 单节点）.pdf

可刷新的PDB(PDB Refresh)_ITPUB博客.mhtml

oracle 19c rac install on linux7.pdf

在Linux7.9环境下Oracle 19C RAC集群详细安装部署文档.pdf

oracle 19c-rac-OEL7.9

Centos8安装Oracle 19C RAC超级手册

在CentOS7.3下搭建oracle 19c rac详细步骤

Oracle 19c 19.1.0.4+ogg搭建完美手册

Oracle 19C+13.4EMCC-oem部署和配置（含脚本）

Oracle udev 19c静默安装

最新资源