버전 : ORACLE 11.2.0.1
| 요약: - 해당 파라미터는 디비에서 사용 가능한 data_file 수(temp, control, redo 등은 제외)로 설정값보다 많을 수 없다 - 파라미터 적용 시 DB 재기동 필요 - db_files 파라미터는 RAC 구성에서 롤링(한 노드씩 작업 진행)으로 변경 불가, 모든 노드 내리고 올려야 함 |
DB_FILES
PropertyDescription
| Parameter type | Integer |
| Default value | 200 |
| Modifiable | No |
| Range of values | Minimum: the largest among the absolute file numbers of the datafiles in the databaseMaximum: operating system-dependent |
| Basic | No |
| Real Application Clusters | Multiple instances must have the same value. |
db_files 파라미터는 모든 RAC노드에서 같은 값을 가져야 한다.
- db_files 파라미터 200 -> 400 으로 변경 후 rac1 번 노드만 재기동 실행 ORA-01174 에러 발생하며 기동 실패
SQL> show parameter db_file
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_file_multiblock_read_count integer 128
db_file_name_convert string
db_files integer 200
SQL> alter system set db_files=400 scope=both ;
alter system set db_files=400 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set db_files=400 scope=spfile;
System altered.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1235959808 bytes
Fixed Size 2212896 bytes
Variable Size 872418272 bytes
Database Buffers 352321536 bytes
Redo Buffers 9007104 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01174: DB_FILES is 400 buts needs to be 200 to be compatible
SQL> select * from v$instance ;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_ STATUS PARALLEL THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDOWN_ DATABASE_STATUS INSTANCE_ROLE ACTIVE_STATE BLOCKED
--------------- ------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------- -------- ------------------------------------ --------- ---------- --------------------- --------------------------------------------- ------------------------------ --------- --------------------------------------------------- ------------------------------------------------------ --------------------------- ---------
1 racdb1 rac1.localdomain 11.2.0.1.0 22/03/23 STARTED YES 0 STARTED ALLOWED NO ACTIVE UNKNOWN NORMAL NO반응형
- 모든 노드 DB 재기동 후 파라미터 변경 확인
[oracle@rac1 ~]$ srvctl stop database -d racdb
[oracle@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE OFFLINE
ora.oc4j
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.racdb.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.scan1.vip
1 ONLINE OFFLINE
[oracle@rac1 ~]$
[oracle@rac1 ~]$ srvctl start database -d racdb
[oracle@rac1 ~]$
[oracle@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE OFFLINE
ora.oc4j
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.racdb.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.scan1.vip
1 ONLINE OFFLINE
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ss
SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 23 16:16:26 2022
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select * from v$instance ;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_ STATUS PARALLEL THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDOWN_ DATABASE_STATUS INSTANCE_ROLE ACTIVE_STATE BLOCKED
--------------- ------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------- -------- ------------------------------------ --------- ---------- --------------------- --------------------------------------------- ------------------------------ --------- --------------------------------------------------- ------------------------------------------------------ --------------------------- ---------
1 racdb1 rac1.localdomain 11.2.0.1.0 22/03/23 OPEN YES 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
SQL> show parameter db_file
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_file_multiblock_read_count integer 128
db_file_name_convert string
db_files integer 400
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options'DBMS > ORACLE' 카테고리의 다른 글
| redo log 사이즈 변경 RAC ASM (0) | 2022.03.25 |
|---|---|
| srvctl stop/start database 명령은 어떤 노드부터 동작할까? (0) | 2022.03.25 |
| 권한 부여 시 ROLE, PRIVILEGE 차이 (0) | 2022.03.14 |
| 테이블 OWNER가 아닌 다른 유저로 인덱스 생성 시 필요 권한 (0) | 2022.02.28 |
| APPEND 사용 시 logging / nologging 에 따른 로그 사용량 변화 (0) | 2022.02.27 |
댓글