檢視日誌
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

給例項新增額外的thread

相關文章