Oracle architecture

* 이미지 출처 : http://duykhanh.wordpress.com/2009/03/25/oracle-database-9i-basic-architecture/

 

OracleArchitecture1.txt

Oracle architecture

Oracle 시작과 종료

Oracle 인증

Oracle parameter

OracleArchitecture2.txt

Oracle Data 구조

Permanent vs Temporary

INDEX

undo segment

Oracle TOOLS

관리(Administration)

IOT & Partition & Cluster

DB LInk

Turning

Modeling

Optimizer.txt

Optimizer

Logminer : Orange 같은 툴 사용시 상당히 편리함.

1.UTL_FILE_DIR parameter 설정

initorcl.ora : $ORACLE_HOME\db1\database\initorcl.ora

UTL_FILE_DIR='C:\oracle\utl_file_dir'

2.Dictionary 생성

exec dbms_logmnr_d.build('dictionary1.ora','C:\oracle\utl_file_dir');

3. 분석할 archive log 등록

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_41_610QD3X9_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_42_610QFW2G_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_43_610QG3HN_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_44_610QGG2X_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_45_610QGJ8S_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_46_610QGLVC_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_47_610QH19R_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_48_610QJ77T_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_49_610QJC7T_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_50_610QJK7T_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_51_610QJR2G_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_52_610QJRNZ_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_53_610QJX98_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_54_610QJXDP_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_55_610QK7FO_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_56_610QK7NJ_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_57_610QK9LK_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_58_610QK9RF_.ARC');

exec dbms_logmnr.add_logfile('C:\flash_recovery_area\O1_MF_1_59_610QKGPY_.ARC');

*분석할 redo log 파일 등록시

exec dbms_logmnr.add_logfile('C:\oradata\orcl\REDO01.LOG',1);

exec dbms_logmnr.add_logfile('C:\oradata\orcl\REDO02.LOG',1);

exec dbms_logmnr.add_logfile('C:\oradata\orcl\REDO03.LOG',1);

4. logminer 시작  

        exec dbms_logmnr.start_logmnr(dictFilename=>'C:\oracle\utl_file_dir\dictionary1.ora');

*그외 다른 방법들...

exec dbms_logmnr.start_logmnr(starttime=>'2010-06-10 01:01:01', endtime=>'2010-07-21 23:59:59', options=>dbms_logmnr.dict_from_online_catalog+dbms_logmnr.continuous_mine);

exec dbms_logmnr.start_logmnr(starttime=>'2010-06-10', endtime=>'2010-07-21', options=>dbms_logmnr.dict_from_online_catalog+dbms_logmnr.continuous_mine);

exec dbms_logmnr.start_logmnr(dictFilename=>'C:\oracle\utl_file_dir\dictionary.ora',starttime=>'2010-06-10', endtime=>'2010-06-10', options=>dbms_logmnr.dict_from_online_catalog+dbms_logmnr.continuous_mine);

exec dbms_logmnr.start_logmnr(dictFilename=>'C:\oracle\utl_file_dir\dictionary.ora',starttime=>'2010-06-10', endtime=>'2010-06-10', options=>dbms_logmnr.continuous_mine);

5. 로그 조회

desc v$logmnr_contents

select scn, username,sql_undo, sql_redo from v$logmnr_contents where operation = 'DELETE';

6. logminer 종료

exec dbms_logmnr.end_logmnr;