RAC+DG的环境搭建部署（第四篇)
【转载声明】本文为转载文章，原作者「李华荣」，版权归原作者所有。 原文链接：https://mp.weixin.qq.com/s/UoZzdknUfxJv25HNFXrvAA
公众号：杨建荣的学习笔记 · 作者：李华荣 · 发布：2016-02-26 23:27:48 · 原文链接
1.1.1 将备库加入crsctl中
dbca创建的数据库会自动加入crsctl中，但通过rman创建的库不会加入crsctl中，需要手动添加，将备库加入crsctl中后可以通过srvctl来管理数据库了。
[ZFXXX2:oracle]:/oracle>echo$ORACLE_HOME
/oracle/app/oracle/product/11.2.0/db
[ZFXXX2:oracle]:/oracle>srvctl add database -d TESTDGPHY -c RAC -o/oracle/app/oracle/product/11.2.0/db -p ‘+DATA/TESTDGPHY/PARAMETERFILE/spfiledgphy.ora’-r physical_standby -n TESTDG -i DGPHY
[ZFXXX2:oracle]:/oracle>
[ZFXXX2:oracle]:/oracle>srvctl add instance -d TESTDGPHY -i DGPHY1 -n ZFXXX1
[ZFXXX2:oracle]:/oracle>srvctl add instance -d TESTDGPHY -i DGPHY2 -n ZFXXX2
[ZFXXX2:oracle]:/oracle>srvctlstatus database -d TESTDGPHY
InstanceDGPHY1 is not running on node zfXXX1
InstanceDGPHY2 is not running on node zfXXX2
[ZFXXX2:oracle]:/oracle>srvctl start database -d TESTDGPHY
[ZFXXX2:oracle]:/oracle>srvctlstatus database -d TESTDGPHY
InstanceDGPHY1 is running on node zfXXX1
InstanceDGPHY2 is running on node zfXXX2
[ZFXXX2:oracle]:/oracle>srvctl config database -d TESTDGPHY -a
Databaseunique name: TESTDGPHY
Databasename: TESTDG
Oraclehome: /oracle/app/oracle/product/11.2.0/db
Oracleuser: oracle
Spfile:+DATA/TESTDGPHY/PARAMETERFILE/spfiledgphy.ora
Domain:
Startoptions: open
Stopoptions: immediate
Databaserole: PHYSICAL_STANDBY
Managementpolicy: AUTOMATIC
Serverpools: DGPHY
Databaseinstances: DGPHY1,DGPHY2
DiskGroups:
Mountpoint paths:
Services:
Type:RAC
Databaseis enabled
Databaseis administrator managed
[ZFXXX2:oracle]:/oracle>
[ZFXXX2:root]:/>crsctl stat res -t
——————————————————————————–
NAME TARGET STATE SERVER STATE_DETAILS
——————————————————————————–
LocalResources
——————————————————————————–
…
ora.asm
ONLINE ONLINE zfXXX1 Started
ONLINE ONLINE zfXXX2 Started
…
ora.ora2lhr.db
1 ONLINE ONLINE zfXXX2 Open
ora.oraeskdb.db
1 ONLINE ONLINE zfXXX1 Open
2 ONLINE ONLINE zfXXX2 Open
ora.oralhr.db
1 ONLINE ONLINE zfXXX2 Open
ora.scan1.vip
1 ONLINE ONLINE zfXXX1
ora.testdgphy.db
1 ONLINE ONLINE zfXXX1 Open,Readonly
2 ONLINE ONLINE zfXXX2 Open,Readonly
ora.zfXXX1.vip
1 ONLINE ONLINE zfXXX1
ora.zfXXX2.vip
1 ONLINE ONLINE zfXXX2
1.1.2 启动备库到open read only状态
[ZFXXX1:oracle]:/oracle>sqlplus / as sysdba
SYS@DGPHY1>set line 9999
SYS@DGPHY1>select GROUP#,THREAD#,SEQUENCE#,BYTES,BLOCKSIZE,MEMBERS,STATUS fromv$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS STATUS
——————– ———- ———- ———- ———- —————-
1 1 17 52428800 512 2 CLEARING
2 1 18 52428800 512 2 CURRENT
3 2 13 52428800 512 2 CURRENT
4 2 12 52428800 512 2 CLEARING
SYS@DGPHY1>set line 9999
SYS@DGPHY1>selectdbid,name,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_statusfrom gv$database;
DBID NAME CURRENT_SCN PROTECTION_MODE DATABASE_ROLE FOR OPEN_MODE SWITCHOVER_STATUS
——————- ———– ——————– —————- ———————– ——————–
2836886746TESTDG 1182683 MAXIMUMPERFORMANCE PHYSICAL STANDBY YES READ ONLY NOT ALLOWED
2836886746TESTDG 1182683 MAXIMUMPERFORMANCE PHYSICAL STANDBY YES READ ONLY NOT ALLOWED
1.1.3 校验实时同步功能
为了实时查询，启用管理恢复
SYS@DGPHY1> alter database recovermanaged standby database using current logfile disconnect;
Databasealtered.
SYS@DGPHY1> select INST_ID, dbid,name,DB_UNIQUE_NAME,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_statusfrom gv$database;
INST_ID DBID NAME DB_UNIQUE_NAME CURRENT_SCN PROTECTION_MODE DATABASE_ROLE FOR OPEN_MODE SWITCHOVER_STATUS
——————– ——— ————— ———– ———————————— — ——————– ——————–
1 2836886746 TESTDG TESTDGPHY 1219930 MAXIMUM PERFORMANCE PHYSICAL STANDBY YES READ ONLY WITH APPLY NOTALLOWED
2 2836886746 TESTDG TESTDGPHY 1219930 MAXIMUM PERFORMANCE PHYSICAL STANDBY YES READ ONLY WITH APPLY NOTALLOWED
SYS@DGPHY1>col name for a100
SYS@DGPHY1>set linesize 9999 pagesize 9999
SYS@DGPHY1>SELECT dest_id,
2 THREAD#,
3 NAME,
4 sequence#,
5 archived,
6 applied,
7 a.NEXT_CHANGE#
8 FROM v$archived_log a
9 WHERE a.sequence# >= 12
10 AND resetlogs_change# = (SELECTd.RESETLOGS_CHANGE# FROM v$database d)
11 ORDER BY a.THREAD#,
12 a.sequence#,
13 a.dest_id;
DEST_ID THREAD# NAME SEQUENCE# ARCAPPLIED NEXT_CHANGE#
——————– ———————————- ——— — ——— ————
2 1 /arch/1_13_904043420.dbf 13 YES YES 1206723
2 1 /arch/1_14_904043420.dbf 14 YES YES 1206725
2 1 /arch/1_15_904043420.dbf 15 YES YES 1213882
2 1 /arch/1_16_904043420.dbf 16 YES YES 1214395
2 1 /arch/1_17_904043420.dbf 17 YES YES 1218112
1 2 /arch/2_12_904043420.dbf 12 YES IN-MEMORY 1218115
7rows selected.
主库切换日志，建表测试：
SYS@DGPRI1> ALTER SYSTEM SWITCH LOGFILE;
Systemaltered.
SYS@DGPRI1>ALTER SYSTEM SWITCH LOGFILE;
Systemaltered.
SYS@DGPRI1>ALTER SYSTEM SWITCH LOGFILE;
Systemaltered.
SYS@DGPRI1>create table lhr.test as select * from user_tables;
Tablecreated.
SYS@DGPRI1>select count(1) from lhr.test;
COUNT(1)
———-
1014
–在备库端查询日志应用情况
SYS@DGPHY1>select count(1) from lhr.test;
COUNT(1)
———-
1014
可以看到数据已经实时同步了，至此，物理备库搭建完成，至于备库的维护操作还有很多内容，参考我的其它blog。
1.2 实验总结
实验过程中需要注意的几项内容：
① 主库修改参数一定要加 sid=’*’
② 监听必须配置好
③ 执行duplicate命令的时候，如果是rac库需要添加参数：setinstance_number = ‘1’，否则报错：
RMAN-03015: error occurred in stored scriptMemory Script
RMAN-04014: startup failed: ORA-29760:instance_number parameter not specified
本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用
ITPUB BLOG：http://blog.itpub.net/26736162
本文地址：http://blog.itpub.net/26736162/viewspace-1991449/
本文pdf版：http://yunpan.cn/cdEQedhCs2kFz （提取码：ed9b）
QQ：642808185 若加QQ请注明您所正在读的文章标题
于 2016-02-16 10:00~2016-02-19 19:00 在中行完成