myorama
2/17/2017 - 3:02 PM

Increase redolog groups

Increase redolog groups

select group#,members,status,bytes/1024/1024 as mb from v$log;
alter database add logfile ('+DATA', '+DATA') size 100m;
...
alter database drop logfile group 1;
...
alter system switch logfile;
alter system checkpoint;