環境:

OS:Red Hat Linux As 5

DB:11.2.0.1(ASM)

1.檢視當前日誌大小
SQL> Select Group#,bytes/1024/1024 "Size(M)" From v$log;

    GROUP#       Size
---------- ----------
         1         50
         2         50
         3         50

2.新增redo日誌組
alter database add logfile group 4 ('+DATA', '+RECDATA') size 128m;
alter database add logfile group 5 ('+DATA', '+RECDATA') size 128m;
alter database add logfile group 6 ('+DATA', '+RECDATA') size 128m;

3.檢視當前的日誌組狀態
SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CURRENT
         2 INACTIVE
         3 INACTIVE
         4 UNUSED
         5 UNUSED
         6 UNUSED

6 rows selected.

切換日誌,使日誌狀態轉換為INACTIVE
alter system switch logfile;

刪除狀態為INACTIVE的日誌組
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

4.重新建立日誌組(1 2 3),重新定義大小
alter database add logfile group 1 ('+DATA', '+RECDATA') size 128m;
alter database add logfile group 2 ('+DATA', '+RECDATA') size 128m;
alter database add logfile group 3 ('+DATA', '+RECDATA') size 128m;

5.檢視日誌組
SQL> Select Group#,bytes/1024/1024 "Size" From v$log;

    GROUP#       Size
---------- ----------
         1        128
         2        128
         3        128
         4        128
         5        128
         6        128

6 rows selected.

這樣每個日誌組的大小由之前的50M修改為128M.

-- The End --

新增日誌組以及調整日誌的大小

相關文章