9.8. Using RMAN to Perform Database Migration to ASM

Because ASM files cannot be accessed via the operating system, you must use the Recovery Manager (RMAN) to move database objects from a non-ASM disk location to an ASM disk group. Follow these steps to move these database objects:

  1. Note the filenames of the control files and the online redo log files.

  2. Shut down the database using the NORMAL, IMMEDIATE, or TRANSACTIONAL keywords.

  3. Back up the database.

  4. Edit the SPFILE to use OMF for all file destinations.

  5. Edit the SPFILE to remove the CONTROL_FILES parameter.

  6. Run the following RMAN script, substituting your specific filenames as needed:

    STARTUP NOMOUNT; RESTORE CONTROLFILE FROM '<controlfile location>'; ALTER DATABASE MOUNT; BACKUP AS COPY DATABASE ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial