Trusted Digital Transformation Partner
Oracle Database services cover the full life of a production database: migration (on-premises to OCI, AWS or Azure, or between data centres), version upgrades such as 19c to 23ai, performance tuning, patching and PSU/RU cycles, cloning and refresh for UAT, backup and recovery with RMAN and Data Guard, and day-to-day DBA support against an SLA. ROSTAN provides these as managed or project work for Oracle estates from single instances to RAC and Exadata. On our own service desk, DBA work is the third-largest support category — 554 DBA tickets and 221 clone or refresh requests across 27 months — so the recommendations here come from running these systems, not from a datasheet.
On-premises to OCI, AWS or Azure, data centre moves, and platform changes. Data Pump, RMAN duplication, Data Guard switchover or GoldenGate depending on how much downtime you can actually afford — that constraint drives the method, not the other way round.
11g and 12c to 19c, and 19c to 23ai. Compatibility testing, optimizer plan regression checks and a tested rollback. The risk in an upgrade is rarely the upgrade — it is the query that changes plan afterwards.
AWR and ASH analysis, SQL and plan stability, SGA/PGA sizing, storage latency and Linux kernel parameters. We tune the whole stack, because the cause usually sits outside the database.
RMAN strategy, Data Guard standby configuration, and — the part most often skipped — actually testing a restore before you need one.
PROD to UAT and test clones for patch validation, training and release testing, scheduled so they never collide with the month-end close calendar.
Quarterly RU/PSU cycles, security patching, space and tablespace management, monitoring and 24×7 cover for production estates against an agreed SLA.
Oracle extended the 19c runway considerably. The headline dates are widely reported; the exclusions are the part that catches regulated organisations out.
Oracle extended support for on-premises Database 19c, taking Extended Support into 2032 and making it, in Oracle's framing, the longest strategic release. If you were told you must be off 19c imminently, check the date before you fund the project.
The Register — Oracle extends 19c supportIndustry analysis of the extension reports that the later Extended Support period excludes several security-related components — among them TLS, Native Network Encryption, Transparent Data Encryption and FIPS-related functionality.
If your database relies on TDE or network encryption — as most regulated estates do — your effective deadline is far earlier than 2032. Verify this against your own support contract before planning around the headline date; we will help you read it, and we will not pretend a support matrix is simpler than it is.
Across 158 performance investigations on our own desk, the fix was inside the SQL far less often than the ticket implied. That is why a tuning engagement starts with AWR and the operating system, not with a list of queries.
Tell us the version, the platform and the symptom. We will come back with what we would look at first — and if the answer is that your database is fine and the problem is elsewhere, we will say that.
Powered by AI · Typically replies instantly