oracle 11gr2 rac dataguard broker 详细安装步骤

本文格式为Word版，下载可任意编辑——oracle11gr2racdataguardbroker详细安装步骤archiveloglist;

DatabaselogmodeArchiveModeAutomaticarchivalEnabled

ArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence8Nextlogsequencetoarchive9Currentlogsequence9

d）配置监听和netservice

主库配置监听和tns（所有节点都配置一样的）

[grid@rhel1]$cat$ORACLE_HOME/network/admin/listener.ora#使用动态监听，不需要修改

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))#lineaddedbyAgent

LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))#lineaddedbyAgent

LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))#lineaddedbyAgent

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))#lineaddedbyAgent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON#lineaddedbyAgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON#lineaddedbyAgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON#lineaddedbyAgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON#lineaddedbyAgentSID_LIST_LISTENER=(SID_LIST=(SID_DESC=

(GLOBAL_DBNAME=ractest_DGMGRL)

(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)

(SID_NAME=ractest1)#这里其次个节点为ractest2))

[oracle@rhel1]$cat$ORACLE_HOME/network/admin/tnsnames.ora

#tnsnames.oraNetworkConfigurationFile:/oracle/product/11.2.0/network/admin/tnsnames.ora#GeneratedbyOracleconfigurationtools.

RTDG1=

(DESCRIPTION=(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=TCP)(HOST=DG1)(PORT=1521)))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=rtdg1)))

RACTEST=

(DESCRIPTION=(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))#假使scan没有使用dns解析，也可以使用vip连接数据库)

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=ractest)#此处假使有service资源，建议使用service资源))

备库配置监听和tns

配置和主机一样的dns客户端和hosts文件

[oracle@dg1]$cat$ORACLE_HOME/network/admin/listener.ora

#listener.oraNetworkConfigurationFile:/oracle/product/11.2.0/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.

SID_LIST_LISTENER=(SID_LIST=(SID_DESC=

(GLOBAL_DBNAME=ractest)

(ORACLE_HOME=/oracle/product/11.2.0)(SID_NAME=ractest)))

SID_LIST_LISTENER=(SID_LIST=(SID_DESC=

(GLOBAL_DBNAME=rtdg1_DGMGRL)(ORACLE_HOME=/oracle/product/11.2.0)(SID_NAME=ractest)))

LISTENER=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=dg1)(PORT=1521)))

ADR_BASE_LISTENER=/oracle

[oracle@dg1]$cat$ORACLE_HOME/network/admin/tnsnames.ora

#tnsnames.oraNetworkConfigurationFile:/oracle/product/11.2.0/network/admin/tnsnames.ora#GeneratedbyOracleconfigurationtools.

RTDG1=

(DESCRIPTION=(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=TCP)(HOST=DG1)(PORT=1521)))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=rtdg1)))

RACTEST=

(DESCRIPTION=(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))

)

(CONNECT_DATA=

(SERVER=DEDICATED)(SERVICE_NAME=ractest)))

启动主库和备库监听$lsnrctlstart检验：

tnspingractesttnspingrtdg1

e）主库创立standbyonlinelog（应当在创立standbycontrolfile之前创立，这样备库就不需要在创立standbyredolog了）

selectGROUP#,thread#,bytes/1024/1024\GROUP#THREAD#SIZE(MB)MEMBERS

11502215023250242502

alterdatabaseaddstandbylogfilethread1('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilethread1('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilethread1('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilethread2('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilethread2('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilethread2('+DBFILE','+FRA')size50M;

注意：此处建议不要指定thread，

alterdatabaseaddstandbylogfilegroup101('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilegroup102('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilegroup103('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilegroup104('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilegroup105('+DBFILE','+FRA')size50M;alterdatabaseaddstandbylogfilegroup106('+DBFILE','+FRA')size50M;

f）修改主库spfile

SYS@ractest1>createpfile='/tmp/initractest.ora'fromspfile;$vi/tmp/initractest.ora

ractest2.__db_cache_size=671088640ractest1.__db_cache_size=637534208ractest2.__java_pool_size=16777216ractest1.__java_pool_size=16777216ractest2.__large_pool_size=33554432ractest1.__large_pool_size=33554432

ractest2.__pga_aggregate_target=419430400ractest1.__pga_aggregate_target=436207616

ractest2.__sga_target=1174405120ractest1.__sga_target=1157627904ractest2.__shared_io_pool_size=0ractest1.__shared_io_pool_size=0

ractest2.__shared_pool_size=436207616ractest1.__shared_pool_size=452984832ractest2.__streams_pool_size=0ractest1.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/ractest/adump'*.audit_trail='db'

*.cluster_database=true*.compatible='.0'

*.control_files='+DBFILE/ractest/controlfile/current.260.871340793','+FRA/ractest/controlfile/current.256.871340793'*.db_block_size=8192

*.db_create_file_dest='+DBFILE'*.db_domain=''*.db_name='ractest'

*.db_recovery_file_dest='+FRA'

*.db_recovery_file_dest_size=4621074432*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP)(SERVICE=ractestXDB)'ractest1.instance_number=1ractest2.instance_number=2

*.log_archive_format='%t_%s_%r.dbf'*.memory_target=1583349760*.open_cursors=300*.processes=1500

*.remote_listener=':1521'*.remote_login_passwordfile='exclusive'*.sessions=1655ractest2.thread=2ractest1.thread=1

ractest1.undo_tablespace='UNDOTBS1'ractest2.undo_tablespace='UNDOTBS2'###添加

*.db_unique_name='ractest'

*.log_archive_config='dg