重庆思庄Oracle、Redhat认证学习论坛

标题: 查看日志文件 [打印本页]

作者: 5dm 时间: 2012-11-20 15:02
标题: 查看日志文件

SQL> select * from v$logfile;

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 ONLINE
+FRA/sztech1/onlinelog/group_3.266.798486445
NO

3 ONLINE
+FRA/sztech1/onlinelog/group_3.267.798486447
YES

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---

2 ONLINE
+FRA/sztech1/onlinelog/group_2.264.798486445
NO

2 ONLINE
+FRA/sztech1/onlinelog/group_2.265.798486445

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
YES

1 ONLINE
+FRA/sztech1/onlinelog/group_1.262.798486441
NO

1 ONLINE

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
+FRA/sztech1/onlinelog/group_1.263.798486443
YES

6 rows selected.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)