Q1) 컨트롤 파일 하나라도 손상되면 --> 인스턴스 기동 불가
--> (사실) 확인 결과 DB Instance 가 기동되지 않는다.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | ss> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2097152000 bytes Fixed Size 2926320 bytes Variable Size 603982096 bytes Database Buffers 1476395008 bytes Redo Buffers 13848576 bytes Database mounted. Database opened. ss> show parameters spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /app/oracle/product/12.1.0.2/db_1/dbs/spfileTG12102.ora ss> show parameters control_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string /u01/ORACLE/TG12102/control01.ctl, /u01/ORACLE/TG12102/control02.ctl ss> [TG12102]tg:/u01/ORACLE/TG12102> ls -al control* -rw-r-----. 1 oracle oinstall 18038784 May 16 09:52 control01.ctl -rw-r-----. 1 oracle oinstall 18038784 May 16 09:52 control02.ctl [TG12102]tg:/u01/ORACLE/TG12102> mv control02.ctl control02.ctl.old [TG12102]tg:/u01/ORACLE/TG12102> ls -al control* -rw-r-----. 1 oracle oinstall 18038784 May 16 09:52 control01.ctl -rw-r-----. 1 oracle oinstall 18038784 May 16 09:52 control02.ctl.old [TG12102]tg:/u01/ORACLE/TG12102> ss> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2097152000 bytes Fixed Size 2926320 bytes Variable Size 603982096 bytes Database Buffers 1476395008 bytes Redo Buffers 13848576 bytes ORA-00205: error in identifying control file, check alert log for more info ss> << Alert log >> Wed May 16 09:53:58 2018 ALTER DATABASE MOUNT Wed May 16 09:53:58 2018 ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/ORACLE/TG12102/control02.ctl' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-205 signalled during: ALTER DATABASE MOUNT... | cs |
Q2) 컨트롤 파일 다중화 시, 하나라도 손상되면--> 인스턴스 정지
--> (거짓) 확인 결과 에러 메시지가 발생하지만 인스턴스가 정지 되지는 않는다.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 | sys@TG12102> show parameters control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/ORACLE/TG12102/control01.ctl, /u01/ORACLE/TG12102/control02.ctl sys@TG12102> [TG12102]tg:/u01/ORACLE/TG12102> ls -al control* -rw-r-----. 1 oracle oinstall 18038784 May 16 09:27 control01.ctl -rw-r-----. 1 oracle oinstall 18038784 May 16 09:27 control02.ctl [TG12102]tg:/u01/ORACLE/TG12102> sys@TG12102> show parameters spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /app/oracle/product/12.1.0.2/db_1/dbs/spfileTG12102.ora sys@TG12102> sys@TG12102> create pfile='/app/oracle/product/12.1.0.2/db_1/dbs/spfilebackup.txt' from spfile ; File created. [TG12102]tg:/u01/ORACLE/TG12102> mv control02.ctl control02.ctl.old [TG12102]tg:/u01/ORACLE/TG12102> ls -al control* -rw-r-----. 1 oracle oinstall 18038784 May 16 09:47 control01.ctl -rw-r-----. 1 oracle oinstall 18038784 May 16 09:47 control02.ctl.old [TG12102]tg:/u01/ORACLE/TG12102> sys@TG12102> select * from v$version ; BANNER CON_ID -------------------------------------------------------------------------------- ------ Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0 PL/SQL Release 12.1.0.2.0 - Production 0 CORE 12.1.0.2.0 Production 0 TNS for Linux: Version 12.1.0.2.0 - Production 0 NLSRTL Version 12.1.0.2.0 - Production 0 sys@TG12102> sys@TG12102> alter system checkpoint ; System altered. sys@TG12102> alter system switch logfile ; System altered. sys@TG12102> / System altered. sys@TG12102> / System altered. sys@TG12102> alter system checkpoint ; System altered. Wed May 16 09:47:53 2018 Thread 1 advanced to log sequence 10 (LGWR switch) Current log# 4 seq# 10 mem# 0: /u01/ORACLE/TG12102/redo04.log Wed May 16 09:48:06 2018 Thread 1 advanced to log sequence 11 (LGWR switch) Wed May 16 09:48:06 2018 Archived Log entry 25 added for thread 1 sequence 9 ID 0x13bce876 dest 1: Current log# 5 seq# 11 mem# 0: /u01/ORACLE/TG12102/redo05.log Wed May 16 09:48:06 2018 Archived Log entry 26 added for thread 1 sequence 10 ID 0x13bce876 dest 1: Wed May 16 09:48:08 2018 Thread 1 cannot allocate new log, sequence 12 Checkpoint not complete Current log# 5 seq# 11 mem# 0: /u01/ORACLE/TG12102/redo05.log Wed May 16 09:48:09 2018 Thread 1 advanced to log sequence 12 (LGWR switch) Current log# 6 seq# 12 mem# 0: /u01/ORACLE/TG12102/redo06.log Wed May 16 09:48:09 2018 Archived Log entry 27 added for thread 1 sequence 11 ID 0x13bce876 dest 1: Wed May 16 09:48:33 2018 Errors in file /app/oracle/diag/rdbms/tg12102/TG12102/trace/TG12102_m001_31525.trc: ORA-00210: cannot open the specified control file ORA-00202: control file: '/u01/ORACLE/TG12102/control02.ctl' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3 sys@TG12102> show user USER is "SYS" sys@TG12102> conn test/test Connected. test@TG12102> create table check_test01 ( a1 number, a2 varchar2(10)); Table created. test@TG12102> insert into check_test01 values ( 1,'a'); 1 row created. test@TG12102> commit ; Commit complete. test@TG12102> conn /as sysdba Connected. sys@TG12102> select * from test.check_Test01 ; A1 A2 ---------- ---------- 1 a sys@TG12102> --> 정상적인 DML 수행 가능 확인 | cs |