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.
