-【优秀文档】ORACLEDG搭建（整理版）

《-【优秀文档】ORACLEDG搭建（整理版）》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、ORACLEDG搭建dataguard:DG（同步数据）一一从主机上把归档传输到备机上，分为：物理：把物理的归档日志文件备份过来了，使用recover恢复。逻辑：把归档日志逻辑上备份过来，先做日志挖掘，把SQL语句选择出來，再选择。搭建DG（我这里的主库和备库的目录是一样的）1,主从的ORACLE的版本要一致2,主从的环境变量要-•致3,配置hosts文件vim/etc/hosts#Donotremovethefollowingline,orvariousprograms#thatrequirenetworkfunctionalitywillfail.127.0

2、.0.1localhost」ocaldomainlocalhost::1localhost6」ocaldomain6Iocalhost610.1.1.243station243.cluster.comstation24310.1.1.172stationl72.cluster.comstationl724,在主库上（primary）修改forcelogging,archivelogmodeSQL>shutdownimmediateDatabaseclosed・Databasedismounted.ORACLEinstanceshutdown.SQL>startu

3、pmountORACLEinstaneestarted.TotalSystemGlobalArea603979776bytesFixedSizeVariableSizeDatabaseBuffersRedoBuffers1268872bytes213910392bytes381681664bytes7118848bytesDatabasemounted.SQL>alterdatabaseforcelogging;Databasealtered・SQL>alterdatabasearchivelog;Databasealtered.SQL>alterdatabas

4、eopen;Databasealtered・SQL>archiveloglist;DatabaselogmodeAutomaticarchivalArchivedestinationArchiveModeEnabled/uOl/app/oracle/archivelog/emrepOldestonlinelogsequenee18Nextlogsequencetoarchive20Currentlogsequenee20SQL>selectforce_loggingfromv$database;FORYESSQL>createpfile='$ORACLE_HOM

5、E/dbs/initemrep.ora'fromspfile;Filecreated・SQL>shutdownimmediatecd/u01/app/oracle/product/10g/db_l/dbs修改参数配逍文件viminitemrep.ora在最末尾添加：db_unique」ame=,pdb,log_archive_config=,dg_config=(pdb,sdb)1fal_server=sdbfal_client=pdb/u01/app/oracle/product/10g/db_Vdbslog_archive_dest_2=,service=s

6、dbIgwrsyncaffirmvalid_for=(online」ogfile,primary_role)db_unique_name=sdb'log_archive_dest_state_l=ENABLElog_archive_dest_state_2=ENABLEstandby_file_management二AUTO如果主库与备库安装目录不一样：db_file_name_convert=7ora/oradata/emrep'/oracIe/app/oradata/emrep1log_file_name_convert=7ora/oradata/emre

7、p,,,/oracle/app/oradata/emrep1先远程示木地启动数据库到nomount的状态下[oracle@stationl72~]$sqlplus/assysdba603979776bytes1268872bytes213910392bytes381681664bytes7118848bytesSQL>startupnomountpfile=,$ORACLE_HOME/dbs/initemrep.ora,;ORACLEinstancestarted.TotalSystemGlobalAreaFixedSizeVariableSizeDatabas

8、eBuffersRedo