查看日志文件

5dm

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.