Is there a solution for the following problem? Situation:
- Create Oracle DbSystem (EE) in OCI with a PDB
- Enable Data Guard in OCI
- Create a local clone of the PDB via the GUI in OCI (i.e. duplicate a pdb in the same database)
Issue: this fails on the standby site as follows:
- Initially the datafiles are created as $OH/dbs/UNNAMED… (which is not abnormal)
- Then a job starts to fix this. It starts rman to copy the files from primary to standby.
- Then it tries to do a switch pdb to copy.
- However this fails because managed recovery is enabled and this gives (from the dcs log files) “RMAN-03002: failure of switch to copy command” and “ORA-01121: cannot rename database file 30 - file is in use or recovery”
- The job aborts with error
- The PDB is correctly cloned on the primary site, but it is INVALID on the standby site.
If I stop managed recover before the cloning, the job fails as well, because it requires the pdb to be created on the standby (and this does not happen because managed recovery is stopped). This is reflected in the dbca trace file on the standby as “[DBT-19606] PDB creation operation cannot be performed on the specified PDB 'PDBHOT7'” and “[DBT-19611] Specified standby database 'VICARIS_szf_fra' redo is not in sync with primary database”
If I enable recovery before the cloning, follow up the alert file closely and then I manually stop recovery during the rman copy and before the switch pdb to copy (correct timing required!), the job succeeds. But I cannot imagine that this is the documented(?) way to clone a PDB.
I have a service request open for this, but after 3 weeks there is not much progress in this.
Can anyone reproduce this (if not, there may be something wrong in my environment)? Or am I missing a step that I have to do?