由于日志切换过于频繁,今天调整了一下日志文件大小,数据库为Oracle10g 10.1.0.3.0.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bi
PL/SQL Release 10.1.0.3.0 - Production
CORE 10.1.0.3.0 Production
TNS for Solaris: Version 10.1.0.3.0 - Production
NLSRTL Version 10.1.0.3.0 - Production
|
调整步骤如下:
SQL> col member for a50
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS
---------- ------- ------- ---------------------------------------- ---
3 ONLINE +DATADG/mmsdb/onlinelog/group_3.274.1 NO
3 ONLINE +DATADG/mmsdb/onlinelog/group_3.275.1 NO
2 ONLINE +DATADG/mmsdb/onlinelog/group_2.272.1 NO
2 ONLINE +DATADG/mmsdb/onlinelog/group_2.273.1 NO
1 ONLINE +DATADG/mmsdb/onlinelog/group_1.270.1 NO
1 ONLINE +DATADG/mmsdb/onlinelog/group_1.271.1 NO
1 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_1_15dbl80x_.log YES
2 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_2_15dbl8l1_.log YES
3 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_3_15dbl93s_.log YES
9 rows selected.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
-------- ---------- ---------- ---------- ---------- --- ---------- ------------- ------------
1 1 17717 10485760 3 NO CURRENT 178164478 06-DEC-05
2 1 17715 10485760 3 YES INACTIVE 178137459 06-DEC-05
3 1 17716 10485760 3 YES ACTIVE 178149970 06-DEC-05
SQL> alter database add logfile group 4 size 30m;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
3 ONLINE +DATADG/mmsdb/onlinelog/group_3.274.1 NO
3 ONLINE +DATADG/mmsdb/onlinelog/group_3.275.1 NO
2 ONLINE +DATADG/mmsdb/onlinelog/group_2.272.1 NO
2 ONLINE +DATADG/mmsdb/onlinelog/group_2.273.1 NO
1 ONLINE +DATADG/mmsdb/onlinelog/group_1.270.1 NO
1 ONLINE +DATADG/mmsdb/onlinelog/group_1.271.1 NO
1 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_1_15dbl80x_.log YES
2 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_2_15dbl8l1_.log YES
3 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_3_15dbl93s_.log YES
4 ONLINE +DATADG/mmsdb/onlinelog/group_4.291.1 NO
4 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_4_1s9yx01j_.log YES
11 rows selected.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------- ------------- ------------
1 1 17759 10485760 3 YES INACTIVE 178672877 06-DEC-05
2 1 17760 10485760 3 YES INACTIVE 178683645 06-DEC-05
3 1 17761 10485760 3 YES ACTIVE 178694045 06-DEC-05
4 1 17762 31457280 2 NO CURRENT 178703002 06-DEC-05
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database add logfile group 2 size 30m;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ----------- ------------- -----------
1 1 17759 10485760 3 YES INACTIVE 178672877 06-DEC-05
2 1 0 31457280 2 YES UNUSED 0
3 1 17761 10485760 3 YES INACTIVE 178694045 06-DEC-05
4 1 17762 31457280 2 NO CURRENT 178703002 06-DEC-05
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database add logfile group 3 size 30m;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- --------- ------------- ------------
1 1 17759 10485760 3 YES INACTIVE 178672877 06-DEC-05
2 1 0 31457280 2 YES UNUSED 0
3 1 0 31457280 2 YES UNUSED 0
4 1 17762 31457280 2 NO CURRENT 178703002 06-DEC-05
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database add logfile group 1 size 30m;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
3 ONLINE +DATADG/mmsdb/onlinelog/group_3.275.3 NO
3 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_3_1s9z8pb6_.log YES
2 ONLINE +DATADG/mmsdb/onlinelog/group_2.273.3 NO
2 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_2_1s9yzv0f_.log YES
1 ONLINE +DATADG/mmsdb/onlinelog/group_1.271.3 NO
1 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_1_1s9z9rpy_.log YES
4 ONLINE +DATADG/mmsdb/onlinelog/group_4.291.1 NO
4 ONLINE /msflsh/MMSDB/onlinelog/o1_mf_4_1s9yx01j_.log YES
8 rows selected.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------- ------------- ------------
1 1 0 31457280 2 YES UNUSED 0
2 1 0 31457280 2 YES UNUSED 0
3 1 0 31457280 2 YES UNUSED 0
4 1 17762 31457280 2 NO CURRENT 178703002 06-DEC-05
|
Ok,现在开始提问,在以上的输出中,你可以指出多少个知识点?
如果我就以上输出来提问,会有多少知识是你不知道的?
