alter system archive log stop

来源：互联网发布：凤凰男知乎编辑：程序博客网时间：2024/04/29 09:47

SQL> select * from v$log;

    GROUP#    THREAD# SEQUENCE#      BYTES    MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ------
STATUS                           FIRST_CHANGE# FIRST_TIME
-------------------------------- ------------- ------------
         1          1         32    5242880          1 NO
CURRENT                                 646392 06-JUN-09

2 1 30 5242880 1 YES
ACTIVE 646374 06-JUN-09

3 1 31 5242880 1 YES
ACTIVE 646385 06-JUN-09

SQL> alter system archive log stop;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

    GROUP#    THREAD# SEQUENCE#      BYTES    MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ------
STATUS                           FIRST_CHANGE# FIRST_TIME
-------------------------------- ------------- ------------
         1          1         32    5242880          1 YES
ACTIVE                                  646392 06-JUN-09

2 1 33 5242880 1 NO
CURRENT 647177 06-JUN-09

3 1 31 5242880 1 YES
INACTIVE 646385 06-JUN-09

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

    GROUP#    THREAD# SEQUENCE#      BYTES    MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ------
STATUS                           FIRST_CHANGE# FIRST_TIME
-------------------------------- ------------- ------------
         1          1         32    5242880          1 YES
ACTIVE                                  646392 06-JUN-09

2 1 33 5242880 1 YES
ACTIVE 647177 06-JUN-09

3 1 34 5242880 1 NO
CURRENT 647181 06-JUN-09

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

    GROUP#    THREAD# SEQUENCE#      BYTES    MEMBERS ARCHIV
---------- ---------- ---------- ---------- ---------- ------
STATUS                           FIRST_CHANGE# FIRST_TIME
-------------------------------- ------------- ------------
         1          1         35    5242880          1 NO
CURRENT                                 647187 06-JUN-09

2 1 33 5242880 1 YES
INACTIVE 647177 06-JUN-09

3 1 34 5242880 1 YES
INACTIVE 647181 06-JUN-09

SQL> alter system archive log start;

System altered.

SQL>