Moving the Entire Database to OMS
Use RMAN to move the entire database to Oracle Memory Speed (OMS) if the number of data files are large or if you want to move root
PDB files.
To migrate your entire database:
- Backup your database.
- Restore the file on OMS and recover the database.
Before you start the database backup:
- If you have any read-only transportable tablespaces with the COMPATIBLE initialization parameter set to less than 11.0.0, then make any read-only transportable tablespaces read/write for RMAN backup to work on the tablespaces.
-
If you have a physical standby database, then stop any running managed recovery:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
To migrate online redo logs to the OMS location, see Adding Redo Log Files to OMS
Parent topic: Migrating Oracle Database to Oracle Memory Speed