-- Check OMF se está habilitado
SHOW PARAMETER db_create_file_dest;

-- ALTERAR O REDO LOG ATIVO
ALTER SYSTEM SWITCH LOGFILE;

--ADICIONAR REDO:
ALTER DATABASE ADD LOGFILE GROUP X SIZE 500M;

ALTER DATABASE ADD LOGFILE MEMBER '/ora01/oradata/LAB/redo0102.log' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER '/ora01/oradata/LAB/redo0202.log' TO GROUP 2;

-- REMOVER GRUPO
ALTER DATABASE DROP LOGFILE GROUP X;

-- REMOVER MEMBRO
ALTER DATABASE DROP LOGFILE MEMBER '/ora01/oradata/LAB/redo01.log';
ALTER DATABASE DROP LOGFILE MEMBER '/ora01/oradata/LAB/redo02.log';

-- ARQUIVAR O ATUAL
ALTER SYSTEM ARCHIVE LOG CURRENT;

-- LIMPAR
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

-- TAMANHO DO REDO LOG
SELECT GROUP#,THREAD#,SEQUENCE#,BYTES/1024/1024,MEMBERS,STATUS FROM V$LOG;

SELECT  
	A.GROUP#, A.THREAD#, A.SEQUENCE#, A.ARCHIVED, A.STATUS,
	B.MEMBER AS REDOLOG_FILE_NAME, (A.BYTES/1024/1024) AS SIZE_MB
FROM V$LOG A
JOIN V$LOGFILE B ON A.GROUP#=B.GROUP#
ORDER BY A.GROUP#;

SELECT l.GROUP#, 
       l.BYTES / 1024 / 1024 AS SIZE_MB, 
       f.MEMBER 
FROM V$LOG l, V$LOGFILE f WHERE l.GROUP# = f.GROUP# ORDER BY l.GROUP#;

-- VIEWs: 
SELECT * FROM V$LOG			-- Exibe as informações do arquivo redo log do arquivo de controle
SELECT * FROM V$LOGFILE		--Identifica grupos de redo log e membros e status do membro
SELECT * FROM V$LOG_HISTORY	--Contém informações do histórico de log