当前位置:Oracle研究中心 > 产品DBA > Oracle DG >
时间:2016-04-09 22:23 来源:Oracle研究中心 作者:惜分飞 点击: 次
Oracle 11G RDBMS主库tnsnames.ora配置
在主备库的数据库的tns中均增加如下配置
q9dbdg = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = q9db01-dg-vip)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = q9db02-dg-vip)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = q9db) ) ) q9adgdg = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = q9adg01-dg-vip)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = q9adg02-dg-vip)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = q9db) ) )
Oracle11G RAC主库修改参数配置
alter system set DB_UNIQUE_NAME=q9db scope=spfile; alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(q9db,q9db_adg)' scope=both; alter system set LOG_ARCHIVE_DEST_1='LOCATION=+arch/q9db/ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=q9db' scope=both; alter system set LOG_ARCHIVE_DEST_2='SERVICE=q9adg1dg LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=q9db_adg'; alter system set standby_file_management='AUTO' sid='*' scope=both; alter system set fal_client='q9dbdg'; alter system set fal_server='q9adgdg'; alter system set db_file_name_convert='+DATA','+DATA' SCOPE=SPFILE; ALTER SYSTEM SET log_file_name_convert='+DATA','+DATA' SCOPE=SPFILE;
Oracle11G RAC备库修改参数配置
alter system set DB_UNIQUE_NAME=q9db_adg scope=spfile; alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(q9db,q9db_adg)' scope=both; alter system set LOG_ARCHIVE_DEST_1='LOCATION=+arch/q9db/ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=q9db_adg'; alter system set LOG_ARCHIVE_DEST_2='SERVICE=q9db1dg LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=q9db'; alter system set standby_file_management='AUTO' sid='*' scope=both; alter system set fal_client='q9adgdg'; alter system set fal_server='q9dbdg'; alter system set service_names='q9db'; alter system set db_file_name_convert='+DATA','+DATA' SCOPE=SPFILE; ALTER SYSTEM SET log_file_name_convert='+DATA','+DATA' SCOPE=SPFILE;
Oracle11G RAC主库增加standby redo log
alter database add standby logfile THREAD 1 group 51 '+DATA' size 512m; ………… alter database add standby logfile THREAD 1 group 61 '+DATA' size 512m; alter database add standby logfile THREAD 2 group 71 '+DATA' size 512m; ………… alter database add standby logfile THREAD 2 group 81 '+DATA' size 512m;
Oracle11G RAC主库修改强制日志
SQL> ALTER DATABASE FROCE LOGGING;
Oracle研究中心进行RMAN备份主库
rman target / run{ configure device type disk parallelism 16; backup database filesperset = 10 format '/q9bak/df_%U'; backup current controlfile format '/q9bak/ctl_%U'; }
创建standby controlfile
ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/q9bak/stb_ctl';
还原standby controlfile
ASMCMD> cp /q9bak/stb_ctl control01.ctl copying /q9bak/stb_ctl -> +data/Q9DB/control01.ctl ASMCMD> cp /q9bak/stb_ctl control02.ctl copying /q9bak/stb_ctl -> +arch/q9db/control02.ctl
Oracle研究中心进行还原备库
SQL>startup mount; rman target / nocatalog <Oracle11G RAC环境TO RAC+ADG主备库切换过程+日志问题分析:http://www.oracleplus.net/arch/oracle-20160409-71.html修改备库文件名
RMAN>catalog start with '+DATA/Q9DB/DATAFILE/'; RMAN> switch database to copy; 清理REDO--清理redo(所有的group#) SQL> select group# from v$log; SQL> alter database clear logfile group 1; …… --清理standby redo(所有的group#) SQL> select group# from v$standby_log; SQL> alter database clear logfile group 51; …… 开启Oracle11G ADG备库归档实时应用模式SQL> alter database recover managed standby database using current logfile disconnect from session; Oracle11G ADG备库注册DB服务(使用Oracle用户)srvctl add database -d q9db_adg -o $ORACLE_HOME srvctl add instance -d q9db_adg -i q9db1 -n q9adg01 srvctl add instance -d q9db_adg -i q9db2 -n q9adg02 srvctl modify database -d q9db_adg -a DATA,ARCH 至此Oracle 11G RAC TO 11G RAC ADG配置工具完成
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之案例:Oracle11G RAC TO 11G RAC ADG详细配置 精华干货
本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/72.html
Powered by Oracle研究中心 OraclePlus Inc.
BY DedeCMS 京ICP备14022373号-5
声明:Oracle研究中心部分文章源自互联网,转载均按原文作者要求转载,如有疑问联系QQ:1026002015,协商未果24小时删除。