22.11.2022 – Update with Inputs from Roy Swonger, thank you Roy Why do we have AUDSYS data in our Oracle Data Pump full export? In a customer project, I was asked why there is always data of schema owner AUDSYS included in an Oracle Data Pump full export. The AUDSYS schema contains Unified Audit Trail Records and therefore the data is included when the feature is enabled. The demo case is a 19.15 Container Database with a PDB. The…
Read MoreCategory: Oracle RDBMS
AWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 3/3 – Pricing and personal Thoughts
This is the third and last part of the blog post series about AWS Custom Engine Versions for Amazon RDS Custom for Oracle. The blog post series: Part 1: Gives you an overview about the setup Part 2: About connectivity and what you get from AWS Part 3: My personal opinion about this service and some words about pricing After testing and running AWS RDS Custom for Oracle for a while, it’s time to came to a summary and finish…
Read MoreAWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 2/3 – Connectivity and what you get
This is the second part of the blog post series about AWS Custom Engine Versions for Amazon RDS Custom for Oracle. In this part we take a look how we can connect to the Oracle database host and to the database itself by a tool like the Oracle SQL Developer. The blog post series: Part 1: Gives you an overview about the setup Part 2: About connectivity and what you get from AWS Part 3: My personal opinion about this…
Read MoreAWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 1/3 – Setup
Some weeks ago I saw in an AWS public presentation a topic about a RDS service for Oracle databases where you can build your own environments and get full OS access. This was new for me how knows the normal AWS RDS offerings for Oracle databases, where no (or very limited) OS access is possible. And this meant for me as a child of Oracle Cloud Infrastructure: time to play! I spent a lot of time in the last three…
Read MoreOracle 11g – let’s move that old Stuff to the Oracle Cloud
This blog post describes the lift and shift of an on-prem Oracle 11g Enterprise Edition to Oracle Cloud Infrastructure by using Oracle RMAN paired with OCI Object Storage. Works for other versions > Oracle 11g / Enterprise Edition too (the tablespace encryption method may change). Architecture Q&A What’s the motivation of the lift and shift of a good old on-prem Oracle 11g database to Oracle Database Service? Hardware runs out of lifecycle Out scoping of an on-prem database which is…
Read More