Skip Headers
Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)

Part Number B14191-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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';