说明：
双节点RAC-->单实例DG

一、修改主库配置

（在线修改即可 ）
主库（(双节点RAC)）：
alter system set log_archive_config='dg_config=(orcl,orclpdg)' scope=both;
alter system set log_archive_dest_1='location=/arch/orcl1/arch valid_for=(all_logfiles,all_roles) db_unique_name=orcl' sid='orcl1' scope=both;
alter system set log_archive_dest_1='location=/arch/orcl2/arch valid_for=(all_logfiles,all_roles) db_unique_name=orcl' sid='orcl2' scope=both;
alter system set log_archive_dest_2='service=orclpdg ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=orclpdg' scope=both;
alter system set log_archive_dest_state_2='enable' scope=both;
alter system set STANDBY_FILE_MANAGEMENT=AUTO scope=both;
附件参数（只有主库变成备库时才使用）
alter system set db_file_name_convert='/u01/app/oracle/oradata/orcl/','+DATA/orcl/datafile/' scope=spfile;
alter system set LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl/','+DATA/orcl/onlinelog/' scope=spfile;
alter system set FAL_SERVER=orclpdg scope=both;

在tnsnames.ora增加连接到从库的TNS
cat >> $ORACLE_HOME/network/admin/tnsnames.ora << EOF
orclpdg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EOF

二、配置从库

从库：单实例DG

修改参数文件(只能手工修改参数文件 )
db_unique_name=orclpdg
service_names=orcl

修改参数 （这些参数可以使用命令修改spfile ）
alter system set log_archive_config='dg_config=(orcl,orclpdg)' scope=spfile;
alter system set log_archive_dest_1='location=/arch/orcl/recive valid_for=(all_logfiles,all_roles) db_unique_name=orclpdg' scope=spfile;
alter system set log_archive_dest_2='service=orclpri ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=orcl' scope=spfile;
alter system set log_archive_dest_state_2='enable' scope=spfile;
alter system set STANDBY_FILE_MANAGEMENT=AUTO scope=spfile;
alter system set DB_FILES=800 scope=spfile;
alter system set db_file_name_convert='+DATA/orcl/datafile/','/u01/app/oracle/oradata/orcl/','+DATA/orcl/tempfile/','/u01/app/oracle/oradata/orcl/' scope=spfile;
alter system set LOG_FILE_NAME_CONVERT='+DATA/orcl/onlinelog/','/u02/app/oracle/oradata/orcl/','+DATA/mm100/standbylog/','/u02/app/oracle/oradata/orcl/' scope=spfile;
alter system set FAL_SERVER=orclpri scope=spfile;

创建接收主库传过来的 归档日志 目录
mkdir -p /arch/orcl/recive
chown oracle.oinstall -R /arch

创建静态监听器
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

配置TNS连接
su - oracle
cat >> $ORACLE_HOME/network/admin/tnsnames.ora << EOF
orclpri=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.166)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

orclpdg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EOF

从主库复制密码文件到从库：
scp 192.168.1.17:/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl1 /u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl

主库：
rman target sys/password@orclpri auxiliary sys/BV3792Ty64@orclpdg nocatalog <<eof
duplicate target database for standby from active database nofilenamecheck;
EOF

从库执行应用日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

定期删除日志：
[root@s001pm: script]# more del_arch_standby.sh

点击( 此处 )折叠或打开

#!/bin/bash
cd /home/oracle/script/
rm -rf /home/oracle/script/del_arch_standby.txt
source /home/oracle/.bash_profile
sqlplus -s sys/xxx123 AS SYSDBA <<eof</eof<>
set linesize 200
set pagesize 0
set echo off
set feedback off
set trimspool on
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
spool del_arch_standby.txt
select 'rm -rf ' || t.NAME as name
from v\$archived_log t
where t.APPLIED = 'YES'
and t.FIRST_TIME < sysdate - 4 / 24
and NAME like '/arch/orcl/%'
order by t.first_time desc;
spool off
exit
EOF
cd /home/oracle/script/
sh del_arch_standby.txt

</eof

ITPub博客

ORACLE 11G 创建 DATAGUARD(双节点RAC-->单实例DG)

一、修改主库配置

二、配置从库

最新文章