KG
Multiplexar redologs
-- MULTIPLEXAR REDOS.
--ES UN PROCESO QUE SE PUEDE HACER EN LINEA.
set lines 200
col MEMBER format a55
select a.group#, a.member, b.bytes/1024/1024 MB, b.status from v$logfile a, v$log b
where a.group# = b.group# order by group#;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/oracle/logs/oradata/orcl/redo01.log 50 CURRENT
2 /u01/oracle/logs/oradata/orcl/redo02.log 50 INACTIVE
3 /u01/oracle/logs/oradata/orcl/redo03.log 50 INACTIVE
----- SOLO PODEMOS ELIMINAR LOS REDOS QUE SE ENCUENTREN INACTIVE
-- ELIMINAMOS EL REDO DEL GRUPO 2
ALTER DATABASE DROP LOGFILE GROUP 2;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/oracle/logs/oradata/orcl/redo01.log 50 CURRENT
3 /u01/oracle/logs/oradata/orcl/redo03.log 50 INACTIVE
--AGREGAMOS LOS REDOS DEL GRUPO 2
ALTER DATABASE ADD LOGFILE GROUP 2 ('/u01/REDOLOG/REDO02.RDO', '/u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO') SIZE 50M;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/oracle/logs/oradata/orcl/redo01.log 50 CURRENT
2 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO 50 UNUSED
2 /u01/REDOLOG/REDO02.RDO 50 UNUSED
3 /u01/oracle/logs/oradata/orcl/redo03.log 50 INACTIVE
-- ELIMINAMOS EL REDO DEL GRUPO 3
ALTER DATABASE DROP LOGFILE GROUP 3;
--AGREGAMOS LOS REDOS DEL GRUPO 2
ALTER DATABASE ADD LOGFILE GROUP 2 ('/u01/REDOLOG/REDO02.RDO', '/u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO') SIZE 50M;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/oracle/logs/oradata/orcl/redo01.log 50 CURRENT
2 /u01/REDOLOG/REDO02.RDO 50 UNUSED
2 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO 50 UNUSED
3 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO03a.RDO 50 UNUSED
3 /u01/REDOLOG/REDO03.RDO 50 UNUSED
--SE TIENE QUE MULTIPLEXAR EL REDO DEL GRUPO UNO, PERO COMO ESTA CURRENT NO PODEMOS ELIMINARLO
--APLICAMOS LOS SIGUIENTES ALTER PARA CAMBIAR EL STATUS DEL REDOLOG A INACTIVE
ALTER SYSTEM SWITCH LOGFILE;--Fuerza la escritura a un nuevo grupo de archivos redologs
o
alter system checkpoint global;-- Baja la informacion a los datafiles
ALTER SYSTEM SWITCH LOGFILE;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/oracle/logs/oradata/orcl/redo01.log 50 ACTIVE
2 /u01/REDOLOG/REDO02.RDO 50 ACTIVE
2 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO 50 ACTIVE
3 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO03a.RDO 50 CURRENT
3 /u01/REDOLOG/REDO03.RDO 50 CURRENT
alter system checkpoint global;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/oracle/logs/oradata/orcl/redo01.log 50 INACTIVE
2 /u01/REDOLOG/REDO02.RDO 50 INACTIVE
2 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO 50 INACTIVE
3 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO03a.RDO 50 CURRENT
3 /u01/REDOLOG/REDO03.RDO 50 CURRENT
-- YA QUE ESTE INACTIVO PODEMOS ELIMINAR NUESTRO GRUPO 1
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE ADD LOGFILE GROUP 1 ('/u01/REDOLOG/REDO01.RDO', '/u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO01a.RDO') SIZE 50M;
GROUP# MEMBER MB STATUS
---------- ------------------------------------------------------- ---------- ----------------
1 /u01/REDOLOG/REDO01.RDO 50 ACTIVE
1 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO01a.RDO 50 ACTIVE
2 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO02a.RDO 50 CURRENT
2 /u01/REDOLOG/REDO02.RDO 50 CURRENT
3 /u02/oracle/logs/recovery_area/ORCL/REDOLOG/REDO03a.RDO 50 ACTIVE
3 /u01/REDOLOG/REDO03.RDO 50 ACTIVE