Recovering data from an on-demand backup using dbaasapi
We are running a production instance of Oracle Integration Cloud Classic (User Managed) v19.2 which uses Oracle DBaaS 12.2 Standard Edition. Two weeks ago we triggered an action in OIC that unknowningly deleted several process instances from the database. We want to restore that data into a test database from an oss (storage cloud) production backup. We have identified the specific rman tag number we absolutely need to use. We then want to use data pump to import the missing data back into production without overwriting the data we have accumulated since.
Side note : We have successfully done this once before and are very comfortable with the process and the data pump script.