Release Notes

20 Migrating an Oracle Database to Dell EMC SC Series Storage | CML1001
3.7.3 Linux utilities
When the database uses the file system, Oracle data files might be copied to new storage on another system
using native OS commands. Popular commands include: tar, cpio, cp, scp, and rsync.
Rsync is a very versatile file copying tool. It can be used to copy files locally or to or from a remote system. It
can transfer data over the ssh protocol to protect the data during the transfer. It also uses a delta-transfer
algorithm to identify and transfer only the differences between the source and target files.
Make sure to retain the original ownerships and permissions of the source files. Application and database
downtime are necessary during the file transfer to ensure the consistency of the data.
3.7.4 Oracle SQL Developer
This is a free developer tool developed by Oracle. The Oracle SQL Developer tool:
• Includes a simple graphical user interface that eases management of the Oracle database.
• Has gone through many significant changes over the years as Oracle continues to advance and
introduce new features.
• Provides a simple visual presentation of data, table, indexes, and other database objects; it is useful
for analyzing and scoping of the data migration
• Supports migrating non-Oracle databases to Oracle; a list of supported non-Oracle databases to
migrate to the Oracle database can also be found at http://www.oracle.com/technetwork/developer-
tools/sql-developer/supportedmigplatforms-086703.html.
• Has a dedicated Oracle website that addresses migrating to a non-Oracle database; SQL Developer
downloads, white papers, documentation, and video tutorials can be found at
http://www.oracle.com/technetwork/database/migration/index.html
3.7.5 Transportable Tablespaces
Transportable Tablespaces (TTS) is a powerful feature designed to ease the movement or migration of
databases between versions and platforms. The following describes the different types of TTS:
Transportable Tablespaces (TTS): Originally introduced in Oracle 8i, this is considered to be the fastest way
to move large amount of data between two Oracle databases up to Oracle 11gR2. Data files are copied
between the two databases instead of exporting and importing. However, objects in SYSTEM and SYSAUX
tablespaces cannot be copied and must be rebuilt in the target database during the migration. It does not
support cross-platform, cross-endianness migration.
Cross-platform Transportable Tablespaces (XTTS): An improvement over TTS was introduced in Oracle
10g which added the support of cross-platform and cross-endianness migration. RMAN Convert is invoked,
either on the source or target database, to convert the data. However it still cannot migrate objects in
SYSTEM and SYSAUX tablespaces.
Full Transportable Export/Import: New in Oracle 12c, Full Transportable combines the best of TTS, XTTS,
and Data Pump Export and Import features. It addresses the complexity and the speed of the migration
process and the inability of transport objects in SYTEM and SYSAUX tablespaces. RMAN Convert is invoked
to convert the data across platform and endianness. When combined with RMAN incremental backups,
database downtime can be further reduced.