Moving the control files to new location

Moving the control files to new location in production.

1.Login as sysdba user

Sqlplus /nolog
Conn / as sysdba
Show parameter control_files -Check the control file path
Show parameter spfile ---Check the db running on spfile/pfile
Shutdown immediate
Exit

2. If database running on pfile, change the init parameter file.

control_files = ( /oradata/raja/control/control01.ctl,
/oradata/raja/control/control02.ctl,
/oradata/raja/control/control03.ctl,
/oradata/raja/control/control04.ctl)

3. If database running on spfile (Before shut down the database, created the pfile & Change the Control files location in pfile)

Create pfile= from spfile;

4. Copy the control files using os command.

cp /oradata/raja/redo01a/control01.ctl /oradata/raja/control/control01.ctl

cp /oradata/raja/redo01b/control02.ctl /oradata/raja/control/control02.ctl
cp /oradata/raja/redo02a/control03.ctl /oradata/raja/control/control03.ctl
cp /oradata/raja/redo02b/control04.ctl /oradata/raja/control/control04.ctl

5. Login as sysdba user

If database running pfile.

Sqlplus /nolog

Conn / as sysdba
Startup pfile
Show parameter control_files
Exit

If database running on spfile.

Sqlplus /nolog
Conn / as sysdba
Startup pfile
Show parameter control_files
Create spfile from pfile;
Shut immediate
Startup ( using spfile)
Exit

6. Remove the Old control files

rm /oradata/raja/redo01a/control01.ctl
rm /oradata/raja/redo01b/control02.ctl
rm /oradata/raja/redo02a/control03.ctl
rm /oradata/raja/redo02b/control04.ctl

Suggestion

Taken the cold backup.

I Hope this article helped you to understand moving a control files.Suggestions are welcome.

Help Us Grow

If you like this post, please share it with your friends.

You are free to copy and redistribute this article in any medium or format, as long as you keep the links in the articles or provide a link back to this page.

Subscribe to our mailing list