Adding redo log groups in one command in Oracle database

  

-: For Single Instance :- Adding Online Redo log groups - Single Instance: #Groups to be added are group#4, group#5, group#6. SQL> set lines 300 pages 3000 SQL> col member for a70 SQL> select group#,type,member from v$logfile order by 1; GROUP# TYPE    MEMBER ------ ------- ----------------------------------------------      1 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO1.LOG      2 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO2.LOG      3 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO3.LOG SQL> alter database add logfile group 4 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO4.log' size 200m, group 5 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO5.log' size 200m, group 6 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO6.log' size 200m; Database altered. SQL> set lines 300 pages 3000 SQL> col member for a70 SQL> select group#,type,member from v$logfile order by 1; GROUP# TYPE    MEMBER ------ ------- ----------------------------------------------      1 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO1.LOG      2 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO2.LOG      3 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO3.LOG      4 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO4.LOG      5 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO5.LOG      6 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO6.LOG Adding Standby Redo log groups - Single Instance: #Groups to be added are group#11, group#12, group#13, group#14. SQL> select group#,type,member from v$logfile where type='STANDBY' order by 1; no rows selected SQL> alter database add standby logfile group 11 'D:\RUPESH\Setups\TEST\TEST\SRLs\stand11.log' size 200m, group 12   2  'D:\RUPESH\Setups\TEST\TEST\SRLs\stand12.log' size 200m, group 13 'D:\RUPESH\Setups\TEST\TEST\SRLs\stand13.log' size 200m ; Database altered. SQL> select group#,type,member from v$logfile where type='STANDBY' order by 1; GROUP# TYPE    MEMBER ------ ------- -------------------------------------------     11 STANDBY D:\RUPESH\SETUPS\TEST\TEST\SRLS\STAND11.LOG     12 STANDBY D:\RUPESH\SETUPS\TEST\TEST\SRLS\STAND12.LOG     13 STANDBY D:\RUPESH\SETUPS\TEST\TEST\SRLS\STAND13.LOG -: For RAC - Real Application Clusters :- Adding Online Redo log groups - RAC: SQL> alter database add logfile thread 2 group 21 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO21.log' size 200m, group 22 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO22.log' size 200m, group 23 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO23.log' size 200m; Database altered. Adding Standby Redo log groups - RAC: SQL> alter database add standby logfile thread 2 group 31 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO31.log' size 200m, group 32 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO32.log' size 200m, group 33 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO33.log' size 200m; Database altered.