oracle-12c-容灾之Active-Data-Guard-测试报告

12c容灾之ActiveDataGuard测试报告杨玉鹏2013.12.30目录测试环境.............................................................................................3测试目的.............................................................................................3测试场景.............................................................................................3场景一：测试环境dataguard搭建测试....................................3场景描述..................................................................................3测试过程..................................................................................3结论.......................................................................................10场景二：12cdataguard容灾级别的验证................................10场景描述................................................................................10测试过程................................................................................10结论.......................................................................................15场景三：12cdataguard容灾主备库切换验证.....................15场景描述................................................................................15测试过程................................................................................16结论.......................................................................................19测试环境搭载主库的主机节点为oratest3；且主/备库主机节点为HPDL580G7PC（配置为4颗4核1.86GHzCPU，32GB内存）服务器。操作系统版本均为REDHATLinux6.1，内核版本2.6.32-131.0.15.el6.x86_64。数据库版本为OracleDatabase12cEnterpriseEditionRelease12.1.0.1.0-64bitProduction。测试数据库test采用12c的多租户架构，一个CDB中插入了二个PDB，分别为pdb1，pdb2。测试目的测试验证oracle12c版本的物理ActiveDataGuard容灾技术的新特性和主库和备库切换；日志在主备库，容器库和插件库之间的传输验证；12c版主中ActiveDataGuard实时查询（Real-timequery）特性验证。测试场景场景一：测试环境dataguard搭建测试场景描述节点oratest3为此次dataguard搭建测试的主机环境，在测试前先安装数据库软件，然后dbca创建一个容器数据库为test，并且包含两个pdb为pdb1和pdb2并配置监听正常后，对新的容器数据库test进行本机容灾dataguard的搭建和配置测试，并为后续的测试准备好测试环境同时验证dataguard测试环境是否正常等。测试过程1主库日志模式修改：SQLalterdatabaseforcelogging;Databasealtered.2为备库创建dump日志目录：$mkdir-p/oracle/db_base/admin/test/test/adump$mkdir-p/oracle/db_base/admin/test/test/pdb1/$mkdir-p/oracle/db_base/admin/test/test/pdbseed$mkdir-p/oracle/db_base/admin/test/fast_recovery_area/test/$mkdir-p/oracle/db_base/admin/test/test/pdbseed/3为备库创建密码文件：Orapwdfile=/oracle/db_base/product/12.1.0/dbhome_1/dbspassword=oracle[oracle@oratest3dbs]$pwd/oracle/db_base/product/12.1.0/dbhome_1/dbs[oracle@oratest3dbs]$ls-lorapwtest-rw-r-----.1oracleoinstall7680Dec2418:16orapwtest4为主库和备库配置监听：SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=test_dr)(ORACLE_HOME=/oracle/db_base/product/12.1.0/dbhome_1)(SID_NAME=test))(SID_DESC=(GLOBAL_DBNAME=testdg_DGMGRL)(ORACLE_HOME=/oracle/db_base/product/12.1.0/dbhome_1)(SID_NAME=testdg))(SID_DESC=(GLOBAL_DBNAME=sbdb_DGMGRL)(ORACLE_HOME=/oracle/db_base/product/12.1.0/dbhome_1)(SID_NAME=sbdb))(SID_DESC=(GLOBAL_DBNAME=sbd_DGMGRL)(ORACLE_HOME=/oracle/db_base/product/12.1.0/dbhome_1)(SID_NAME=sbdb)))SID_LIST_TEST=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=testsb_DGMGRL)(ORACLE_HOME=/oracle/db_base/product/12.1.0/dbhome_1)(SID_NAME=testdg)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest3)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))))TEST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest3)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=test)))5为主库和备库配置tns：TESTSB_DGMGRL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=testsb_DGMGRL)))LISTENER_TEST=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest3)(PORT=1521))TESTDG=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=testdg)))TEST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oratest3)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=test)))6为备库创建控制文件：ALTERDATABASECREATESTANDBYCONTROLFILEAS'control_files=/oracle/db_base/oradata/test/control01.ctl'7为备库创建参数文件：CREATESPFILEFROMPFILE='/oracle/db_base/product/12.1.0/dbhome_1/dbs/inittestdg.ora'修改如下：testdg.__pga_aggregate_target=1207959552testdg.__sga_target=1811939328testdg.__shared_io_pool_size=0testdg.__shared_pool_size=385875968testdg.__streams_pool_size=0*.archive_lag_target=0*.compatible='12.1.0.0.0'*.control_files='/oracle/db_base/oradata/testdg/control01.ctl'*.db_block_size=8192*.db_file_name_convert='/oracle/db_base/oradata/test','/oracle/db_base/oradata/testdg','/oracle/db_base/oradata/test/pdbseed','/oracle/db_base/oradata/testdg/pdbseed','/oracle/db_base/oradata/test/pdb1','/oracle/db_base/oradata/testdg/pdb1','/oracle/db_base/oradata/test/pdb2','/oracle/db_base/oradata/testdg/pdb2'*.db_name='test'*.db_recovery_file_dest='/oracle/db_base/oradata/testdg/arc'*.db_recovery_file_dest_size=1526M*.db_unique_name='testsb'*.dg_broker_config_file1='/oracle/db_base/oradata/testdg/arc/dr1testsb.dat'*.dg_broker_config_file2='/oracle/db_base/oradata/testdg/arc/dr2testsb.dat'*.dg_broker_start=true*.diagnostic_dest='/oracle/db_base'*.enable_pluggable_database=TRUE*.fal_server='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oratest3)(PORT=1521))(CONNECT_DATA=(SERVICE