Support AWS RDS Oracle with CDB deployments

## Feature request or enhancement

_For feature requests or enhancements, please provide the following information:_

**Which use case/requirement will be addressed by the proposed feature?**

When deploying Oracle on AWS RDS using a CDB deployment strategy, AWS enforces a strict security model that does not permit direct access to the database's container root. The `CDB$ROOT` (container root) is required for Debezium to perform very specific operations, such as streaming changes using LogMiner, as well as accessing specific performance views (`V$`) that are not available in the PDB.

---

**Implementation ideas (optional)**

In RDS, when using CDB deployments, custom PL/SQL packages are provided to interact with LogMiner. We might be able to create a strategy-based approach that can be used with RDS+CDB to leverage these custom packages.

In addition, the documentation would need to be updated to reflect the CDB-specific steps to operate in AWS RDS.

As a side note, this work, if structured well, could also serve as the basis for support for OCI cloud deployments of Autonomous and others, where we specifically need to mine differently for the same reasons.