SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- -----------------------------------------------
IS_
---
1 ONLINE E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
NO
2 ONLINE E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
NO
3 ONLINE E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
NO
修改日志文件大小为1M;SQL> alter database add logfile group 4('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 1M;
alter database add logfile group 4('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 1M
*
第 1 行出现错误:
ORA-00336: 大小为 2048 的日志文件块数小于最小8192 块数
SQL> alter database add logfile group 4 ('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 2M;
alter database add logfile group 4 ('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 2M
*
第 1 行出现错误:
ORA-00336: 大小为 2048 的日志文件块数小于最小 8192 块数
SQL> alter database add logfile group 4 ('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 3M;
alter database add logfile group 4 ('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 3M
*
第 1 行出现错误:
ORA-00336: 大小为 2048 的日志文件块数小于最小 8192 块数
SQL> alter database add logfile group 4('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 4M;
数据库已更改。
SQL> alter database add logfile group 5('E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOG') size 4M;
数据库已更改。
切换日志到新建日志组
SQL> alter system switch logfile;
系统已更改。
SQL> alter system switch logfile;
系统已更改。
SQL> selectgroup#,members,bytes/1024/1024,status from v$log;
GROUP# MEMBERS BYTES/1024/1024STATUS
---------- ---------- --------------- ----------------
1 1 100 INACTIVE
2 1 100 ACTIVE
3 1 100 INACTIVE
4 1 4 ACTIVE
5 1 4 CURRENT