Oracle-11G搭建单实例GoldenGate步骤

Oracle11G搭建单实例GoldenGate步骤1GoldenGate安装准备在Oracle官网上下载GoldenGate介质，GoldenGate是包含在FusionMiddleware类目下面，并上传到源数据库和目标数据库主机；2GoldenGate安装过程注意：此步骤需要在两台主机上操作2.1创建GoldenGate操作系统用户这里直接使用Oracle用户安装GoldenGate，而不创建新的用户。2.2创建GoldenGate安装路径[root@GMDBA~]#mkdir-p/u01/ggs/11.2.0[root@GMDBA~]#mv/u01/software/ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip/u01/ggs/11.2.0/[root@GMDBA~]#chown-Roracle:oinstall/u01/ggs/[root@GMDBA~]#su-oracle2.3编辑用户环境变量[oracle@GMDBAogg]$vi~/.bash_profile#.bash_profile#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcFi#UserspecificenvironmentandstartupprogramsPATH=$PATH:$HOME/binexportPATHexportORACLE_SID=GMDBAexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1exportPATH=$ORACLE_HOME/bin:/u01/ggs/11.2.0:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/ggs/11.2.0:/libaliassqlplus='rlwrapsqlplus'aliasrman='rlwraprman'2.4安装GoldenGate文件[oracle@GMDBA~]$cd/u01/ggs/11.2.0/[oracle@GMDBA11.2.0]$unzipogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zipArchive:ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zipinflating:fbo_ggs_Linux_x86_ora11g_32bit.tarinflating:OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdfinflating:OracleGoldenGate11.2.1.0.1README.txtinflating:OracleGoldenGate11.2.1.0.1README.doc[oracle@GMDBA11.2.0]$tar-xvffbo_ggs_Linux_x86_ora11g_32bit.tar[oracle@GMDBA11.2.0]$cd[oracle@GMDBA~]$cd/u01/ggs/11.2.0[oracle@GMDBA11.2.0]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x86,32bit(optimized),Oracle11gonApr23201208:09:25Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(GMDBA)1createsubdirsCreatingsubdirectoriesundercurrentdirectory/u01/ggs/11.2.0Parameterfiles/u01/ggs/11.2.0/dirprm:alreadyexistsReportfiles/u01/ggs/11.2.0/dirrpt:createdCheckpointfiles/u01/ggs/11.2.0/dirchk:createdProcessstatusfiles/u01/ggs/11.2.0/dirpcs:createdSQLscriptfiles/u01/ggs/11.2.0/dirsql:createdDatabasedefinitionsfiles/u01/ggs/11.2.0/dirdef:createdExtractdatafiles/u01/ggs/11.2.0/dirdat:createdTemporaryfiles/u01/ggs/11.2.0/dirtmp:createdStdoutfiles/u01/ggs/11.2.0/dirout:createdGGSCI(GMDBA)2注意：需要进入ogg的安装目录在执行ggsci[oracle@GMDBA~]$cd/u01/ogg/11.2.0/[oracle@GMDBA11.2.0]$ggsciOracleGoldenGateCommandInterpreterforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux,x86,32bit(optimized),Oracle11gonApr23201208:09:25Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(GMDBA)1helpGGSCICommandSummary:Object:Command:SUBDIRSCREATEERINFO,KILL,LAG,SEND,STATUS,START,STATS,STOPEXTRACTADD,ALTER,CLEANUP,DELETE,INFO,KILL,LAG,REGISTER,SEND,START,STATS,STATUS,STOPUNREGISTEREXTTRAILADD,ALTER,DELETE,INFOGGSEVTVIEWMANAGERINFO,SEND,START,STOP,STATUSMARKERINFOPARAMSEDIT,VIEWREPLICATADD,ALTER,CLEANUP,DELETE,INFO,KILL,LAG,SEND,START,STATS,STATUS,STOPREPORTVIEWRMTTRAILADD,ALTER,DELETE,INFOTRACETABLEADD,DELETE,INFOTRANDATAADD,DELETE,INFOSCHEMATRANDATAADD,DELETE,INFOCHECKPOINTTABLEADD,DELETE,CLEANUP,INFOCommandswithoutanobject:(Database)DBLOGIN,LISTTABLES,ENCRYPTPASSWORD,FLUSHSEQUENCEMININGDBLOGIN(DDL)DUMPDDL(Miscellaneous)FC,HELP,HISTORY,INFOALL,OBEY,SETEDITOR,SHELL,SHOW,VERSIONS,!(note:youmusttypethewordCOMMANDafterthe!todisplaythe!helptopic.)i.e.:GGSCI(sys1)help!commandForhelponaspecificcommand,typeHELP.Example:HELPADDREPLICATGGSCI(GMDBA)22.5配置源数据库2.5.1开启归档[oracle@GMDBA~]$sqlplus/assysdbaSQL*Plus:Release11.2.0.3.0ProductiononSunDec1520:16:572013Copyright(c)1982,2011,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQLstartupORACLEinstancestarted.TotalSystemGlobalArea422670336bytesFixedSize1345380bytesVariableSize327157916bytesDatabaseBuffers88080384bytesRedoBuffers6086656bytesDatabasemounted.Databaseopened.SQLshowparameterlog_archive_destNAMETYPEVALUE-----------------------------------------------------------------------------log_archive_deststringlog_archive_dest_1stringlog_archive_dest_10stringlog_archive_dest_11stringlog_archive_dest_12stringlog_archive_dest_13stringlog_archive_dest_14stringlog_archive_dest_15stringlog_archive_dest_16stringlog_archive_dest_17stringlog_archive_dest_18stringlog_archive_dest_19stringlog_archive_dest_2stringlog_archive_dest_20stringlog_archive_dest_21stringlog_archive_dest_22stringlog_archive_dest_23stringlog_archive_dest_24stringlog_archive_dest_25stringlog_archive_dest_26stringlog_archive_dest_27stringlog_archive_dest_28stringlog_archive_dest_29stringlog_archive_dest_3stringlog_archive_dest_30stringlog_archive_dest_31stringlog_archive_dest_4stringlog_archive_dest_5stringlog_archive_dest_6stringlog_archive_dest_7stringlog_archive_dest_8stringlog_archive_dest_9stringSQLshowparameterdb_recoveryNAMETYPEVALUE-----------------------------------------------------------------------------db_recovery_file_deststring/u01/app/oracle/fast_recovery_areadb_recovery_file_dest_sizebiginteger4977MSQLshutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQLstartupmountORACLEinstancestarted.TotalSystemGlobalArea422670336bytesFixedSize1345380bytesVariableSize327157916b