L> select * from V $ log;
Group # thread # sequence # bytes blocksize members arc status first_change # first_tim next_change # next_time
--------------------------------------------------------------------------------------------------------------------------
1 1 443 52428800 512 2 no current 3.0990e + 10 10-dec-12 2.8147e + 14 10-dec-12
2 1 442 52428800 512 2 Yes inactive 3.0990e + 10 09-dec-12 3.0990e + 10 09-dec-12
3 2 289 52428800 512 2 Yes active 3.0990e + 10 10-dec-12 3.0990e + 10 10-dec-12
4 2 288 52428800 512 2 Yes inactive 3.0990e + 10 08-dec-12 3.0990e + 10 10-dec-12
Select * from V $ logfile;
Group # status type member is _
-----------------------------------------------------------------------------
1 online + data01/RAC/onlinelog/group_1.257.795262481 No
1 online + candiate/RAC/onlinelog/group_1.260.795262483 Yes
2 online + data01/RAC/onlinelog/group_2.258.795262485 No
2 online + candiate/RAC/onlinelog/group_2.261.795262487 Yes
3 online + data01/RAC/onlinelog/group_3.265.795268739 No
3 online + candiate/RAC/onlinelog/group_3.262.795268741 Yes
4 online + data01/RAC/onlinelog/group_4.266.795268751 No
4 online + candiate/RAC/onlinelog/group_4.263.795268757 Yes
Parameter file backup
Create pfile = '/home/Oracle/pfilerac. ora' from spfile = '+ data01/RAC/spfilerac. ora'
Control file backup
Alter Database Backup controlfile to trace as '/home/Oracle/controlfile. SQL'
Add online log files
Alter database add logfile thread 1 group 5' + data01/RAC/onlinelog/redo05.log 'size 50 m;
Alter database add logfile thread 2 group 6' + data01/RAC/onlinelog/redo06.log 'size 50 m;
Alter database add logfile thread 1 group 7' + data01/RAC/onlinelog/redo07.log 'size 50 m;
Alter database add logfile thread 2 group 8' + data01/RAC/onlinelog/redo08.log 'size 50 m;
Alter database add logfile thread 1 group 9' + data01/RAC/onlinelog/redo09.log 'size 50 m;
Alter database add logfile thread 2 group 10' + data01/RAC/onlinelog/redo10.log 'size 50 m;
Add log members:
Alter database add logfile member '+ data01/RAC/onlinelog/redo05a. log' to group 5;
Alter database add logfile member '+ data01/RAC/onlinelog/redo06a. log' to group 6;
Alter database add logfile member '+ data01/RAC/onlinelog/redo07a. log' to group 7;
Alter database add logfile member '+ data01/RAC/onlinelog/redo08a. log' to group 8;
Alter database add logfile member '+ data01/RAC/onlinelog/redo09a. log' to group 9;
Alter database add logfile member '+ data01/RAC/onlinelog/redo10a. log' to group 10;
Delete online logs
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
Alter database drop logfile group 4;