eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.DBA_REDO_LOG

Source

View Text - Preformatted


SELECT
    S.DBID                 DBID,
    S.GLOBAL_DBNAME        GLOBAL_DBNAME,
    S.DBUNAME              DBUNAME,
    S.VERSION              VERSION,
    S.THREAD#              THREAD#,
    S.RESETLOGS_SCN        RESETLOGS_SCN,
    S.RESETLOGS_TIME       RESETLOGS_TIME,
    S.PRESETLOGS_SCN       PRESETLOGS_SCN,
    S.PRESETLOGS_TIME      PRESETLOGS_TIME,
    S.SEQUENCE#            SEQUENCE#,
    S.DUPID                DUPID,
    S.STATUS1              LOG_TYPE,
    S.STATUS2              LOG_STATE,
    S.CREATE_TIME          CREATE_TIME,
    S.CLOSE_TIME           CLOSE_TIME,
    S.DONE_TIME            DONE_TIME,
    S.FIRST_SCN            FIRST_SCN,
    S.FIRST_TIME           FIRST_TIME,
    S.NEXT_SCN             NEXT_SCN,
    S.NEXT_TIME            NEXT_TIME,
    S.BLOCKS               BLOCKS,
    S.BLOCK_SIZE           BLOCK_SIZE,
    S.CREATE_DATE          CREATE_DATE,
    S.ERROR1               ERROR1,
    S.ERROR2               ERROR2,
    S.FILENAME             FILENAME,
    S.TS1                  TS1,
    S.TS2                  TS2,
    S.TS3                  TS3,
    S.ENDIAN               ENDIAN,
    S.OLD_BLOCKS           OLD_BLOCKS,
    S.OLD_STATUS1          OLD_LOG_TYPE,
    S.OLD_STATUS2          OLD_LOG_STATE,
    S.OLD_FILENAME         OLD_FILENAME
  FROM SYSTEM.REDO_LOG S

View Text - HTML Formatted

SELECT S.DBID DBID
, S.GLOBAL_DBNAME GLOBAL_DBNAME
, S.DBUNAME DBUNAME
, S.VERSION VERSION
, S.THREAD# THREAD#
, S.RESETLOGS_SCN RESETLOGS_SCN
, S.RESETLOGS_TIME RESETLOGS_TIME
, S.PRESETLOGS_SCN PRESETLOGS_SCN
, S.PRESETLOGS_TIME PRESETLOGS_TIME
, S.SEQUENCE# SEQUENCE#
, S.DUPID DUPID
, S.STATUS1 LOG_TYPE
, S.STATUS2 LOG_STATE
, S.CREATE_TIME CREATE_TIME
, S.CLOSE_TIME CLOSE_TIME
, S.DONE_TIME DONE_TIME
, S.FIRST_SCN FIRST_SCN
, S.FIRST_TIME FIRST_TIME
, S.NEXT_SCN NEXT_SCN
, S.NEXT_TIME NEXT_TIME
, S.BLOCKS BLOCKS
, S.BLOCK_SIZE BLOCK_SIZE
, S.CREATE_DATE CREATE_DATE
, S.ERROR1 ERROR1
, S.ERROR2 ERROR2
, S.FILENAME FILENAME
, S.TS1 TS1
, S.TS2 TS2
, S.TS3 TS3
, S.ENDIAN ENDIAN
, S.OLD_BLOCKS OLD_BLOCKS
, S.OLD_STATUS1 OLD_LOG_TYPE
, S.OLD_STATUS2 OLD_LOG_STATE
, S.OLD_FILENAME OLD_FILENAME
FROM SYSTEM.REDO_LOG S