There is no
direct way of changing the size of the members of a redo log group (Example group 1).
Instead,
create new redo log group with different sizes and remove the old group.
sql> alter database add
logfile group 3 ('disk2/log8.log') size 50M;
Note:
You need a
minimum of 2 logs for the database to run.
Group
number should be a number that does not currently exist and size would be the
desired size of the new redo log.
sql> alter system
switch logfile;
Perform
this statement to drop group 1
sql> alter database
drop logfile group 1;
· You can only drop a redo log member/group only if it is not an active
group.
·
If
you want to drop a member of an active group, first force a log switch to
occur.
Manual Steps:
When an
online redo log member is dropped from the database, the operating system file
is not deleted from disk. The control files of the associated database are
updated to drop the member from the database structure. After dropping an
online redo log file, make sure that the drop completed successfully, and then
use the appropriate operating system command to delete online redo log file.
