RAC环境下DataGuard到单机

环境描述：Oracle Version:11.2.0.3.0
Primary端：
双节点的RAC,scan使用DNS解析,跑两个实例（JSTDB&PAYDB）
Standby端：
单机的Dataguard1.设置网络环境;
vi /etc/hosts
192.168.253.101 rac1.test.com rac1
192.168.253.102 rac2.test.com rac2
192.168.253.103 rac1-vip.test.com rac1-vip
192.168.253.104 rac2-vip.test.com rac2-vip
10.10.10.11 rac1-priv.test.com rac1-priv
10.10.10.12 rac2-priv.test.com rac2-priv
192.168.253.200 standby
vi /etc/resolv.conf
nameserver 192.168.253.100nslookup scan.test.com
Server:192.168.253.100
Address:192.168.253.100#53
Name:scan.test.com
Address: 192.168.253.107
Name:scan.test.com
Address: 192.168.253.106
Name:scan.test.com
Address: 192.168.253.105
2.修改force logging;
select force_logging from v$database;
alter database force logging; --------------------------------------分割线 --------------------------------------Oracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle Data Guard 重要配置参数 http://www.linuxidc.com/Linux/2013-08/88784.htm基于同一主机配置 Oracle 11g Data Guard http://www.linuxidc.com/Linux/2013-08/88848.htm探索Oracle之11g DataGuard http://www.linuxidc.com/Linux/2013-08/88692.htmOracle Data Guard （RAC+DG）归档删除策略及脚本 http://www.linuxidc.com/Linux/2013-07/87782.htmOracle Data Guard 的角色转换 http://www.linuxidc.com/Linux/2013-06/86190.htmOracle Data Guard的日志FAL gap问题 http://www.linuxidc.com/Linux/2013-04/82561.htmOracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法 http://www.linuxidc.com/Linux/2013-03/82009.htm--------------------------------------分割线 --------------------------------------3.查看并添加standby logfile;
set line 180 pages 1000
col member for a50
select * from v$logfile order by GROUP#;
alter system set standby_file_management=manual scope=both sid="*";
alter database add standby logfile thread 1 group 5 "+DATA/jstdb/onlinelog/standby_redo1-1.log" size 50M;
alter database add standby logfile thread 1 group 6 "+DATA/jstdb/onlinelog/standby_redo1-2.log" size 50M;
alter database add standby logfile thread 1 group 7 "+DATA/jstdb/onlinelog/standby_redo1-3.log" size 50M;
alter database add standby logfile thread 1 group 8 "+DATA/jstdb/onlinelog/standby_redo1-4.log" size 50M;
alter database add standby logfile thread 2 group 9 "+DATA/jstdb/onlinelog/standby_redo2-1.log" size 50M;
alter database add standby logfile thread 2 group 10 "+DATA/jstdb/onlinelog/standby_redo2-2.log" size 50M;
alter database add standby logfile thread 2 group 11 "+DATA/jstdb/onlinelog/standby_redo2-3.log" size 50M;
alter database add standby logfile thread 2 group 12 "+DATA/jstdb/onlinelog/standby_redo2-4.log" size 50M;
alter system set standby_file_management=auto scope=both sid="*"; 4.收集主库的相关信息;
set line 180 pages 1000
col value for a90
col name for a50
select name,value from v$parameter
where name in （"db_name",
"db_unique_name",
"log_archive_config",
"log_archive_dest_1",
"log_archive_dest_2",
"log_archive_dest_state_1",
"log_archive_dest_state_2",
"remote_login_passwordfile",
"remote_listener",
"log_archive_format",
"log_archive_max_processes",
"fal_server","fal_client",
"db_file_name_convert",
"log_file_name_convert",
"standby_file_management"）; 5.创建本地硬盘的归档日志目录以及rman的备份目录;
mkdir -p /u01/arch/JSTDB
chown -R oracle.oinstall /u01/arch/
mkdir -p /u01/rman/JSTDB
chown -R oracle.oinstall /u01/rman/6.修改主库的DG配置;
ALTER SYSTEM SET DB_UNIQUE_NAME=JSTDB scope=both sid="*";
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG="DG_CONFIG=（JSTDB,JSTDG1）" scope=both sid="*";
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1="LOCATION=+FRA/JSTDB/ARCHIVELOG/ VALID_FOR=（ALL_LOGFILES,ALL_ROLES） DB_UNIQUE_NAME=JSTDB" scope=both sid="*";
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2="SERVICE=JSTDG1 LGWR ASYNC VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=JSTDG1" scope=both sid="*";
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=both sid="*";
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=both sid="*";
ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=SHARED scope=spfile sid="*";
ALTER SYSTEM SET REMOTE_LISTENER="scan.test.com:1521" scope=spfile sid="*";
ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=8 SCOPE=both sid="*";
ALTER SYSTEM SET FAL_CLIENT=JSTDB SCOPE=both sid="*";
ALTER SYSTEM SET FAL_SERVER=JSTDG1 SCOPE=both sid="*";
ALTER SYSTEM SET db_file_name_convert="/u01/app/oracle/oradata/JSTDG1/","+DATA/JSTDB/" SCOPE=spfile sid="*";
ALTER SYSTEM SET log_file_name_convert="/u01/app/oracle/oradata/JSTDG1/onlinelog/","+DATA/JSTDB/onlinelog/","/u01/app/oracle/oradata/JSTDG1/onlinelog/","+FRA/JSTDB/onlinelog/","/u01/arch/JSTDG1/","+FRA/JSTDB/ARCHIVELOG/" SCOPE=spfile sid="*";
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=both sid="*"; 修改archivelog的格式
alter system set log_archive_format="arch_%r_%t_%s.arc" scope=spfile sid="*";
shutdown immediate
startup 7.创建standby数据库的pfile文件;
create pfile="/u01/rman/initJSTDB.ora" from spfile; 8.修改tns;
cd $ORACLE_HOME/network/admin
vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
JSTDB =
（DESCRIPTION =
（ADDRESS_LIST =
（ADDRESS = （PROTOCOL = TCP）（HOST = scan.test.com）（PORT = 1521））
（LOAD_BALANCE = yes）
）
（CONNECT_DATA =
（SERVER = DEDICATED）
（SERVICE_NAME = JSTDB）
）
）
JSTDB1 =
（DESCRIPTION =
（ADDRESS_LIST =
（ADDRESS = （PROTOCOL = TCP）（HOST = rac1.test.com）（PORT = 1521））
（ADDRESS = （PROTOCOL = TCP）（HOST = rac1-vip.test.com）（PORT = 1521））
）
（CONNECT_DATA =
（SERVICE_NAME = JSTDB）
（INSTANCE_NAME = JSTDB1）
）
）
JSTDB2 =
（DESCRIPTION =
（ADDRESS_LIST =
（ADDRESS = （PROTOCOL = TCP）（HOST = rac2.test.com）（PORT = 1521））
（ADDRESS = （PROTOCOL = TCP）（HOST = rac2-vip.test.com）（PORT = 1521））
）
（CONNECT_DATA =
（SERVICE_NAME = JSTDB）
（INSTANCE_NAME = JSTDB2））
）
JSTDG1 =
（DESCRIPTION =
（ADDRESS_LIST =
（ADDRESS = （PROTOCOL = TCP）（HOST = standby）（PORT = 1521））
）
（CONNECT_DATA =
（SERVER = DEDICATED）
（SERVICE_NAME = JSTDG1）
）
）
PAYDB =
（DESCRIPTION =
（ADDRESS_LIST =
（ADDRESS = （PROTOCOL = TCP）（HOST = scan.test.com）（PORT = 1521））
（LOAD_BALANCE = yes）
）
（CONNECT_DATA =
（SERVER = DEDICATED）
（SERVICE_NAME = PAYDB）
）
）
PAYDG1 =
（DESCRIPTION =
（ADDRESS_LIST =
（ADDRESS = （PROTOCOL = TCP）（HOST = standby）（PORT = 1521））
）
（CONNECT_DATA =
（SERVER = DEDICATED）
（SERVICE_NAME = PAYDB）
）
）
9.备库添加监听;cd $ORACLE_HOME/network/admin
vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
（DESCRIPTION_LIST =
（DESCRIPTION =
（ADDRESS = （PROTOCOL = TCP）（HOST = standby）（PORT = 1521））
（ADDRESS = （PROTOCOL = IPC）（KEY = EXTPROC1521））
）
）
SID_LIST_LISTENER =
（SID_LIST =
（SID_DESC =
（GLOBAL_DBNAME = JSTDG1）
（ORACLE_HOME = /u01/app/oracle）
（SID_NAME = JSTDB）
）
（SID_DESC =
（GLOBAL_DBNAME = PAYDG1）
（ORACLE_HOME = /u01/app/oracle）
（SID_NAME = PAYDB）
）
）
ADR_BASE_LISTENER = /u01/app/oracle
备库重启监听服务
lsnrctl stop
lsnrctl start
10.在RAC节点1生成standby控制文件;
export ORACLE_SID=JSTDB1
rman target /
backup device type disk format "/u01/rman/ctl01.ctl" current controlfile for standby; scp /u01/rman/ctl01.ctl standby:/u01/rman/
11.在standby创建相关目录;
@root用户
mkdir -p /u01/rman/JSTDB
chown -R oracle.oinstall /u01/rman/
mkdir -p /u01/arch/JSTDG1
chown -R oracle.oinstall /u01/arch/
@oracle用户
mkdir -p /u01/app/oracle/oradata/JSTDG1/datafile/
mkdir -p /u01/app/oracle/oradata/JSTDG1/onlinelog
mkdir -p /u01/app/oracle/admin/JSTDG1/adump
12.复制密码文件;orapwd file=/$ORACLE_HOME/dbs/orapwJSTDB1 password=oracle force=y ignorecase=y
scp /$ORACLE_HOME/dbs/orapwJSTDB1 rac2:/$ORACLE_HOME/dbs/orapwJSTDB2
scp /$ORACLE_HOME/dbs/orapwJSTDB1 standby:/u01/app/oracle/dbs/orapwJSTDB
13.拷贝参数文件到备库，并修改相关内容;
@主库
scp /u01/rman/initJSTDB.ora standby:/u01/app/oracle/dbs/initJSTDB.ora
@备库
vi /u01/app/oracle/dbs/initJSTDB.ora
*.audit_file_dest="/u01/app/oracle/admin/JSTDG1/adump"
*.audit_trail="db"
*.compatible="11.2.0.0.0"*.control_files="/u01/app/oracle/oradata/JSTDG1/control01.ctl","/u01/app/oracle/oradata/JSTDG1/control02.ctl","/u01/app/oracle/oradata/JSTDG1/control03.ctl"
*.db_block_size=8192
#*.db_create_file_dest="/u01/app/oracle/oradata/"
#*.db_create_online_log_dest_1="/u01/app/oracle/oradata/onlinelog/"
*.db_domain=""
*.db_file_name_convert="+DATA/JSTDB/","/u01/app/oracle/oradata/JSTDG1/"
*.db_name="JSTDB"
*.db_unique_name="JSTDG1"
*.db_recovery_file_dest=""
*.fal_client="JSTDG1"
*.fal_server="JSTDB"
*.log_archive_config="DG_CONFIG=（JSTDB,JSTDG1）"
*.log_archive_dest_1="LOCATION=/u01/arch/JSTDG1/ VALID_FOR=（ALL_LOGFILES,ALL_ROLES） DB_UNIQUE_NAME=JSTDG1"
*.log_archive_dest_2="SERVICE=JSTDB LGWR ASYNC VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=JSTDB"
*.log_archive_format="arch_%r_%t_%s.arc"
*.log_archive_dest_state_1="ENABLE"
*.log_archive_dest_state_2="ENABLE"
*.log_archive_max_processes=8
*.log_file_name_convert="+DATA/JSTDB/onlinelog/","/u01/app/oracle/oradata/JSTDG1/onlinelog/","+FRA/JSTDB/onlinelog/","/u01/app/oracle/oradata/JSTDG1/onlinelog/","+FRA/JSTDB/ARCHIVELOG/","/u01/arch/JSTDG1/"
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile="SHARED"
*.standby_file_management="AUTO"
*.undo_management="AUTO"
undo_tablespace="UNDOTBS1"
14.把备库启动到nomount状态;
export ORACLE_SID=JSTDB
sqlplus / as sysdba
startup nomount pfile="/u01/app/oracle/dbs/initJSTDB.ora";
create spfile from pfile="/u01/app/oracle/dbs/initJSTDB.ora"; 15.恢复备库的控制文件;
rman target /
restore standby controlfile from "/u01/rman/ctl01.ctl"; 16.收集RAC数据库的信息;col file_name for a70
select file_name, file_id from dba_data_files; FILE_NAME FILE_ID
---------------------------------------------------------------------- ----------
+DATA/jstdb/datafile/system.259.9079385031
+DATA/jstdb/datafile/sysaux.260.9079385092
+DATA/jstdb/datafile/undotbs1.261.9079385153
+DATA/jstdb/datafile/undotbs2.263.9079385254
+DATA/jstdb/datafile/users.264.9079385275
4 rows selected.17.备份主库全库（仅供保险备份，不是拷贝到standby）;
rman target /backup format "/u01/rman/JSTDB/fulldb_%d_%U" database include current controlfile plus archivelog delete input; 更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2016-04/129939p2.htm

CentOS 下设置 Oracle 外网访问CentOS 7使用yum安装MySQL 5.6.24相关资讯 DataGuard RAC环境

分析解决11gR2 双节点RAC环境下的（06月26日）
MRP0- Background Media Recovery （04月16日）
Oracle 11G R2 DataGuard日常维护（02月20日）

DataGuard如何传送Redo到Standby （05月04日）
DataGuard环境中的密码维护（03月17日）
Oracle 11G R2利用RMAN搭建（02月20日）

本文评论查看全部评论（0）