windows oracle 11g dataguard,windows2008r2配置oracle11gDataGuard数据同步.docx

windows2008 r2配置oracle 11g r2 DataGuard数据同步一、首要条件：1．两台相同的window 2008 server,都安装好oracle11g r2。2．选其中一台作为主库(primary)，另一台作为备库(standby)，主库配置备库配置备注：主库备库中的tnsnames.ora配置范例如下：standby = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.133)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = standby) ) )primary = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.132)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = primary) ) )3．确保在主、备库可以通过CMD命令sqlplus scott/admin@primary ,sqlplus scott/admin@standby相互程登录二、主库操作1．设置主库归档模式，查看是否为归档：SQL> archive log list;备注：在安装oracle的时候，可以直接选择为存档模式。如果自动存档未开启，执行SQL> alter database archivelog;然后设置强制归档SQL> alter database force logging;查看SQL> select force_logging from v$database;主库归档配置完成。2.添加主库standby联机日志(路径不存在需要手动建立)SQL> alter database add standby logfile group 4'C:\app\Administrator\oradata\ORCL\ONLINELOG\redo04.log' size 50m;SQL> alter database add standby logfile group 5'C:\app\Administrator\oradata\ORCL\ONLINELOG\redo05.log' size 50m;SQL> alter database add standby logfile group 6'C:\app\Administrator\oradata\ORCL\ONLINELOG\redo06.log' size 50m;3.编辑主库参数文件创建主库pfileSQL> create pfile='c:\primary.ora' from spfile;打开创建好的primary.ora修改或添加以下参数*.db_name='orcl'*.log_archive_format='ARC_%T%S%r.ARC'*.DB_UNIQUE_NAME='primary'*.log_archive_config='DG_CONFIG=(primary,standby)'*.log_archive_dest_1='location=E:\app\admin\oradata\archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary'*.log_archive_dest_2='SERVICE=standby ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_DEST_STATE_2=ENABLE*.FAL_SERVER='standby'*.FAL_CLIENT='primary'*.STANDBY_FILE_MANAGEMENT=AUTO(注意：有些参数与primary.ora现存的参数重复，建议相同的只保留一条，标红为特别注意需按实际情况修改的)4.使用新编辑的primary.ora启动数据库SQL> shutdown immediate;SQL> startup pfile='c:\primary.ora' mount;SQL> create spfile from pfile=’c:\primary.ora';? -- 写入spfile再关闭重启实例这个错误可以不管，也可以在关闭之前a