Linux平台DG配置维护手册.docxVIP

Linux 平台DG配置管理手册2010年11月8日环境简介以下是DataGuard环境主备Oracle数据库的服务器信息：主服务器信息机器名：db1 IP：172.16.3.15 Instance：orclDB_UNIQUE_NAME：primary备服务器信息机器名：db2 IP：172.16.3.17 Instance：orclDB_UNIQUE_NAME：standbyHosts文件设置：# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 db1 localhost.localdomain localhost::1 localhost6.localdomain6 localhost6172.16.3.15db1172.16.3.17db2DataGuard配置DataGuard选件在安装企业版Oracle数据的时候已经被安装，只要做相应配置即可使用，配置主要包括两部分，主库的配置和备库的配置：2.1主库服务器配置2.1.1修改主库属性：SQL alter database force logging;Database altered.##查看状态SQL select FORCE_LOGGING from v$database;FORYES2.1.2修改数据库为归档模式SQL alter system set log_archive_dest_1=LOCATION=/data/archivelog/ scope=both;System altered.SQL shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL startup mount;ORACLE instance started.Total System Global Area? 167772160 bytesFixed Size????????????????? 1218292 bytesVariable Size?????????????bytesDatabase Buffers??????????bytesRedo Buffers??????????????? 7168000 bytesDatabase mounted.SQL alter database archivelog;Database altered.SQL archive log list;Database log mode????????????? Archive ModeAutomatic archival???????????? EnabledArchive destination??????????? /data/archivelog/Oldest online log sequence???? 1Next log sequence to archive?? 2Current log sequence?????????? 2SQL alter database open;Database altered.2.1.3 添加standby logfile (也可以不加)为主数据库添加备用联机日志文件，这里要保证备日志文件与主库联机日志文件相同大小。添加备用日志文件规则：备用日志最少应该比redo log 多一个。推荐的备重做日志数依赖于主数据库上的线程数。(每线程日志文件最大数目 + 1 ) * 线程数SQL select GROUP#,MEMBERS,BYTES/1024/1024 from v$log;GROUP#??? MEMBERS BYTES/1024/1024---------- ---------- ---------------???????? 1????????? 1????????????? 50???????? 2????????? 1????????????? 50???????? 3????????? 1????????????? 50SQL select GROUP#,MEMBER from v$logfile;???? GROUP# MEMBER---------- ----------------------------------------???????? 3 /oracle/oradata/orcl/redo03.log???????? 2 /oracle/orad