Thursday, 10 November 2016

[Oracle] How to check Archive Log Mode (아카이브 로그 모드 확인)






Online Archive log check


------------------------------------------------------------------------------
-- Redo Log Group, Member Information
--
-- CURRENT  : LGWR Process is in use
-- ACTIVE   : LGWR Process is not in use. But Recover is necessary
              because of transaction spending long time
-- INACTIVE : LGWR Process is not in use and Recovery is not necessary
------------------------------------------------------------------------------
SELECT GROUP#
     , MEMBERS
     , BYTES
     , ARCHIVED
     , STATUS
FROM V$LOG;




------------------------------
-- Redo Log File Information
------------------------------
SELECT GROUP#
    ,  STATUS
    ,  MEMBER
FROM V$LOGFILE;

No comments:

Post a Comment