10g Data Guard单机配置.docx

10g Data Guard单机配置强制数据库产生日志。使得主数据库的一切变化都可以写入日志文件。SQLALTER DATABASE FORCE LOGGING;为主库添加联机日志SQL alter database add standby logfile /oracle/dg/redo01.log size 50m;SQL alter database add standby logfile / oracle /dg/redo02.log size 50m;SQL alter database add standby logfile / oracle /dg/redo03.log size 50m;将主库改为归档模式启动主库到mountSQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startup mount;ORACLE instance started.Total System Global Area 599785472 bytesFixed Size 2022600 bytesVariable Size 150995768 bytesDatabase Buffers 440401920 bytesRedo Buffers 6365184 bytesDatabase mounted.查看当前是否是归档模式SQL select open_mode,log_mode from v$database;OPEN_MODE LOG_MODE---------- ------------MOUNTEDNOARCHIVELOG开启归档模式SQL alter database archivelog;Database altered.再次查看，已开启归档模式SQL select open_mode,log_mode from v$database;OPEN_MODE LOG_MODE---------- ------------MOUNTED ARCHIVELOG检查主库的密码文件，密码文件存放位置$ORACLE_HOME/dbs/orapw$ORACLE_SID。没有则使用以下语句建立orapwd?file=$ORACLE_HOME/dbs/orawporcl?password=king?entries=53、添加standby logfile(也可以不加)为主数据库添加备用联机日志文件，这里要保证备日志文件与主库联机日志文件相同大小。添加备用日志文件是规则：备用日志最少应该比redo log 多一个。推荐的备重做日志数依赖于主数据库上的线程数。 (每线程日志文件最大数目 + 1 ) * 线程数 alter database add standby logfile group 4 (/oracle/dg/std_redo04a.log,/oracle/dg/std_redo04b.log) size 50m, group 5 (/oracle/dg/std_redo05a.log,/oracle/dg/std_redo05b.log) size 50m, group 6 (/oracle/dg/std_redo06a.log,/oracle/dg/std_redo06b.log) size 50m, group 7 (/oracle/dg/std_redo07a.log,/oracle/dg/std_redo08b.dbf) size 50m;否则备库在应用时报如下信息：RFS[1]: No standby redo logfiles createdRFS[1]: Archived Log: /oracle2/arch/1_30_633287861.dbf在主库添加完standby logfile后，当主库切换后备库后会自动使用备库的redo logfile，具体应用信息如下：RFS[1]: Successfully opened standby log 4: /oracle/dg/10g/redo04.logRFS[1]: Successfully opened standby log 4: /oracle/dg/10g/redo04.log修改主库的参数文件SQL create pfile=/home/oracle/pfile/initcrl.ora from spfile;File created.[oracle@dg pfile]$ vi initcrl.ora orcl.__db_cache_size=440401920orcl.__java_pool_size=4194304orcl.__la