Friday, March 27, 2015

Moving Control File into ASM



Steps to move your db controlfile into ASM:-

1. Check the parameter on control_files to see current path.

2. Set control_files parameter in db to new path.

    alter system set control_files='/DEV/+VMU01','/DEV/+PSO01' scope=spfile;

3. Now -
     shutdown immediate;
     startup nomount;

4. Using RMAN, restore controlfile from old control_file.
 RMAN> restore controlfile from '+VMU01/vinaydev_streams/controlfile/current.2648.134262629';

5. Now Mount and open the instance.
 alter database mount;
     alter database open;
 

No comments:

Post a Comment