查看日志
SQL> set linesize 1000
SQL> /
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---
3 ONLINE /u01/oracle/oradata/yws/redo03.log NO
2 ONLINE /u01/oracle/oradata/yws/redo02.log NO
1 ONLINE /u01/oracle/oradata/yws/redo01.log NO
SQL> alter database add logfile thread 2 group 4 '/u01/oracle/oradata/yws/redo04.log' size 10m;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 2 52428800 1 NO CURRENT 456945 05-NOV-13
2 1 0 52428800 1 YES UNUSED 0
3 1 1 52428800 1 NO INACTIVE 446075 28-OCT-13
4 2 0 10485760 1 YES UNUSED 0
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 2 52428800 1 NO ACTIVE 456945 05-NOV-13
2 1 3 52428800 1 NO CURRENT 480948 18-NOV-13
3 1 1 52428800 1 NO INACTIVE 446075 28-OCT-13
4 2 0 10485760 1 YES UNUSED 0
SQL> /
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 2 52428800 1 NO ACTIVE 456945 05-NOV-13
2 1 3 52428800 1 NO CURRENT 480948 18-NOV-13
3 1 1 52428800 1 NO INACTIVE 446075 28-OCT-13
4 2 0 10485760 1 YES UNUSED 0
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 5 52428800 1 NO CURRENT 480958 18-NOV-13
2 1 3 52428800 1 NO INACTIVE 480948 18-NOV-13
3 1 4 52428800 1 NO INACTIVE 480954 18-NOV-13
4 2 0 10485760 1 YES UNUSED 0
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 17 52428800 1 NO CURRENT 480984 18-NOV-13
2 1 15 52428800 1 NO INACTIVE 480980 18-NOV-13
3 1 16 52428800 1 NO INACTIVE 480982 18-NOV-13
4 2 0 10485760 1 YES UNUSED 0
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 23 52428800 1 NO INACTIVE 481569 18-NOV-13
2 1 24 52428800 1 NO CURRENT 481571 18-NOV-13
3 1 22 52428800 1 NO INACTIVE 481567 18-NOV-13
4 2 0 10485760 1 YES UNUSED 0
SQL> alter database add logfile thread 2 group 5 '/u01/oracle/oradata/yws/redo05.redo' size 10m;
Database altered.
SQL> alter database enable public thread 2;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
/
System altered.
SQL>
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL>
SQL> /
System altered.
SQL> /
System altered.
SQL> alter database disable thread 2;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
/
/
System altered.
SQL>
System altered.
SQL> /
System altered.
SQL> select * from v$Log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 50 52428800 1 NO INACTIVE 484086 19-NOV-13
2 1 51 52428800 1 NO INACTIVE 484088 19-NOV-13
3 1 52 52428800 1 NO CURRENT 484090 19-NOV-13
4 2 1 10485760 2 NO INACTIVE 483037 18-NOV-13
5 2 0 10485760 1 YES UNUSED 0
SQL>
SQL> select * from v$Log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 50 52428800 1 NO INACTIVE 484086 19-NOV-13
2 1 51 52428800 1 NO INACTIVE 484088 19-NOV-13
3 1 52 52428800 1 NO CURRENT 484090 19-NOV-13
4 2 1 10485760 2 NO INACTIVE 483037 18-NOV-13
5 2 0 10485760 1 YES UNUSED 0
SQL> alter database drop logfile group 5;
Database altered.
SQL> alter database drop logfile group 4;
Database altered.
SQL> select * from v$Log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 50 52428800 1 NO INACTIVE 484086 19-NOV-13
2 1 51 52428800 1 NO INACTIVE 484088 19-NOV-13
3 1 52 52428800 1 NO CURRENT 484090 19-NOV-13
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29477587/viewspace-1128380/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29477587/viewspace-1128380/