Redo Logs - Comandos Úteis

--consulta os redos
SELECT GROUP#, ARCHIVED, STATUS,bytes/1024/1024 FROM V$LOG;

col member for a40
select * from v$logfile;


--Creating Redo Log Groups
ALTER DATABASE
ADD LOGFILE ('/u02/oradata/hom4/group1.rdo') SIZE 1000m;
ALTER DATABASE
ADD LOGFILE ('/u02/oradata/hom4/group2.rdo') SIZE 1000m;
ALTER DATABASE
ADD LOGFILE ('/u02/oradata/hom4/group3.rdo') SIZE 1000m;
ALTER DATABASE
ADD LOGFILE ('/u02/oradata/hom4/group4.rdo') SIZE 1000m;


--Creating Redo Log Groups
ALTER DATABASE
ADD LOGFILE GROUP 14 ('/oracle/EQ2/mirrlogA/log_g14_m1.dbf', '/oracle/EQ2/origlogA/log_g14m2.dbf')
SIZE 300M;
--Creating Redo Log Members
ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.rdo' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2c.rdo'
TO ('/oracle/dbs/log2a.rdo', '/oracle/dbs/log2b.rdo');



--apagar um redo log group
ALTER DATABASE DROP LOGFILE GROUP 3;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 14;

--apaga um membro de um grupo de redo
ALTER DATABASE DROP LOGFILE MEMBER '/u02/oradata/hom4/redo03.log';

--Clearing a Redo Log File
ALTER DATABASE CLEAR LOGFILE GROUP 3;

--Limpa o redo, caso vc não consiga apaga-lo
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;