Redo log files are used to record data changes to the database. The redo log files are initially specified within the CREATE DATABASE command.
The Redo Logs must be dropped and recreated for changing the redo log size.
It can be done online without shutting down the database. However, you need to make sure that the Redo Group being dropped should be INACTIVE when you do this and check the status using the command below.
SQL > select group#,members,status,bytes/1024/1024 as mb from v$log;
and then do the following steps:
- SQL > alter database add logfile group x ( ‘c:\log\log0101.log’,’d:\log\log0102.log’ ) size xM;
- Switch to make it current
SQL >alter database switch logfile;
3. Drop the exisiting redo log files
SQL> alter database drop logfile group x; —– In order to drop it, but it’s status should be inactive
4.Recreate redo log files with desired size in the place of the deleted log files.
SQL > alter database add logfile group 1 ‘E:\APP\ADMINISTRATOR\ORADATA\CCDB\REDO01.LOG’ size 300M;
SQL> alter database add logfile group 2 ‘E:\APP\ADMINISTRATOR\ORADATA\CCDB\REDO02.LOG’ size 100M;