ADG系列之oracle rac到单机的ADG环境搭建

地址规划：RAC： 1.1.1.62 rac5-vip 1.1.1.64 rac6-vipdb_name hxzgdb_unique_name hxzg
rac5-dg 1.1.1.68db_name hxzgdb_unique_name hxzgdg归档路径:/archivelog数据文件路径：/oradata/hxzg/
一、基本环境准备1、确认机器为归档模式archive log list2、开启主库的force logging
alter database force logging;二、主库的操作2.1修改参数alter database force logging;alter system set log_archive_config=’dg_config=(hxzg,hxzgdg)’ scope=both;alter system set log_archive_dest_1=’location=+archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=hxzg’;alter system set LOG_ARCHIVE_DEST_2=’SERVICE=hxzgdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=hxzgdg’ scope=both; alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=both; alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=both; alter system set FAL_SERVER=hxzgdg scope=both; alter system set FAL_CLIENT=hxzg1 scope=both; alter system set STANDBY_FILE_MANAGEMENT=auto scope=both; 2.2 同步口令文件略
三、配置网络
tns配置节点1/2/备库的tnsnames.ora文件下添加如下内容：

hxzg1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.62)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.63)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hxzg) ) )
hxzgdg = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.68)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hxzgdg) ) )2、配置备库的listenerSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = prod) (ORACLE_HOME = /oracle/app/db) (SID_NAME = hxzgdg) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.68)(PORT = 1521)) ) )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
四、备库参数配置
获取主库的参数，在此基础上进行修改*.audit_file_dest=’/oracle/app/oracle/admin/hxzg/adump’*.audit_trail=’db’*.cluster_database=false*.compatible=’11.2.0.4.0’*.control_files=’/oradata/hxzg/control01.ctl’*.db_block_size=8192*.db_create_file_dest=’/oradata/hxzg/’*.db_domain=”*.db_name=’hxzg’db_unique_name=’hxzgdg’*.db_recovery_file_dest_size=4621074432*.diagnostic_dest=’/oracle/app/oracle’*.fal_client=’HXZGDG’*.fal_server=’HXZG1’*.log_archive_config=’dg_config=(hxzg,hxzgdg)’*.log_archive_dest_1=’location=/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=hxzgdg’*.log_archive_dest_2=’SERVICE=hxzg1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=hxzg’*.log_archive_dest_state_1=’ENABLE’*.log_archive_dest_state_2=’ENABLE’*.memory_target=1200m*.open_cursors=300*.processes=150*.remote_login_passwordfile=’exclusive’*.standby_file_management=’AUTO’*.undo_tablespace=’UNDOTBS1′

–创建目录mkdir -p /oracle/app/oracle/admin/hxzg/adumpmkdir -p /oradata/hxzg
五、初始化数据库在主库上执行备份动作run{allocate channel ch2 type disk maxpiecesize =5120M;allocate channel ch3 type disk maxpiecesize =5120M;all免费云主机域名ocate channel ch4 type disk maxpiecesize =5120M;allocate channel ch5 type disk maxpiecesize =5120M;backupAS COMPRESSED BACKUPSETdatabase filesperset 10 format ‘/backup/%d_DF_%T_%s_%p.bak’;backup AS COMPRESSED BACKUPSETarchivelog all format ‘/backup/%d_ARC_%T_%s_%p.bak’;backup format ‘/backup/ctrl_%d_%T_%s’current controlfile for standby;backup spfile format ‘/backup/spfile_%d_%T_%s’;release channel ch2;release channel ch3;release channel ch4;release channel ch5;}
2、在备库上进行还原RMAN> restore standby controlfile from ‘/backup/ctrl_HXZG_20171108_40’;
RMAN>run{set newname for database to ‘/oradata/hxzg/%b’;restore database;switch datafile all;}

3、创建standbylogfilealter database add standby logfile thread 1 group 5 (‘/oradata/hxzg/st_1_logfile5’) size 50M;alter database add standby logfile thread 1 group 6 (‘/oradata/hxzg/st_1_logfile6’) size 50M;alter database add standby logfile thread 1 group 7 (‘/oradata/hxzg/st_1_logfile7’) size 50M;alter database add standby logfile thread 1 group 11 (‘/oradata/hxzg/st_1_logfile11’) size 50M;

alter database add standby logfile thread 2 group 8 (‘/oradata/hxzg/st_2_logfile8’) size 50M;alter database add standby logfile thread 2 group 9 (‘/oradata/hxzg/st_2_logfile9’) size 50M;alter database add standby logfile thread 2 group 10 (‘/oradata/hxzg/st_2_logfile10’) size 50M;alter database add standby logfile thread 1 group 12 (‘/oradata/hxzg/st_2_logfile12’) size 50M;

启动mrpalter database recover mananged standby database using current logfile disconnect from session;七、相关检查
1 在主库上检查第二归档终点是否正常select name,status,error from v$archive_dest;

相关推荐: 微信”交通卡”1分钱出行，全国近200个城市上线，有你的城市吗

近日迎来了微信与支付宝的新一轮碰撞，微信上线交通卡功能，我们只需要使用用交通卡功能，就能选择多个城市的电子交通卡，让我们再也不用从众多小程序中挑选了，这样我们刷微信乘车，才算的上是真的便免费云主机域名捷。当然了除了便捷，以下城市微信还同时上线了低至1分钱出行活…