пятница, 14 марта 2014 г.

Использование grep

$cat  /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log | grep -i -e ORA-12012 -e ORA-00942

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$grep -i -e ORA-12012 -e ORA-00942  /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$egrep -i "ORA-12012|ORA-00942" /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$grep 'ORA-12012\|ORA-00942' /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$grep -w 'ORA-12012\|ORA-00942' /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$egrep -w 'ORA-12012|ORA-00942' /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$egrep -wi --color 'ORA-12012|ORA-00942' /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$grep 'ORA-12012\|ORA-00942' /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$grep -E 'ORA-12012|ORA-00942' /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job "SYSMAN"."EM_ECM_VCPU_JOB"
ORA-00942: table or view does not exist


$grep -E 'log# 2 seq# 200'  /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771

$grep -E 'log# 2 seq# 20*'  /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

  Current log# 2 seq# 2 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 20 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 23 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 26 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 26 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 29 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771

$grep -E 'log# . seq# 20*'  /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

  Current log# 2 seq# 2 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 20 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 3 seq# 21 mem# 0: +DATA/em12c_p/onlinelog/group_3.259.841573771
  Current log# 1 seq# 22 mem# 0: +DATA/em12c_p/onlinelog/group_1.256.841573771
  Current log# 2 seq# 23 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 3 seq# 24 mem# 0: +DATA/em12c_p/onlinelog/group_3.259.841573771
  Current log# 1 seq# 25 mem# 0: +DATA/em12c_p/onlinelog/group_1.256.841573771
  Current log# 2 seq# 26 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 26 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 3 seq# 27 mem# 0: +DATA/em12c_p/onlinelog/group_3.259.841573771
  Current log# 1 seq# 28 mem# 0: +DATA/em12c_p/onlinelog/group_1.256.841573771
  Current log# 2 seq# 29 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 3 seq# 201 mem# 0: +DATA/em12c_p/onlinelog/group_3.259.841573771




$grep -E 'log# 2 seq# 20*|ORA-0094*'  /u01/app/oradb/diag/rdbms/em12c_p/em12c/trace/alert_em12c.log

  Current log# 2 seq# 2 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 20 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 23 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 26 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 26 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
  Current log# 2 seq# 29 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
  Current log# 2 seq# 200 mem# 0: +DATA/em12c_p/onlinelog/group_2.263.841573771
ORA-00942: table or view does not exist