How to move Control File to another location

You may need to move your control file to one other location. You can follow below steps for can move your control file to one other location.

First We  will verify the current location of the control files.

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orcl/control01.ctl
/u01/app/oracle/flash_recovery_area/orcl/control02.ctl
SQL> show parameter control_files

NAME                                   TYPE               VALUE
------------------------------------ -----------        ------------------------------
control_files                        string       /u02/app/oracle/oradata/orcl/control01.ctl,                                                                                     /u01/app/oracle/flash_recovery_area/orcl/control02.ctl

In this document we are going to move the control file located in 
/u02/app/oracle/oradata/orcl to /u02/app/oracle/oradata/orcl/ctl.

First We will set the CONTROL_FILES parameter to the new location for control file control01.ctl.

SQL> alter system 
2 set control_files='/u02/app/oracle/oradata/orcl/ctl/control01.ctl', 
3 '/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'
4 scope=spfile;

System altered.

Next we shutdown the database and move the control file with OS 
commands then we start up the database to complete the move/rename of the
control file.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@ora1 ~]$ mv /u02/app/oracle/oradata/orcl/control01.ctl /u02/app/oracle/oradata/orcl/ctl/control01.ctl

SQL> startup
ORACLE instance started.

Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 528485968 bytes
Database Buffers 314572800 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.

Now when we show the location of the control files the new location
is displayed for contol01.ctl.
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orcl/ctl/control01.ctl
/u01/app/oracle/flash_recovery_area/orcl/control02.ctl

SQL> show parameter control_files

NAME             TYPE               VALUE
--------------- ----------- ------------------------------
control_files    string     /u02/app/oracle/oradata/orcl/ctl/control01.ctl, 
                            /u01/app/oracle/flash_recovery_area/orcl/control02.ctl

Moving the control file(s) is a task that should be followed by 
backup of the control files for backup and recovery purposes.
Reklam


Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Connecting to %s

%d blogcu bunu beğendi: