- Newest
- Most votes
- Most comments
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:
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
Relevant content
- asked a year ago
- Accepted Answerasked 4 years ago
- asked 5 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 10 months ago