3. Set user tablespaces in the source database to READ ONLY.
4. In the Oracle Database 19c environment, import directly from the source database into the
destination PDB using full transportable export/import in network mode:
impdp pdbadmin/<passwd>@tgtpdb NETWORK_LINK=src112 VERSION=12
FULL=Y TRANSPORTABLE=ALWAYS
EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS
ENCRYPTION_PASSWORD=<enc_passwd>
METRICS=Y LOGFILE=tgtpdb_dir:src112fullimp.log
TRANSPORT_DATAFILES='/recovery1/data/hr_1.f '
TRANSPORT_DATAFILES='/recovery1/data/eng_1.f '
TRANSPORT_DATAFILES='/recovery1/data/eng_2.f '
Whether you use conventional dump files or network mode, full transportable export/import is a
convenient way to upgrade a database to a new version, migrate to a different operating system or
hardware platform, migrate into a PDB – or even to perform all three of these upgrades and migrations
in a single operation!
Considerations for Using Full Transportable Export/Import
Please be aware of the following considerations of using full transportable export/import:
•
Full transportable export/import is subject to the limitations detailed in Oracle Database
Administrator’s Guide
.
•
Full transportable export/import can be used to migrate source databases starting with Oracle
Database 11g Release 2 (11.2.0.3).
•
Full transportable export/import jobs cannot be restarted. If the operation is interrupted, then
the entire job must start over from the beginning.
•
For complete documentation of full transportable export/import, including details about network
mode migration into a PDB, see Oracle Database Utilities Guide.
•
If hardware and operating system platforms of your source and destination databases have
different endian characteristics, you will need to use the RMAN CONVERT command to
convert each tablespace to the new platform. See
Oracle Database Backup and Recovery
Reference
for a description of the RMAN CONVERT command.
TRANSPORTABLE TABLESPACES
The transportable tablespaces feature can be used to copy a single tablespace or a set of tablespaces
to a new database. While this method of migrating data is both fast and reliable, it requires a number of
manual steps that can be more complicated than some DBAs would prefer.
Migrating to a Pluggable Database Using Transportable Tablespaces
Like full transportable export/import, transportable tablespaces can be used to migrate to a PDB. The
procedure for using transportable tablespaces to migrate a database to a PDB is the same as a
transportable tablespaces migration to a non-CDB.
Example of Using Transportable Tablespaces
Oracle recommends using full transportable export/import to migrate databases starting with Oracle
Database 11g Release 2 (11.2.0.3). However, you can still use the transportable tablespaces feature to
migrate databases from earlier releases. The use of the transportable tablespaces feature is described
in detail by the following white papers:
» “Database Upgrade Using Transportable Tablespaces”