add additional redo log file [members] to an existing redo log file group

Oracle for RDS is managed service. so, some commands are not same as on-premise.

thus, AWS recommend to using rdsadmin functions when you performing log-related tasks.

(example)

Switching online log files : EXEC rdsadmin.rdsadmin_util.switch_logfile;

Adding 100M online redo logs : EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '100M');

Dropping online redo logs group 3 : EXEC rdsadmin.rdsadmin_util.drop_logfile(grp => 3);

i recommend to read below documentation. it explain more detail. [+] Performing common log-related tasks for Oracle DB instances - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.Log.html

You need to use the rdsadmin packages to add redo log files on RDS.

For example to add a 500m file you use the following command EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '500M');

Additional information can be found here:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.Log.html#Appendix.Oracle.CommonDBATasks.RedoLogs

Is there a way to add multiple files to an existing group in AWS RDS Oracle. according to documentation, this command should is uded to add a file, it creates a redolog file but it creates another group. Does anyone know how to add additional file to an existing group

EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '128M');

SQL> select * from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID

---

     1          1     123321  134217728        512          1 YES ACTIVE                87376019 21-AUG-23     87376680 21-AUG-23          0
     2          1     123322  134217728        512          1 NO  CURRENT               87376680 21-AUG-23   9.2954E+18                    0
     3          1     123319  134217728        512          1 YES INACTIVE              87374626 21-AUG-23     87375357 21-AUG-23          0
     4          1     123320  134217728        512          1 YES INACTIVE              87375357 21-AUG-23     87376019 21-AUG-23          0

EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '128M');

SQL> select * from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID

---

     1          1     123321  134217728        512          1 YES INACTIVE              87376019 21-AUG-23     87376680 21-AUG-23          0
     2          1     123322  134217728        512          1 YES ACTIVE                87376680 21-AUG-23     87377419 21-AUG-23          0
     3          1     123323  134217728        512          1 NO  CURRENT               87377419 21-AUG-23   9.2954E+18                    0
     4          1     123320  134217728        512          1 YES INACTIVE              87375357 21-AUG-23     87376019 21-AUG-23          0
    10          1          0  134217728        512          1 YES UNUSED                       0                      0                    0