We're using Oracle 12c, and have two separate servers running Oracle, with a CDB with 2 PDBs.
What is the easiest way of getting the data from server A to server B, as a one-time job (not replication)?
So far I can imagine the following alternatives:
- Do a TRANSPORTABLE RMAN backup, copy it to the second host, do a restore there
- Do a datapump export, move it to the second host, restore there
- Unplug the PDB, copy its xml-file and data to the second host, plug it in there
About alternative 3, I'm not even sure if it's a real option. Which of these alternatives would be easiest to accomplish?
I've tried to read up on the Oracle documentation, but it's very verbose and not at all easy to comprehend (which I suppose is why they're selling so much support services).