Moving Control Files


teps:
Shutdown the Instance
Move the Control File
Edit the init<ORACLE_SID>.ora
Startup the Instance
% sqlplus "/ as sysdba"
SQL> shutdown immediate
SQL> !mv /u06/app/oradata/OCM/control01.ctl /u03/app/oradata/OCM/control01.ctl
SQL> !mv /u06/app/oradata/OCM/control02.ctl /u04/app/oradata/OCM/control02.ctl
SQL> !mv /u06/app/oradata/OCM/control03.ctl /u05/app/oradata/OCM/control03.ctl
Within the init.ora file, there will be an entry for the "control_files" parameter. Edit this entry to reflect the change(s) made to the physical control file(s) movedin the previous example.
...
control_files = (/u03/app/oradata/OCM/control01.ctl,
 /u04/app/oradata/OCM/control02.ctl,
 /u05/app/oradata/OCM/control03.ctl)
...

SQL> startup open
SQL> exit
Advertisements

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

%d bloggers like this: