Oracle 10g OCFS2系统RAC节点更改redolog(二)

2014-11-24 17:21:30 · 作者: · 浏览: 2
D 0
11 1 0 400 YES UNUSED 0
12 2 0 400 YES UNUSED 0


4.delete原来50M 状态为INACTIVE的redo log 若原来的redo log状态为非INACTIVE,则多做几次全局检查点和切换redo log 即可

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;



5.查看当前最新redo log

SQL> select group#,thread#,SEQUENCE# ,BYTES/1024/1024 "MB", ARCHIVED,STATUS,FIRST_CHANGE# ,FIRST_TIME FROM V$LOG;

GROUP# THREAD# SEQUENCE# MB ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
7 1 436474 400 YES INACTIVE 1.3795E+13 06-MAY-14
8 2 175639 400 NO CURRENT 1.3795E+13 06-MAY-14
9 1 436475 400 NO CURRENT 1.3795E+13 06-MAY-14
10 2 0 400 YES UNUSED 0
11 1 0 400 YES UNUSED 0
12 2 0 400 YES UNUSED 0


SQL> select * from v$logfile

GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ------------------------------- ------------------------
7 ONLINE /oradata/orcl/redo07a.log NO
7 ONLINE /oradata/orcl/redo07b.log NO
8 ONLINE /oradata/orcl/redo08a.log NO
8 ONLINE /oradata/orcl/redo08b.log NO
9 ONLINE /oradata/orcl/redo09a.log NO
9 ONLINE /oradata/orcl/redo09b.log NO
10 ONLINE /oradata/orcl/redo10a.log NO
10 ONLINE /oradata/orcl/redo10b.log NO
11 ONLINE /oradata/orcl/redo11a.log NO
11 ONLINE /oradata/orcl/redo11b.log NO
12 ONLINE /oradata/orcl/redo12a.log NO
12 ONLINE /oradata/orcl/redo12b.log NO

到此 RAC的新redolog 就增加完了


--------------------------------------分割线 --------------------------------------


--------------------------------------分割线 --------------------------------------