Oracle Database Managing the Redo Log

List the current redo file and size:

set linesize 160
col MEMBER for a50
select a.GROUP#, a.THREAD#, a.BYTES/1024/1024 BYTES_MB, b.MEMBER from  V$LOG a, v$logfile b where a.GROUP# = b.GROUP#;


Add Redo log group:

ALTER DATABASE ADD LOGFILE GROUP 3 ('/diso3i/oradata/data/log03a.dbf','/diso3i/oradata/data/log03b.dbf') size 1000M;