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
댓글 없음:
댓글 쓰기