00054.Oracle重做日志信息获取

SQL> desc v$log

 Name                                     Null?    Type

 ----------------------------------------- ------------------------------------

 GROUP#                                            NUMBER

 THREAD#                                           NUMBER

 SEQUENCE#                                         NUMBER

 BYTES                                              NUMBER

 BLOCKSIZE                                         NUMBER

 MEMBERS                                           NUMBER

 ARCHIVED                                          VARCHAR2(3)

 STATUS                                            VARCHAR2(16)

 FIRST_CHANGE#                                      NUMBER

 FIRST_TIME                                         DATE

 NEXT_CHANGE#                                       NUMBER

 NEXT_TIME                                          DATE

SQL> col statusfor a15

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

    GROUP# SEQUENCE#    MEMBERS      BYTES STATUS          ARCHIV

-------------------- ---------- ---------- --------------- ------

         1         37          1  524288000 CURRENT         NO

         2         35          1  524288000 INACTIVE        YES

         3         36          1  524288000 INACTIVE        YES

SQL> desc dict

 Name                                     Null?    Type

 ------------------------------------------------- ----------------------------

 TABLE_NAME                                        VARCHAR2(30)

 COMMENTS                                          VARCHAR2(40000)

 

SQL> coltable_name for a50

SQL> colcomments for a50

SQL> set line120

SQL> col table_namefor a25

SQL> set line130

SQL> select  table_name,comments from dict where table_name like '%v$logf%';

TABLE_NAME                                        COMMENTS

----------------------------------------------------------------------------------------------------

V$LOGFILE                                         Synonym for V_$LOGFILE

GV$LOGFILE                                        Synonym for GV_$LOGFILE

S SQL> desc  v$logfile

 Name         Null?    Type

 ----------------------- -------- --------------

 GROUP#                  NUMBER

 STATUS                   VARCHAR2(7)

 TYPE                    VARCHAR2(7)

 MEMBER                VARCHAR2(513)

 IS_RECOVERY_DEST_FILE   VARCHAR2(3)

SQL> col memberfor a30

SQL> select  group#,status,type,member from v$logfile;

    GROUP# STATUS          TYPE            MEMBER

------------------------- --------------- ------------------------------

         3                 ONLINE          /home/oracle/oracle/oradata/md

                                           sp/redo03.log

 

         2                 ONLINE          /home/oracle/oracle/oradata/md

                                          sp/redo02.log

 

         1                 ONLINE          /home/oracle/oracle/oradata/md

                                           sp/redo01.log