{DB変更}redoロググループ/メンバーの追加/削除

https://docs.oracle.com/cd/F19136_01/admin/managing-the-redo-log.html#GUID-081AE57B-A821-4F26-97B2-4B141FDB3946

 

select * from v$log;
select * from v$logfile;
alter system switch logfile;

ALTER DATABASE
  ADD LOGFILE ('/oradata/orcl/redo04a.log', '/oradata/orcl/redo04b.log') SIZE 104857600;

select * from v$log;

alter system archive log current;

 

ALTER DATABASE DROP LOGFILE GROUP 4;

select * from v$log;

 

ALTER DATABASE ADD LOGFILE MEMBER '/oradata/orcl/redo03c.log' TO GROUP 3;

select * from v$logfile;

ALTER DATABASE DROP LOGFILE MEMBER '/oradata/orcl/redo03c.log';

select * from v$logfile;