Expand log groups

1. View log group information.

select * from v$log;

 

This example adds four disk groups to both thread 1 and thread 2.

 

2. Add disk groups.

alter database add logfile thread 1 group 13 ('+LOG/orcl/onlinelog/redo03.dbf') size 10240M reuse;

alter database add logfile thread 2 group 18 ('+LOG/orcl/onlinelog/redo08.dbf') size 10240M reuse;

Table-1 Parameters

Parameter	Description
thread 1	Thread number.
group 13	Log group name. You must specify the log group name when deleting logs.
LOG	Log disk group name.
Orcl	Database instance name.
status	Log group status: inactive—Not in use and deletable. current—In use and not deletable.

 

3. Delete the existing log table.

• If a log group to delete is in use, execute the alter system switch logfile; command to switch log groups.

• When the target log group changes to inactive state, use the alter database drop logfile group group number; command to delete it.

• The database uses at least two log groups. You must create a log group before you delete one.