ALTER DATABASE DROP LOGFILE GROUP XX;
  • Information redolog avec détails (n'affiche que les ONLINE)
SET linesize 400
COL "MEMBER" FORMAT A80
SELECT l.GROUP#, 
    l.THREAD#, 
    l.SEQUENCE#, 
    l.BYTES, 
    l.MEMBERS, 
    l.STATUS, 
    f.TYPE, 
    f.MEMBER 
FROM V$LOGFILE f, V$LOG l 
WHERE l.GROUP# = f.GROUP# 
ORDER BY GROUP#,MEMBER; 
  • Information redolog complet
SELECT * FROM v$logfile;
  • Status + type REDOLOG
SET linesize 200
SELECT GROUP#, BYTES, STATUS, 'ONLINE' AS TYPE FROM V$LOG
UNION
SELECT GROUP#, BYTES, STATUS, 'STANDBY' AS TYPE FROM V$STANDBY_LOG
ORDER BY 1;