How to create new controlfile on UNIX file system from ASM?

Scenario:

We already have a control file created on ASM storage. New control file needs to be added, but which should be on the Unix File system (not ASM).

Following are the simple steps to achieve this.

1. Identify the location of the current controlfile by using the ASM command line utility

ASMCMD> find -t controlfile . *
+DATA1/PDB/CONTROLFILE/backup.381.522285151

2. Shutdown the database and start the instance in nomount stage

SQL> shutdown immediate
SQL> startup nomount

3. Use RMAN to create the controlfile to UNIX filesystem

$ rman /
RMAN>restore controlfile to ” from ”;

On the database instance, we need to change the parameter file to reflect this change.

In case PFILE is being used, modify the control_files parameter and restart the database.

In case SPFILE being used,

1) startup nomount the database instance
2) alter system set control_files=’ASM_CONTROLFILE (ORIGINAL)’,’FS_CONTROLFILE (create newly by RMAN)’ scope=spfile;

For Single instance

SQL> alter system set control_files=’+DATA1/PDB/CONTROLFILE/backup.381.522285151′,’/oraNFS/oradata/PDB/control01.ctl’ scope=spfile;

For RAC

SQL> alter system set control_files=’+DATA1/PDB/CONTROLFILE/backup.381.522285151′,’/oraNFS/oradata/PDB/control01.ctl’ scope=spfile sid=’*’;

Note: FS /oraNFS should be a NFS or CFS, as all the RAC instances should be able to see the control files from all nodes.

SQL> shutdown immediate
SQL> startup

Advertisements
This entry was posted in Oracle Automatic Storage Management, Oracle Recovery Manager and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s