3.4 显示归档信息

来源：互联网发布：孕期计算方法知乎编辑：程序博客网时间：2024/05/05 16:16

1. 使用 ARCHIVE LOG LIST 命令

SQL> archive log list
数据库日志模式            存档模式
自动存档             启用
存档终点            d:/demo/archive
最早的联机日志序列     1
下一个存档日志序列   3
当前日志序列           3

2. 显示日志操作模式

SQL> select name, log_mode from v$database;

NAME LOG_MODE
--------- ------------
DEMO ARCHIVELOG

3.显示归档日志信息

SQL> select name, sequence#, first_change# from v$archived_log;

未选定行

name：归档日志文件名 sequence#：归档日志对应的日志序列号 first_change#：归档日志的起始SCN值。

4. 显示归档日志位置

SQL> col dest_name format a20
SQL> col destination format a20
SQL> select dest_name, destination, status from v$archive_dest;

DEST_NAME            DESTINATION          STATUS
-------------------- -------------------- ---------
LOG_ARCHIVE_DEST_1   c:/demo/archive      VALID
LOG_ARCHIVE_DEST_2   d:/demo/archive      VALID
LOG_ARCHIVE_DEST_3   orcl                 DISABLED
LOG_ARCHIVE_DEST_4                        INACTIVE
LOG_ARCHIVE_DEST_5                        INACTIVE
LOG_ARCHIVE_DEST_6                        INACTIVE
LOG_ARCHIVE_DEST_7                        INACTIVE
LOG_ARCHIVE_DEST_8                        INACTIVE
LOG_ARCHIVE_DEST_9                        INACTIVE
LOG_ARCHIVE_DEST_10                       INACTIVE

已选择10行。

5. 显示日志历史信息

SQL> select * from v$loghist;

   THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME     SWITCH_CHANGE#
---------- ---------- ------------- -------------- --------------
         1          1        534907 02-9月 -08             543144
         1          2        543144 02-9月 -08             575915

6. 显示归档进程信息

SQL> set pagesize 50
SQL> select * from v$archive_processes;

   PROCESS STATUS     LOG_SEQUENCE STATE
---------- ---------- ------------ ----
         0 ACTIVE                0 IDLE
         1 ACTIVE                0 IDLE
         2 ACTIVE                0 IDLE
         3 STOPPED               0 IDLE
         4 STOPPED               0 IDLE
         5 STOPPED               0 IDLE
         6 STOPPED               0 IDLE
         7 STOPPED               0 IDLE
         8 STOPPED               0 IDLE
         9 STOPPED               0 IDLE
        10 STOPPED               0 IDLE
        11 STOPPED               0 IDLE
        12 STOPPED               0 IDLE
        13 STOPPED               0 IDLE
        14 STOPPED               0 IDLE
        15 STOPPED               0 IDLE
        16 STOPPED               0 IDLE
        17 STOPPED               0 IDLE
        18 STOPPED               0 IDLE
        19 STOPPED               0 IDLE
        20 STOPPED               0 IDLE
        21 STOPPED               0 IDLE
        22 STOPPED               0 IDLE
        23 STOPPED               0 IDLE
        24 STOPPED               0 IDLE
        25 STOPPED               0 IDLE
        26 STOPPED               0 IDLE
        27 STOPPED               0 IDLE
        28 STOPPED               0 IDLE
        29 STOPPED               0 IDLE

已选择30行。