오라클 데이터베이스 10g 핵심 요약 노트

Size: px

Start display at page:

Download "오라클 데이터베이스 10g 핵심 요약 노트"

효빈 증
6 years ago
Views:

1 1 10g 10g SYSAUX 10g

2 22 Oracle Database 10g, 10g. 10g. (Grid), 10g.. 10g SYSAUX (ASM, Automatic Storage Management) 10g 10g. g. (DBA).,., 1).,..? 10g,.. (Larry Ellison).. (Leverage Components), (ASM) ( ) (ultra Large Data File),. 1),,,.,, ( ), /.

3 1 23,,. (transportable),, SQL. (Database Resource Manager). 10g, 10g. 10g. 10g. 10g 10g. 10g , 10g. 10g, 4 10g. (DBUA, Oracle Database Upgrade Assistant) ( (Oracle Data Migration Assistant) )..

4 24 Oracle Database 10g 10g exp/ imp. 10g SQL* copy create table as select. NOT E! DBUA DBUA 10g (GUI). 10g (OUI, Oracle Universal Installer) DBUA. DBUA. ( - dbua ) DBUA., (Oracle dbua ) DBUA. DBUA.,. DBUA. Ca ution 10g , imp/ exp( import/ export ).,.

5 1 25 ( ).... (UIT, Upgrade Information Tool). $ORACLE_ HOME/ r dbms / admi n ut l u 10l i. s ql SQL.,... 10g SYSAUX ( SYSAUX ). (DBA_ REGI STRY). 10g.. Compatible 10g, compatible , g compatible compatible. 10g, compatible 10.0., compatible 10.0,.., alter database reset compatibility.

6 26 Oracle Database 10g., 10g., 10g.,. (, ).,., (Oracle MetaLink), itar. exp/ imp 10g. ( : 8.0.6) (export). (import) 10g imp.., 10g SQL*Plus copy SQL create table as select..

7 1 27 ( dbms_support.start_trace (logon trigge r) ) sql_trace. 9i PL/ SQL recurs ive SQL. 10g. sql_trace, 10g.,.., (sche ma), USER_OBJECTS. (GUI), (DBCA, Database Configuration Assistant).. 10g ( ) DBCA. SYSAUX, 10g SYSAUX., 10g, SYSAUX. SYSAUX 10g. SYSAUX, SYSAUX

8 28 Oracle Database 10g. SYSAUX SYSAUX 10g. SYSAUX SYSTEM. SYSAUX (automatic segment space management) (logical). (RMAN (RMAN recovery catalog), (Ultra Search),, XDP OLAP ),. SYSAUX. SYSAUX. (OMF, Oracle Managed Files), OMF. create database sysaux datafile, SYSAUX ( )., sysaux datafile OMF, SYSAUX. sysaux datafile create database. CREATE DATABASE my_db DATAFI LE ' c : \ or acl e \ or adat a\ my_db\ my_db_ sys t em_01. db f ' SI ZE 300m SYSAUX DATAFI LE ' c : \ or acl e\my_db\my_db_sysaux_01.dbf ' SI ZE 100m DEFAULT TEMPORARY TABLESPACE dt emp_t bs t empfi l e ' c : \ or acl e \ my_db\ my_db_t emp_ 01. dbf ' SI ZE 100m UNDO TABLESPACE undo_t bs_one DATAFI LE ' c : \ or acl e \ my_db\ my_db_undo_t bs_one_01. dbf ' SI ZE 100m;

9 1 29, 10g SYSAUX. 10g (mounting), startup migrate (migrate)., SYSAUX. create tablespace. CREATE TABLESPACE sysaux DATAFI LE ' c : \ or acl e \ or adat a\ my_db\ my_db_ sys aux_01. db f ' SI ZE 300m EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; SYSAUX. 10g SYSAUX. 10g SYSAUX., 10g SYSAUX,. 10g, SYSAUX.,. SYSAUX. SYSAUX. SYSAUX, alter tablespace, SYSAUX (datafile).. ALTER TABLESPACE sysaux ADD DATAFI LE ' d : \ or acl e \ or adat a\ my_db\ my_db_ sys aux_01. db f ' SI ZE 200M;

10 30 Oracle Database 10g SYSAUX SYSAUX (occupant). SYSAUX (view), SYSAUX., SYSAUX V$SYSAUX_OCCUPANTS. SYSAUX. SELECT occupant _name, space_usage_ kbyt es FROM v$sysaux_occupant s ;, RMAN. SYSAUX, V$SYSAUX_OCCUPANTS MOVE_PROCEDURE. SYSAUX.. NOT E SYSAUX., SYSAUX. 10g (ASM, Automatic Storage management). ASM 9i RAC. ASM,,.

11 1 3 1 ASM ASM. ASM (raw) I/ O (J BOD), SAN(Storage Area Network)., ASM,. (hot spots) ASM (load balancing) ASM,., ASM., ASM,. ( ) raw, cooked, OMF ASM., ASM.,.. ASM, ASM. ASM,.

12 32 Oracle Database 10g ASM ASM ASM. ASM, ASM. ASM. ASM, (extent map). ASM, ASM I/O. ASM. ASM init_osm.ora. ASM OSM ASM instance_type., ASM., startup ASM. ASM shutdown (normal, immediate, force abort ). ASM. ASM., 10g DBCA ASM,. ASM, DBCA, ASM,. NOT E ASM, DBCA..

13 1 33 ASM ASM,. (logical volume manager),. create diskgroup. create diskgroup, (failover).. Cr eat e di s kgr oup di s k_gr oup_ 001 FAI LGROUP f ai l _gr oup_01 DI SK ' / dev/ di s k1 ', ' / dev/ di s k2 ', ' / dev/ di s k3 ', FAI LGROUP f ai l _gr oup_02 DI SK ' / dev/ di s k5 ', ' / dev/ di s k6 ', ' / dev/ di s k7 ' ; ASM (redundancy). failure group. failure group, (mirror),,., (normal redundancy), 2 failure group. (high redundancy) 3 failgroup., (external redundancy) ASM, ( ) (external entity).,.,.,., ASM,. (cycle),.

14 34 Oracle Database 10g NOT E create diskgroup, ASM., alter diskgroup. alter diskgroup,,., alter diskgroup, (mount) (dismount). alter diskgroup.. Al t er di s kgr oup di s k_gr oup_001 add di r ect or y ' +di s k_gr oup_ 001/ dat a_ 001 ' ;, alter diskgroup,. ASM,.. Cr eat e t abl espace dat a_t bs dat a f i l e ' +di s k_gr oup_ 001 ' s i ze 300MB; ASM., OMF (convention). (, ), DBA_DATA_FILES V$DATAFILE.

15 1 35 ASM ASM. 10g, ASM. ASM ( ASM ).. V$ASM_ALIAS ASM, V$ASM_ALIAS ASM (alias) (row). ( ). V$ASM_C LIENT ASM, V$ASM_CLIENT ASM (row)., ASM, V$ASM_CLIENT ASM. V$ASM_DISK ASM, V$ASM_DISK ASM., V$ASM_DISK. V$ASM_DISKG RO UP ASM, V$ASM_DISKGROUP ASM., V$ASM_DISKGROUP ASM ASM.

16 36 Oracle Database 10g V$ASM_FILE ASM, V$ASM_FILE ASM ASM. ( ). V$ASM_OPERATION ASM, V$ASM_OPERATION ASM ASM (ASM long running operation). ( ). V$ASM_TEMPLATE ASM, V$ASM_TEMPLATE ASM., V$ASM_TEMPLATE ASM ASM. ASM... 10g 9i (Oracle Parallel Server) (RAC, Real Application Clusters). 10g RAC,.

17 1 37 CPU gcs_server_processes 9i (Protable Clusterware). 10g RAC. 10g RAC 3. 10g,.. (Infiniband) 10g opatch RAC (Rolling upgrades). (scheme). RAC (internode communications).

18 38 Oracle Database 10g 10g (CRS, Cluster Ready Services). CRS (node membership),,. CRS. (Oracle Universal Installer) RDBMS ORACLE_ HOME ORACLE_HOME CRS. RDBMS, CRS, ORACLE_HOME. CRS,. (Server Control) DBCA, PL/SQL dbms_services. (OEM, Oracle Enterprise Manager). 10g (AWR, Automatic Workload Repository) CRS.., AWR,., 10g dbms_service dbms_monitor PL/SQL CRS. (DBCA, Oracle Database Configuration Assistant) (DBUA, Oracle Database Upgrade Assistant) GUI. 10g. DBCA.

19 1 39 DBCA. DBCA,. DBUA RAC 10g. NOT E (Oracle Real Application Clusters Deployment) (Performance Guide) DBCA. gcs_server_processes 10g gcs_server_processes. (Global Cache Service). 2,

Simplify your Job Automatic Storage Management DB TSC

Simplify your Job Automatic Storage Management DB TSC 1. DBA Challenges 2. ASM Disk group 3. Mirroring/Striping/Rebalancing 4. Traditional vs. ASM 5. ASM administration 6. ASM Summary Capacity in Terabytes