-【优秀文档】ORACLE DG 搭建.docVIP

ORACLE DG 搭建 dataguard: DG(同步数据)－－从主机上把归档传输到备机上，分为： 物理： 把物理的归档日志文件备份过来了，使用recover恢复。 逻辑： 把归档日志逻辑上备份过来，先做日志挖掘，把SQL语句 选择出来，再选择。 搭建DG （我这里的主库和备库的目录是一样的） 1，主从的ORACLE 的版本要一致 2，主从的环境变量要一致 3，配置hosts 文件 vim?/etc/hosts #?Do?not?remove?the?following?line,?or?various?programs #?that?require?network?functionality?will?fail. ???????????????localhost.localdomain?localhost ::1?????????????localhost6.localdomain6?localhost6 43????????station243 72????????station172 4，在主库上（primary） 修改force?logging?,archivelog?mode? SQL?shutdown?immediate Database?closed. Database?dismounted. ORACLE?instance?shut?down. SQL?startup?mount ORACLE?instance?started. Total?System?Global?Area??603979776?bytes Fixed?Size??????????????????1268872?bytes Variable?Size?????????????213910392?bytes Database?Buffers??????????381681664?bytes Redo?Buffers????????????????7118848?bytes Database?mounted. SQL?alter?database?force?logging; Database?altered. SQL?alter?database?archivelog; Database?altered. SQL?alter?database?open; Database?altered. SQL?archive?log?list; Database?log?mode??????????????Archive?Mode Automatic?archival?????????????Enabled Archive?destination????????????/u01/app/oracle/archivelog/emrep Oldest?online?log?sequence?????18 Next?log?sequence?to?archive???20 Current?log?sequence???????????20 SQL?select?force_logging?from?v$database; FOR ?L YES SQL?create?pfile=$ORACLE_HOME/dbs/initemrep.ora?from?spfile; File?created. SQL?shutdown?immediate cd?u01/app/oracle/product/10g/db_1/dMbs 修改参数配置文件 vim initemrep.ora 在最末尾添加： db_unique_name=pdb log_archive_config=dg_config=(pdb,sdb) fal_server=sdb fal_client=pdb/u01/app/oracle/product/10g/db_1/dbs log_archive_dest_2=service=sdb lgwr sync affirm valid_for=(online_logfile,primary_role) db_unique_name=sdb log_archive_dest_state_1=ENABLE log_archive_dest_state_2=ENABLE standby_file_management=AUTO 如果主库与备库安装目录不一样： db_file_name_convert=/ora/oradata/emrep,/oracle/app/oradata /emrep log_file_name_convert=/ora/oradata/emrep,/oracle/app/oradat a/emrep 先远程后本地 启动数据库到nomoun