[Oracle] Controlfile 다중화

 

Controlfile 다중화

 

1) SQL> Select name From v$controlfile; // Controlfile 확인

 

2) SQL> Alter System Set Control_files = '/u01/app/oracle/oradata/orcl/control01.ctl',

   '/u01/app/oracle/oradata/orcl/control02.ctl',

   '/u01/app/oracle/oradata/orcl/control03.ctl'

   SCOPE=SPFILE;

 

3) SQL> Shut immediate

 

4) $ cd /u01/app/oracle/oradata/orcl

 

5) $ cp control01.ctl control02.ctl

   $ cp control01.ctl control03.ctl

 

6) SQL> Startup

   SQL> Show Parameter Control

   SQL> Select name From v$controlfile;