Oracle Migration Assistant - Use to migrate database files from non-ASM instance to ASM instance

Q.  In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?
- Published on 28 Jul 15

a. Oracle Migration Assistant
b. Recovery Manager (RMAN)
c. Oracle Data Pump Export and Import
d. Conventional Oracle Export and Import

ANSWER: Oracle Migration Assistant
 

    Discussion

  • Nirja Shah   -Posted on 30 Sep 15
    Oracle Migration Assistant
    - Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.

    - DMU's intuitive user-interface greatly simplifies the migration process and lessens the need for character set migration expertise by guiding the DBA through the entire migration process as well as automating many of the migration tasks.

    - It comes with a scalable in-place migration architecture which significantly reduces the effort and downtime required for data conversion, comparing to conventional export and import migration methods.

    - For post-migration and existing databases already using the Unicode character set, the DMU also has a validation mode, in which it identifies data not correctly encoded in Unicode, thus providing a healthcheck on potential issues with implementation of Unicode in database applications.

    Oracle Recovery Manager (RMAN)
    - It provides a comprehensive foundation for efficiently backing up and recovering the Oracle database.

    - It is designed to work intimately with the server, providing block-level corruption detection during backup and restore.

    - RMAN optimizes performance and space consumption during backup with file multiplexing and backup set compression, and integrates with Oracle Secure Backup, as well as third party media management products, for tape backup.

    - RMAN takes care of all underlying database procedures before and after backup or restore, freeing dependency on OS and SQL*Plus scripts.

    - It provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems and offers features not available through user-managed methods, such as parallelization of backup/restore data streams, backup files retention policy, and detailed history of all backups.

    Oracle Data Pump Export and Import
    - Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another.
    - Oracle Data Pump is available only on Oracle Database 10g release 1 (10.1) and later.

    Conventional Oracle Export and Import
    - Conventional path Export uses the SQL SELECT statement to extract data from tables.
    - Data is read from disk into a buffer cache, and rows are transferred to the evaluating buffer.
    - The data, after passing expression evaluation, is transferred to the Export client, which then writes the data into the export file.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)