Administration Workshop II 12-34. Migrating your database to ASM Storage

  1. Obtain the file names of the current control files and online redo logs by using V$CONTROLFILE and V$LOGFILE.
  2. Shut down the database consistently. Modify the server parameter file of your database as follows:
    • Set the necessary OMF destination parameters to the desired ASM disk group.
    • Remove the CONTROL_FILE parameter.
  3. Run the following RMAN script: 
    STARTUP NOMOUNT;
# replace '/u1/c1.ctl' for the location of the control file
RESTORE CONTROLFILE FROM '/u1/c1.ctl';
ALTER DATABASE MOUNT;
# replace the disk group '+dgroup1' for your disk group name
BACKUP AS COPY DATABASE FORMAT '+dgroup1';
SWITCH DATABASE TO COPY;
# replace '/u1/log1' for your online redo log name and '+dgroup1' for your disk group name
SQL "ALTER DATABASE RENAME '/u1/log1' TO '+dgroup1' ";
# Repeat RENAME command for all online redo log members
...
ALTER DATABASE OPEN RESETLOGS;
SQL "ALTER DATABASE TEMPFILE '/u1/temp1' DROP";
  4. Delete the old database files.

June 8, 2008. Tags: . Uncategorized.

No Comments Yet

Be the first to comment!

Leave a Reply

Trackback URI