Control file 다중화 실습

Control file 확인

 

SQL > select name from v$controlfile;

 

 

Control file 다중화 및 이동 과정

 

1) Pfile 이용

step 1. Shutdown

step 2. 파일 복사(또는 이동)

step 3. 파라미터 파일 편집

step 4. startup

 

컨트롤 파일의 안정성을 위한 다중화 실습 ( Pfile )

 

$ sqlplus '/as sysdba'

Connected.

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SQL>!vi /home/oracle/product/10g/dbs/inittestdb.ora

control_files="/home/oracle/oradata/testdb/control01.ctl",

                  "/home/oracle/oradata/testdb/control02.ctl")

 

SQL>startup

ORACLE instance started.

 

...............

..................

....................

 

SQL > select name from v$controlfile;

 

NAME

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

/home/oracle/oradata/testdb/control01.ctl

/home/oracle/oradata/testdb/control02.ctl

 

 

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

서버 파라미터 파일을 이용한 컨트롤 파일 운영 ( Spfile )

 

2) Spfile 이용

step 1. 파라미터 파일 수정 ( alter system set control_files 명령 )

step 2. shutdown

step 3. 파일복사(또는 이동)

step 4. startup

 

$ sqlplus '/as sysdba'

Connected.

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SQL> create spfile from pfile

 

SQL> !rm /home/oracle/product/10g/dbs/inittestdb.ora

 

SQL> startup

ORACLE instance started.

 

...............

..................

....................

 

SQL > select name from v$controlfile;

 

NAME

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

/home/oracle/oradata/testdb/control01.ctl

/home/oracle/oradata/testdb/control02.ctl

 

SQL> alter system set control_files = '/home/oracle/oradata/testdb/control01.ctl' scope=spfile;

System altered

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SQL> !rm /home/oracle/oradata/testdb/control02.ctl

 

SQL>startup

ORACLE instance started.

 

...............

..................

....................

 

SQL > select name from v$controlfile;

 

NAME

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

/home/oracle/oradata/testdb/control01.ctl