oracle_常用命令_20110903.docVIP

oracle_常用命令oracle trace 文件所在目录 /opt/ora10g/admin/RACDB/bdump/racdb1_dmon_11930.trc: http://www.adp-gmbh.ch/ora/data_guard/create_physical_standby_db.html http://www.adp-gmbh.ch/ora/data_guard/verify_environment.html#physical /thread-998901-1-2.html /sql/Oracle/2010061236881_2.html /730796/viewspace-580283 /pls/db111/portal.portal_db?selected=16 /thread-367179-1-1.html# /z_rx/blog/static/2763637620077811571555/ /ha/dataguard-step-by-step.htm 1、修改主库属性： alter system force logging; ##查看状态 select FORCE_LOGGING from v$database; 2、修改数据库为归档模式： archive log list; shutdown immediate; startup mount; alter database archivelog;(alter database noarchivelog;关掉归档模式) archive log list; 3、添加standby logfile(也可以不加) 为主数据库添加备用联机日志文件，这里要保证备日志文件与主库联机日志文件相同大小。 添加备用日志文件是规则： 备用日志最少应该比redo log 多一个。推荐的备重做日志数依赖于主数据库上的线程数。 (每线程日志文件最大数目 + 1 ) * 线程数 alter database add standby logfile group 4 (/oracle2/app/oracle/oradata/std_redo04a.log,/oracle2/app/oracle/oradata/std_redo04b.log) size 50m, group 5 (/oracle2/app/oracle/oradata/std_redo05a.log,/oracle2/app/oracle/oradata/std_redo05b.log) size 50m, group 6 (/oracle2/app/oracle/oradata/std_redo06a.log,/oracle2/app/oracle/oradata/std_redo06b.log) size 50m, group 7 (/oracle2/app/oracle/oradata/std_redo07a.log,/oracle2/app/oracle/oradata/std_redo08b.dbf) size 50m; 否则备库在应用时报如下信息： RFS[1]: No standby redo logfiles created RFS[1]: Archived Log: /oracle2/arch/1_30_633287861.dbf 在主库添加完standby logfile后，当主库切换后备库后会自动使用备库的redo logfile，具体应用信息如下： RFS[1]: Successfully opened standby log 4: /oracle2/app/oracle/oradata/10g/redo04.log RFS[1]: Successfully opened standby log 4: /oracle2/app/oracle/oradata/10g/redo04.log 在主库添加完standby logfile后，当主库切换后备库后会自动使用备库的redo logfile，具体应用信息如下： RFS[1]: Successfully opened standby log 4: /oracle2/app/oracle/oradata/10g/redo04.log RFS[1]: Successfully opened standby log 4: /oracle2/app/oracle/oradata/10g/redo04.log alter datab