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行。
