Oracle 19c RAC集群ADG搭建

1、将主库的pfile和passwdfile发送到备库

#主库一节点操作
scp -P1234 /tmp/pfile2025.ora  bak_ip:/home/oracle
sco -P1234 /oracle/app/oracle/product/19.0.0/db/dbs/orapw$ORACLE_SID bak_ip:/oracle/app/oracle/product/19.0.0/db/dbs

2、备库修改参数文件成standby相关环境并启动到nomount状态，创建审计目录

#备库一节点操作
#在参数文件中添加如下内容
vi /home/oracle/pfile2025.ora
*.db_file_name_convert='+DATA','+DATA'
*.log_file_name_convert='+REDO01','+REDO01','+REDO02','+REDO02'
*.fal_client='bbdb'
*.fal_server='bbdb_dg'
*.log_archive_config='DG_CONFIG=(bbdb,bbdb_dg)'
*.log_archive_dest_1='LOCATION=+ARCH VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bbdb'
*.log_archive_dest_2='SERVICE=bbdb_dg lgwr async valid_for=(online_logfiles,primary_role) DB_UNIQUE_NAME=bbdb_dg'
*.standby_file_management='AUTO'
*.db_name='bbdb'
*.service_names='bbdb'
*.DB_UNIQUE_NAME='bbdb'
#192.168.137.3/4为备库VIP
bbdb1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.137.3)(PORT=1521))'
bbdb2.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.137.4)(PORT=1521))'#创建审计目录
su - oracle
mkdir -p /oracle/app/oracle/admin/bbdb/adump#启动主库一节点参数文件
su - oracle
export ORACLE_SID=bbdb
sqlplus / as sysdba
startup nomount pfile='/home/oracle/pfile2025.ora'

3、在备库一节点增加静态监听

su - grid
cd $ORACLE_HOME/network/admin
vi listener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=bbdb)(SID_NAME=bbdb1)			(ORACLE_HOME=/oracle/app/oracle/product/19.0.0/db)			))

4、主库备库所有节点都配置tns

su - oracle
cd $ORACLE_HOME/network/admin
cp tnsnames.ora tnsnames.ora_2025
vi tnsnames.oraBBDB =(DESCRIPTION =#备库物理IP、VIP及scan IP(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.3)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.4)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.5)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = bbdb)))BBDB-DG =(DESCRIPTION =#主库物理IP、VIP及scan IP(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.138.1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.138.2)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.138.3)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.138.4)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.138.5)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = bbdb-dg)))

5、在备库一节点开始复制

su - oracle
rman target sys/'xxxx'@bbdb-dg auxiliary sys/'xxxx'@bbdb
duplicate target database for standby from active database;

6、在备库一节点开启日志应用

#待复制结束后执行
su - oracle
sqlplus / as sysdba
alter database recover managed standby database parallel 8 using current logfile disconnect from session;

7、启动备库二节点

su - oracle
sqlplus / as sysdba
startup

8、检查备份状态

#主库一节点
select max(sequence#) , thread# from gv$archived_log group by thread#;#备库一节点
select max(sequence#) , thread# from gv$archived_log group by thread#;
select max(sequence#) from v$managed_standby;