Heterogeneous sources and targets are possible in a single mapping only if there is no incremental data load.

Flat file data has to have a header row in order to join with Oracle database table ina single mapping

It is not possible to join data from different source connection types in a Single mapping

It is possible to mix heterogeneous source connection type and load into any supported target connection type in a single mapping.

It is possible to join data from different source connection types in mapping, but the result must be loaded to Oracle.

Flashback

Active Data Guard

Sharding

GoldenGate

Create a new OCI DB Service instance and use the “instantiatefrom backup” option in the console. This will automatically take care of the encryption.

Create a new OCI DB Service instance, delete the existing database, and use the DBaa$ tooling to configure the DB Cloud Backup Module to point to the existing bucket, and then restore the backup by using the console.

Create a new OCI DB Service Instance, copy the backup data from the bucket to the FRA, and then use the console to perform a DB restore.

Create a new DB Service instance, delete the existing database, manually install the DB Cloud Backup Module pointing it to the backed where the on-premises backups are located, and perform a complted RMAN RESTORE AS encryption operation.