Below steps need to be followed to move the datafile to ASM disk group.

SOLUTION:

1. Make the datafile offline;

2. Connect to RMAN and copy datafile to ASM DISKGROUP

3. Rename the datafile in control file

4. Switch the data file to copy

5. Recover the datafile

6. Make the datafile online:

IF YOU ARE IN ORACLE 12C:

In oracle 12c, we can move the datafile online with one line.

Leave a Reply