grep的-E参数(查看alter_ORCL.log)

grep的-E参数用法[@more@]

查看oracle日志的错误和警告

$cat alter_ORCL.log |grep -E 'ORA-|WARNING:'

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle8/oradata/dtgdb/redo03.log'
ORA-27037: unable to obtain file status
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle8/oradata/dtgdb/redo02.log'
ORA-27037: unable to obtain file status
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle8/oradata/dtgdb/redo01.log'
ORA-27037: unable to obtain file status
WARNING: EINVAL creating segment of size 0x0000000004640000
WARNING: EINVAL creating segment of size 0x0000000004640000
WARNING: EINVAL creating segment of size 0x0000000004640000
WARNING: EINVAL creating segment of size 0x0000000004640000
WARNING: EINVAL creating segment of size 0x0000000004640000
WARNING: EINVAL creating segment of size 0x0000000004640000
WARNING: EINVAL creating segment of size 0x0000000004640000
ORA-1119 signalled during: CREATE TABLESPACE itesjzh
WARNING: EINVAL creating segment of size 0x000000000c141000
ORA-1031 signalled during: create database
WARNING: EINVAL creating segment of size 0x000000000c141000
ORA-959 signalled during: drop tablespace itesjzh_temp
WARNING: EINVAL creating segment of size 0x000000000c141000

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/188692/viewspace-902960/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/188692/viewspace-902960/