ORACLE DA KONTROL DOSYASI YER DEĞİŞTİRME-CHANGE THE PATH OF CONTROL FILE

1)Veri tabanını başlatıyoruz:

SQL> startup

ORACLE instance started.

Total System Global Area  465567744 bytes

Fixed Size                        2925648 bytes

Variable Size                318770096 bytes

Database Buffers         138412032 bytes

Redo Buffers                  5459968 bytes

Database mounted.

Database opened.

2) Kontrol parametresinin yerini öğreniyoruz:

SQL> show parameter control_files;

NAME                                          TYPE           VALUE

------------------------------------ ----------- ------------------------------

control_files                               string         /u01/app/oracle/fast_recovery_

                                                                        area/orcl/control02.ctl, /u01/

                                                                        app/oracle/selim/control01.ctl

3) Database’i kapatıyoruz:

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

4) Yavuz adında bir dosya oluşturuyoruz:

oracle@yavuzselim /]$ mkdir -p /u01/app/yavuz

5)Kontrol dosyamızı taşıyoruz:

oracle@yavuzselim app]$ mv /u01/app/oracle/fast_recovery_area/orcl/control02.ctl /u01/app/yavuz

6)Database’e tekrar nomount modda bağlanıyoruz:

[oracle@yavuzselim app]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 13 17:26:26 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  465567744 bytes

Fixed Size                        2925648 bytes

Variable Size                318770096 bytes

Database Buffers         138412032 bytes

Redo Buffers                  5459968 bytes

7) Kontrol dosyalarının yerini gösteriyoruz:

SQL> alter system set control_files='/u01/app/yavuz/control02.ctl','/u01/app/oracle/selim/control01.ctl' scope=spfile;

System altered.

8) Kontrol dosyalarının yerlerini kontrol ediyoruz:

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  465567744 bytes

Fixed Size                        2925648 bytes

Variable Size                318770096 bytes

Database Buffers         138412032 bytes

Redo Buffers                  5459968 bytes

SQL> show parameter control_files;

NAME                                          TYPE           VALUE

------------------------------------ ----------- ------------------------------

control_files                                string         /u01/app/yavuz/control02.ctl,

                                                                        /u01/app/oracle/selim/control0

                                                                        1.ctl

9) Database’i open modda açıyoruz:

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.