Data-Guad-环境下-主备库Redo-log-的添加与删除.doc

Data-Guard-环境下-主备库Redo-log-的添加与删除 Data Guard 环境下 主备库Redo log 的添加与删除Data Guard 环境下 主备库Redo log 的添加与删除 分类: 默认分类 日期: 2010-12-08 22:09 原文地址: /tianlesoftware/article/details/6064121 分类： Oracle Data Guard 2010-12-08 22:09 1324人阅读 评论(0) 收藏 举报 刚搭建完一个Data Gard 环境。 在服务器上弄的，过几天要上生产线。 安装的时候redo 默认了50M。 而且standby redo 也是50M。 和同事讨论之后，还是把改成100M。50M 确实小了点。 Standby redo的大小要和redo 的一致，所以主备库都要调整。 一. 主库操作 1.1 查看redo 信息 SQLgt; select group#,type, member from v$logfile; GROUP# TYPE MEMBER ---------- ------- ------------------------------------------------------------- 3 ONLINE /u01/app/oracle/oradata/xezf/redo03.log 2 ONLINE /u01/app/oracle/oradata/xezf/redo02.log 1 ONLINE /u01/app/oracle/oradata/xezf/redo01.log 4 STANDBY /u01/app/oracle/oradata/xezf/redo04.log 5 STANDBY /u01/app/oracle/oradata/xezf/redo05.log 6 STANDBY /u01/app/oracle/oradata/xezf/redo06.log 7 STANDBY /u01/app/oracle/oradata/xezf/redo07.log 7 rows selected. SQLgt; select group#,thread#,archived,status, bytes/1024/1024 from v$log; GROUP# THREAD# ARC STATUS BYTES/1024/1024 ---------- ---------- --- ---------------- --------------- 1 1 YES INACTIVE 50 2 1 NO CURRENT 50 3 1 YES INACTIVE 50 1.2 修改standby redo SQLgt; alter database drop logfile group 4; Database altered. SQLgt; alter database drop logfile group 5; Database altered. SQLgt; alter database drop logfile group 6; Database altered. SQLgt; alter database drop logfile group 7; Database altered. SQLgt; select group#,type, member from v$logfile; GROUP# TYPE MEMBER ---------- ------- ------------------------------------------------------------- 3 ONLINE /u01/app/oracle/oradata/xezf/redo03.log 2 ONLINE /u01/app/oracle/oradata/xezf/redo02.log 1 ONLINE /u01/app/oracle/oradata/xezf/redo01.log 添加standby redo SQLgt; ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (/u01/app/oracle/oradata/xezf/std_redo04.log) size 100M; Database altered. SQLgt; ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (/u01/app/or