SQL> alter database add logfile size 10m;
Database altered
SQL> show parameter create
NAME TYPE VALUE
------------------------------------ ----------- ---------------------
create_bitmap_area_size integer 8388608
create_stored_outlines string
db_create_file_dest string /u01/oradata
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
SQL> select group#, sequence#, bytes, members, status from v$log;
GROUP# SEQUENCE# BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1 217 52428800 2 INACTIVE
2 218 52428800 2 CURRENT
3 216 52428800 2 INACTIVE
4 0 10485760 2 UNUSED
5 0 10485760 2 UNUSED
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- -----------------------------------------------------------
（篇幅原因，部分省略……）
1 /u01/oradata/WILSON/onlinelog/o1_mf_1_6bcsqpty_.log
1 /u01/flash_recovery_area/WILSON/onlinelog/o1_mf_1_6bcsqqt0_.log
4 /u01/oradata/WILSON/onlinelog/redo4a.log
4 /u01/flash_recovery_area/WILSON/onlinelog/redo4b.log
5 /u01/oradata/WILSON/onlinelog/o1_mf_5_7vqh94p2_.log
5 /u01/flash_recovery_area/WILSON/onlinelog/o1_mf_5_7vqh94t6_.log
10 rows selected
üActive状态日志组解决