May 28 2015

How to Migrate Controlfile From File System to ASM Disk in Oracle 11g

Category: Administration,Backup And RecoveryFatih Acar @ 13:36

You can migrate controlfile from file system to asm disk. You have to stop database and you can do that.

Stop Database

SQL> shutdown immediate;
SQL> startup nomount;

Migrate Controlfile

RMAN> restore controlfile to ‘+DATA’ from ‘/tmp/controlfile_currentlocation.ctl’;
RMAN> restore controlfile to ‘+FRA’ from ‘/tmp/controlfile_currentlocation.ctl’;

Show Location Of New Control Files

ASMCMD> find -t controlfile . *
+DATA/DG/CONTROLFILE/current.271.880891501
+FRA/DG/CONTROLFILE/current.268.880891547

Change Parameter For New Locations

alter system set control_files=’+DATA/DG/CONTROLFILE/current.271.880891501′,’+FRA/DG/CONTROLFILE/current.268.880891547′ scope=spfile;

Restart Database

SQL> shutdown immediate;
SQL> startup;

If you do not use ASM and If you want to new control file in file system, you can copy – paste controlfile to clone after stop database. And you have to change control_files parameter when database is nomount mode or stop.

14,460 total views, 5 views today

Tags: Oracle, Oracle Administration, Oracle Backup and Restore

facebook comments:

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.