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.
Bir Cevap Yazın