1.Creating Redo Log Groups and Members
a) Creating Redo Log Groups:
Alter Database Add Logfile ('D:\oracle\product\10.2.0\oradata\orcl\loga1.rdo','D:\oracle\product\10.2.0\oradata\orcl\loga2.rdo') SIZE 10M;
Or
Alter Database Add Logfile Group 10 ('D:\oracle\product\10.2.0\oradata\orcl\loga1.rdo','D:\oracle\product\10.2.0\oradata\orcl\loga2.rdo') SIZE 10M;
select * from v$log;
b) Creating Redo Log Members:
Alter Database Add Logfile Member 'D: