Moving the control files to new location

Edward Ramamoorthy
13 years ago
Categories: Tech

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.