How To Check Redo Logs And Their Size and Add Redo Logs to an Oracle Database ?

Answer >  Connect to the Oracle Database and execute the following.

SQL> select group#, status, bytes/1024/1024 from V$log;
                                OR
SQL> select member, status from V$logfile;

You will get all the information from the above statements.

Now, add the redo logfiles using the following commands :

alter database add logfile group 1 'E:\APP\ORACLE\ORADATA\PKT009\REDO01.LOG' size 50M;

alter database add logfile group 2 'E:\APP\ORACLE\ORADATA\PKT009\REDO2.LOG' size 50M;

alter database add logfile group 3 'E:\APP\ORACLE\ORADATA\PKT009\REDO3.LOG' size 50M;

alter database add logfile group 4 'E:\APP\ORACLE\ORADATA\PKT009\REDO4.LOG' size 50M;

alter database add logfile group 5 'E:\APP\ORACLE\ORADATA\PKT009\REDO5.LOG' size 50M;

alter database add logfile group 6 'E:\APP\ORACLE\ORADATA\PKT009\REDO6.LOG' size 50M;

alter database add logfile group 7 'E:\APP\ORACLE\ORADATA\PKT009\REDO7.LOG' size 50M;

alter database add logfile group 8 'E:\APP\ORACLE\ORADATA\PKT009\REDO8.LOG' size 50M;

Note : You can modify the path and size accordingly.