查看归档日志文件信息-CSDN博客

两个命令,以备查看.

[@more@]

查询归档日志文件状态:

select group#,sequence#,members,archived,status,bytes
2 from v$log;

GROUP# SEQUENCE# MEMBERS ARC STATUS BYTES
---------- ---------- ---------- --- ---------------- ----------
1 384 3 YES INACTIVE 15728640
2 385 3 YES INACTIVE 15728640
3 386 3 NO CURRENT 15728640
4 383 3 YES INACTIVE 15728640
5 382 3 YES INACTIVE 15728640
查询归档日志文件所在目录和文件名

select group#,status,type,member,IS_RECOVERY_DEST_FILE
2 from v$logfile;

GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST
---------- ------- ------- ------------------------------------------------------- ----------------
3 ONLINE /home/oracle/backup/disk3/ORAL/onlinelog/redo03a.log NO
2 ONLINE /home/oracle/backup/disk3/ORAL/onlinelog/redo02a.log NO
1 ONLINE /home/oracle/backup/disk3/ORAL/onlinelog/redo01a.log NO
4 ONLINE /home/oracle/backup/disk3/ORAL/onlinelog/redo04a.log NO
4 ONLINE /home/oracle/backup/disk6/ORAL/onlinelog/redo04b.log NO
4 ONLINE /home/oracle/backup/disk9/ORAL/onlinelog/redo04c.log NO
5 ONLINE /home/oracle/backup/disk3/ORAL/onlinelog/redo05a.log NO
5 ONLINE /home/oracle/backup/disk6/ORAL/onlinelog/redo05b.log NO
5 ONLINE /home/oracle/backup/disk9/ORAL/onlinelog/redo05c.log NO
3 ONLINE /home/oracle/backup/disk6/ORAL/onlinelog/redo03b.log NO
3 ONLINE /home/oracle/backup/disk9/ORAL/onlinelog/redo03c.log NO
1 ONLINE /home/oracle/backup/disk6/ORAL/onlinelog/redo01b.log NO
1 ONLINE /home/oracle/backup/disk9/ORAL/onlinelog/redo01c.log NO
2 ONLINE /home/oracle/backup/disk6/ORAL/onlinelog/redo02b.log NO
2 ONLINE /home/oracle/backup/disk9/ORAL/onlinelog/redo02c.log NO