說明：
雙節點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

ORACLE 11G 建立 DATAGUARD(雙節點RAC-->單例項DG)

一、修改主庫配置

二、配置從庫

相關文章