Migrating a Database from ASM to Non-ASM Storage

Migrating a database back from ASM storage to non-ASM storage is similar to the original migration to ASM. The general outline of the process can be based on the steps in"Disk-Based Migration of a Database to ASM". The primary changes to these steps are to modify each step to reference file locations in non-ASM storage. For example, the command that initially created the datafile backups in ASM that become the live datafiles for the migrated database was:

BACKUP AS COPY INCREMENTAL LEVEL 0  DATABASE 
     FORMAT '+DISK'  TAG 'ORA_ASM_MIGRATION';

You could use the following command to move them back:

BACKUP AS COPY INCREMENTAL LEVEL 0  DATABASE 
     FORMAT '/non-asm/df/%U'  TAG 'ORA_NON_ASM_MIGRATION';

Similar modifications can be applied to the other steps in the migration process and to the PL/SQL scripts used during migration.