ORACLE 11G ADG 修改STANDBY LOG 大小

有时候我DBA是 接收别的系统,或者随着业务的增加,原来的日志大小已经不适合了.触及每20分钟切换一次日志的底线. 所以要增加日志的大小.

一般情况下都是先把日志给删了,然后再添加日志.  如果是ADG的话,得先要把备库的STANDBY LOG改大,才能改主库的日志.

改变ADG的STANDBY LOG 大小

1 先查看日志状态 只UNASSIGNED 和归档已经YES的才可以删除,重新添加

select group#,thread#,sequence#,used,archived,status  from v$standby_log;
    GROUP#    THREAD#  SEQUENCE#       USED ARC STATUS
---------- ---------- ---------- ---------- --- ----------
  4     1     7213   20818432 YES ACTIVE
  5     1        0 512 NO UNASSIGNED
  6     0        0 512 YES UNASSIGNED
  7     0        0 512 YES UNASSIGNED

2 删除日志组, 重新添加1G大的日志

ALTER DATABASE DROP LOGFILE GROUP 5;
rm standby05.log
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/u01/app/oracle/oradata/orcl/standby05.log') size 1024m;


ALTER DATABASE DROP LOGFILE GROUP 6;
rm standby06.log
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/u01/app/oracle/oradata/orcl/standby06.log') size 1024m;


ALTER DATABASE DROP LOGFILE GROUP 7;
rm standby07.log
ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/u01/app/oracle/oradata/orcl/standby07.log') size 1024m;

3 等待主库日志切换后,STANDBY 使用日志组5后便可以删除日志组4

主库发起:

alter system switch logfile;

备库查看:

select group#,thread#,sequence#,used,archived,status  from v$standby_log;


    GROUP#    THREAD#  SEQUENCE#       USED ARC STATUS
---------- ---------- ---------- ---------- --- ----------
  4     1        0      512 NO UNASSIGNED
  5     1        7214    2222080 YES ACTIVE
  6     0        0 512 YES UNASSIGNED
  7     0        0 512 YES UNASSIGNED

4 等待归档完成  

ALTER DATABASE DROP LOGFILE GROUP 4;
rm standby04.log
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/standby04.log') size 1024m;

5切换恢复模式

alter database recover managed standby database using current logfile disconnect;