alter system archive log stop

最新推荐文章于 2025-09-08 06:19:43 发布

原创最新推荐文章于 2025-09-08 06:19:43 发布 · 874 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Oracle

Oracle EBS

本文记录了在Oracle数据库中使用SQL命令进行归档日志状态的切换过程，包括停止归档、切换日志文件以及重新开始归档等操作，并展示了每次操作前后v$log视图的变化情况。

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>

标签

#system #archive #sql