- Newest
- Most votes
- Most comments
- Yes it is possible to change the UNDO tablespace in Oracle RDS multitenant database.
If you are using CDB config ,RDS for Oracle provides procedures for changing the UNDO tablespace for each PDB.
Changes are possible according to the following procedure, so please check that there are no problems with the test environment, etc., and then consider applying it to the prod instance.
- Creating a new UNDO tablespace
SQL> create undo tablespace ＜"NEW_UNDO"＞;
- Switch to the newly created UNDO tablespace
SQL> exec rdsadmin.rdsadmin_util.set_pdb_undo_tablespace('＜"NEW_UNDO"＞');
- Delete the original UNDO tablespace
SQL> drop tablespace ＜"OLD_UNDO"＞;
If a transaction exists at the time of deleting the original UNDO tablespace, the deletion will result in an error. Also, if an UNDO tablespace is deleted by drop tablespace in a situation where a query requiring rollback information (SELECT statement that has been running for a long time, etc.) is being executed, the query may lead to an error [1]. Therefore, we hope you can consider deleting it when the query has not been executed.
- Are there any limitations in RDS compared to on-premise Oracle for UNDO management? There is no major limitation apart from the procedure is bit different in Oracle RDS.
[1] Managing UNDO https://docs.oracle.com/cd/F19136_01/admin/managing-undo.html#GUID-825E2A2F-7AEB-4D7A-B8BA-B1533D7BE512
Based on the available information about AWS RDS for Oracle, I need to provide some important context about UNDO tablespace management in RDS environments.
AWS RDS for Oracle uses Oracle Managed Files (OMF) for database file management, which affects how tablespaces are created and managed. While RDS provides specific procedures through the rdsadmin package for various database administration tasks, the sources available don't contain specific information about creating or switching UNDO tablespaces in RDS for Oracle.
What I can confirm from the documentation:
General Tablespace Management in RDS for Oracle:
- RDS provides Amazon RDS-specific methods for common DBA tasks through the
rdsadmin.rdsadmin_utilpackage - You can create and manage permanent tablespaces, temporary tablespaces, and set default tablespaces using RDS procedures
- RDS doesn't provide shell access to DB instances and restricts access to certain system procedures and tables
Key Limitations: Since AWS RDS is a managed service, you don't have full administrative access like you would in an on-premise environment. This means certain low-level database operations may be restricted or need to be performed through specific RDS procedures.
Recommended Approach: For specific guidance on UNDO tablespace management in your RDS for Oracle multitenant environment, I recommend:
- Checking the AWS RDS for Oracle documentation specifically for UNDO management procedures
- Contacting AWS Support through the AWS Support Center (https://console.aws.amazon.com/support/) for detailed guidance on UNDO tablespace operations in multitenant configurations, as this is a specialized administrative task that may have specific RDS procedures or limitations
The management of UNDO tablespaces in a multitenant CDB/PDB environment on RDS may require specific procedures that aren't covered in the general tablespace management documentation.
Sources
Working with tablespaces in RDS for Oracle - Amazon Relational Database Service
Administering your RDS for Oracle DB instance - Amazon Relational Database Service
answered 2 months ago
Relevant content
asked 3 years ago
asked a year ago
asked a year ago
- AWS OFFICIALUpdated 2 years ago
