2016년 5월 25일 수요일

[Database] LogMiner - logmnr

# sub
logmnr() {
  sqlplus '/as sysdba' <<EOF
    SET TIME ON TIMING ON ECHO ON
    SPOOL $1.log

    EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/archive_temp/$1.arc', OPTIONS => DBMS_LOGMNR.NEW);
    EXECUTE DBMS_LOGMNR.START_LOGMNR( OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTED_DATA_ONLY);

    select  * from V\$LOGMNR_CONTENTS
    where   row_id='AAALlqAKgAADUP9AAX';

    EXECUTE DBMS_LOGMNR.END_LOGMNR;

    SPOOL OFF
    EXIT
EOF
}

# main
logmnr ERPPRD_1_18735_672748494
logmnr ERPPRD_1_18736_672748494
logmnr ERPPRD_1_18737_672748494
logmnr ERPPRD_2_10368_672748494
logmnr ERPPRD_1_18738_672748494
logmnr ERPPRD_1_18739_672748494
logmnr ERPPRD_1_18740_672748494
logmnr ERPPRD_2_10369_672748494
logmnr ERPPRD_1_18741_672748494
logmnr ERPPRD_1_18742_672748494
logmnr ERPPRD_2_10370_672748494
logmnr ERPPRD_1_18743_672748494
logmnr ERPPRD_1_18744_672748494
logmnr ERPPRD_2_10371_672748494
logmnr ERPPRD_1_18745_672748494
logmnr ERPPRD_1_18746_672748494
logmnr ERPPRD_2_10372_672748494
logmnr ERPPRD_1_18747_672748494
logmnr ERPPRD_1_18748_672748494
logmnr ERPPRD_2_10373_672748494
logmnr ERPPRD_1_18749_672748494
logmnr ERPPRD_1_18750_672748494
logmnr ERPPRD_1_18751_672748494
logmnr ERPPRD_2_10374_672748494
logmnr ERPPRD_1_18752_672748494
logmnr ERPPRD_1_18753_672748494
logmnr ERPPRD_2_10375_672748494
logmnr ERPPRD_1_18754_672748494

댓글 없음:

댓글 쓰기