_____________________________________________________________________________________ MANAGING THE REDO LOG https://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo.htm#ADMIN007 _____________________________________________________________________________________ -- for OMF show parameter db_create_online_log_dest column member format a60 select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6; alter database add logfile group 4 ('/u02/app/oracle/oralog/ORCL/redo04a.dbf','/u03/app/oracle/oramir/ORCL/redo04b.dbf') size 50M; alter database add logfile group 5 ('/u02/app/oracle/oralog/ORCL/redo05a.dbf','/u03/app/oracle/oramir/ORCL/redo05b.dbf') size 50M; alter database add logfile group 6 ('/u02/app/oracle/oralog/ORCL/redo06a.dbf','/u03/app/oracle/oramir/ORCL/redo06b.dbf') size 50M; select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6; alter system switch logfile; alter system checkpoint; select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6; alter database drop logfile group 1; alter database drop logfile group 2; alter database drop logfile group 3; select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6; alter database add logfile group 1 ('/u02/app/oracle/oralog/ORCL/redo01a.dbf','/u03/app/oracle/oramir/ORCL/redo01b.dbf') size 50M; alter database add logfile group 2 ('/u02/app/oracle/oralog/ORCL/redo02a.dbf','/u03/app/oracle/oramir/ORCL/redo02b.dbf') size 50M; alter database add logfile group 3 ('/u02/app/oracle/oralog/ORCL/redo03a.dbf','/u03/app/oracle/oramir/ORCL/redo03b.dbf') size 50M; select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6; alter system switch logfile; alter system checkpoint; select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6; alter database drop logfile group 4; alter database drop logfile group 5; alter database drop logfile group 6; select l.group#, l.members, l.archived, l.status, f.type, f.member, l.bytes/1024/1024 "MB" from v$log l, v$logfile f where l.group# = f.group# order by 1, 6;