查看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