--MELIHAT REDO LOG FILE
select * from V$LOGFILE a, V$LOG b where a.GROUP# = b.GROUP#
--MENAMBAH REDO LOG FILE
ALTER DATABASE ADD LOGFILE ('/opt/oracle/oradata/orcl/redo04.log') SIZE 524288000;
ALTER DATABASE ADD LOGFILE ('/opt/oracle/oradata/orcl/redo05.log') SIZE 524288000;
ALTER DATABASE ADD LOGFILE ('/opt/oracle/oradata/orcl/redo06.log') SIZE 524288000;
--MENGHAPUS REDO LOG FILE
--REDO LOG HANYA DAPAT DI HAPUS KETIKA STATUS INACTIVE // LAKUKAN SWITCH DAN CHECKPOINT
ALTER DATABASE drop LOGFILE GROUP 1;
ALTER DATABASE drop LOGFILE GROUP 2;
ALTER DATABASE drop LOGFILE GROUP 3;
--MEMINDAH REDOLOG FILE
ALTER SYSTEM SWITCH LOGFILE;
--CEKPOIN REDOLOG FILE
alter system checkpoint;
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-redo-log.html#GUID-6A7FB6CB-AF29-40BC-BDB3-B514C502B2F6
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1928361_1.html
