ITPub博客

首页 > 数字化转型 > ERP > 查看归档日志文件信息

查看归档日志文件信息

原创 ERP 作者:mfm088 时间:2006-09-28 23:22:44 0 删除 编辑

两个命令,以备查看.

[@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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/330796/viewspace-867969/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-01-14

  • 博文量
    98
  • 访问量
    1025025