Oracle RAC+ASM+DataGuard配置实验记录+常见问题

OracleRAC+ASM+DataGuard配置实验记录+常见问题OracleRAC+ASM+DataGuard配置实验记录+常见问题1、环境规划：---RAC环境介绍(primarydatabase)rac1rac2______________________________________________________publicip192.168.110.11192.168.110.12______________________________________________________virtualip192.168.110.21192.168.110.22_____________________________________________________instanceracdb1racdb2______________________________________________________db_nameracdb_______________________________________________________storagemodeASM__________________________________________________---单机环境介绍（standbydatabase）数据文件可放至本地，也可以放至ASM上，本实验中先放至本地实验__________________________________________________________________________ip192.168.110.11192.168.110.12___________________________________________________________________________instance192.168.110.13(rac3)___________________________________________________________________________storagemode/oradata/racdb___________________________________________________________________________----hosts文件#PublicNetwork-(eth0)192.168.110.11rac1192.168.110.12rac2192.168.110.13rac3#PrivateInterconnect-(eth1)10.10.10.11rac1priv10.10.10.12rac2priv#PublicVirtualIP(VIP)addresses-(eth0)192.168.110.21rac1vip192.168.110.22rac2vip--检查环境１）、启动archivelog归档模式SQLarchiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence54Nextlogsequencetoarchive56Currentlogsequence56SQLshowparameterRECOVERYNAMETYPEVALUE-----------------------------------------------------------------------------db_recovery_file_deststring+DG_RECOVERYdb_recovery_file_dest_sizebiginteger2Grecovery_parallelisminteger0２）、启动FORCE_LOGGING模式SQLalterdatabaseFORCELOGGING;Databasealtered.SQLselectFORCE_LOGGINGfromv$database;FOR---YES2、首先配置两个数据库的tnsnames.ora和listener.oratnsnames.ora(两台主机相同)racdb_rac1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.110.21)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racdb_s)(SERVICE_NAME=racdb1)))racdb_rac2=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.110.22)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racdb_s)(SERVICE_NAME=racdb2)))racdb_standby=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.110.13)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racdb)))standby主机上的listener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=racdb)(ORACLE_HOME=/oracle/app/product/10.2.0/db_1)(SID_NAME=racdb))(SID_DESC=(GLOBAL_DBNAME=PLSExtProc)(ORACLE_HOME=/oracle/app/product/10.2.0/db_1)(SID_NAME=PLSExtProc)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.110.13)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))))3、准备参数文件RAC环境下的参数变化增加如下：RAC主库:（注意使用ASM的时候，不要改变db_unique_name参数，否则之后创建的asm文件就会放入至新的db_unique_name目录下面，导致DB_FILE_NAME_CONVERT失效。）#addbelowparameterforstandydatabase*.service_names=racdb_s*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(racdb,racdb_standby)'*.LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DESTVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=racdb'*.LOG_ARCHIVE_DEST_2='SERVICE=racdb_standbyLGWRVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=racdb_standby'*.FAL_SERVER='racdb_standby'*.STANDBY_ARCHIVE_DEST='/oradata/arch'*.racdb1.fal_client=racdb1*.racdb2.fal_client=racdb2*.STANDBY_FILE_MANAGEMENT=AUTO*.DB_FILE_NAME_CONVERT='/oradata/racdb/datafile','+DG_DATA/racdb/datafile','/oradata/racdb/tempfile','+DG_DATA/racdb/tempfile'*.LOG_FILE_NAME_CONVERT='/oradata/racdb/onlinelog','+DG_DATA/racdb/onlinelog'单机备库增加以下：*.db_name='racdb'*.db_unique_name='racdb_standby'*.service_names='racdb_standby'*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(racdb_standby,racdb)'*.LOG_ARCHIVE_DEST_1='LOCATION=/oradata/archVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=racdb_standby'*.LOG_ARCHIVE_DEST_2='SERVICE=racdb1LGWRVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=racdb'*.STANDBY_FILE_MANAGEMENT='AUTO'STANDBY_ARCHIVE_DEST='/oradata/arch'*.FAL_SERVER='racdb1','racdb2'fal_client='racdb_standby'*.DB_FILE_NAME_CONVERT='+DG_DATA/racdb/datafile','/oradata/racdb/datafile','+DG_DATA/racdb/tempfile','/oradata/racdb/tempfile'*.LOG_FILE_NAME_CONVERT='+DG_DATA/racdb/onlinelog','/oradata/racdb/onlinelog'*racdb1.thread=1*.undo_management='AUTO'单机备库参数如下：#addbelowparameterforstandydatabase*.audit_file_dest='/oracle/app/admin/racdb/adump'*.background_dump_dest='/oracle/app/admin/racdb/bdump'*.compatible='10.2.0.4'*.control_files='/oradata/racdb/datafile/racdb.ctl'*.core_dump_dest='/oracle/app/admin/racdb/cdump'*.db_block_size=16384*.db_domain=''*.db_name='racdb'*.db_file_multiblock_read_count=16*.DB_FILE_NAME_CONVERT='+DG_DATA/racdb/datafile','/oradata/racdb/datafile','+DG_DATA/racdb/tempfile','/oradata/racdb/tempfile'*.db_unique_name='racdb_standby'fal_client='racdb_standby'*.FAL_SERVER='racdb1','racdb2'*.job_queue_processes=10*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(racdb_standby,racdb_s)'*.LOG_ARCHIVE_DEST_1='LOCATION=/oradata/archVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=racdb_standby'*.LOG_ARCHIVE_DEST_2='SERVICE=racdb1LGWRVALID_FOR=(ONLINE_LOG