rac-db配置ADG -清零世界

bubuko 2022/1/25 20:09:03 其他字数 6567 阅读 853 0 来源 http://www.bubuko.com/infolist-5-1.html

target: 192.168.31.16(rac01)/192.168.31.17(rac02)  sid=orcl  unique_name=orcl services_name=orcl1/orcl2
auxilary: 192.168.31.118  sid=orcldg  services_name=orcldg   unique_name=orcldg
#target端配置

alter system set log_archive_dest=‘+ARCH‘ scope=both sid=‘*‘;
alter system set log_archive_dest_2=‘service=NET_ORCLDG LGWR ASYNC valid_for=(online_logfiles,primary_role) db_unique_name=orcldg‘ scope=both sid=‘*‘;
alter system set log_archive_config=‘dg_config=(orcl,orcldg)‘ scope=both sid=‘*‘;
alter system set fal_client=net_orcl scope=both sid=‘*‘;
alter system set fal_server=net_orcldg scope=both sid=‘*‘;


##auxiliary配置
1. 复制target端密码文件到$ORACLE_HOME/dbs/目录,并更改为orapworcldg
2. 创建initorcldg.ora参数文件,包含如下2行
　　　　unique_name=orcldg
       db_name=orcldg
3. 开启一个新终端,开启监听(需要提前配置好静态监听);在当前终端启动数据库到nomount状态后退出终端
4. 在第三步的终端下输入 rman target sys/oracle@NET_ORCL auxiliary sys/oracle@NET_ORCLDG 
5. 执行下面命令
run {
duplicate target database for standby from active database
spfile
  parameter_value_convert ‘/u01/app/oracle‘,‘/opt/oracle‘
  set diagnostic_dest=‘/opt/oracle‘
  set audit_file_dest=‘/opt/oracle‘
  set core_dump_dest=‘/opt/oracle‘
  set undo_tablespace=‘undotbs1‘
  set db_name=‘orcl‘
  set ‘db_unique_name‘=‘orcldg‘
  set log_file_name_convert ‘+DATA/orcl/onlinelog‘,‘/opt/oracle/flash_recovery_area‘
  set db_file_name_convert ‘+DATA/orcl/datafile‘,‘/opt/oracle/oradata‘,‘+DATA/orcl/tempfile‘,‘/opt/oracle/oradata‘
  set control_files=‘/opt/oracle/oradata/control01.ctl‘,‘/opt/oracle/oradata/control02.ctl‘
  set log_archive_dest_1=‘LOCATION=/opt/oracle/flash_recovery_area‘
  set log_archive_dest_2=‘service=NET_ORCL LGWR ASYNC valid_for=(online_logfiles,primary_role) db_unique_name=orcl‘
  set fal_client=‘NET_ORCLDG‘
  set fal_server=‘NET_ORCL‘
  set cluster_database=‘FALSE‘
  set standby_file_management=‘AUTO‘
  set remote_login_passwordfile=‘exclusive‘
  set db_create_file_dest=‘‘
  set db_recovery_file_dest=‘‘
  set remote_listener=‘‘
  set local_listener=‘‘
  NOFILENAMECHECK
  ;
}
6. 数据库会自动从target端复制,并打开数据库到mount状态.
7. 创建standby日志文件,需要比RAC双节点日志组多2个
8. 打开数据库alter database open;
9. 执行实时应用 alter database recover managed standby database using current logfile disconnect from session;

测试:
target端创建表空间,去到auxiliary端查看表空间是否同步,或者查看日志文件adrci---show alert---1

rac-db配置ADG

原文：https://www.cnblogs.com/vmsysjack/p/12391024.html

如果您也喜欢它,动动您的小指点个赞吧

rac-db配置ADG

分类汇总

您的鼓励是对我最大的支持