Oracle导入时提示无法打开日志文件,案例:Oracle报错ORA-00316 ORA-00312 日志文件损坏导致数据库无法启动...

天萃荷净

加错裸设备导致redo异常，数据库无法启动通过分析日志发现在aix中的裸设备和Oracle数据库直接使用OEM创建新表空间,导致了数据库crash而且不能正常启动

Thread 1 advanced to log sequence 4395

Current log# 1 seq# 4395 mem# 0: /dev/rorcl_redo01

Thu Jun 12 19:28:38 2014

/* OracleOEM */ CREATE SMALLFILE TABLESPACE "oracleplus" LOGGING DATAFILE '/dev/orcl_redo04' SIZE 2000M EXTENT MANAGEMENT

LOCAL SEGMENT SPACE MANAGEMENT AUTO

ORA-1119 signalled during: /* OracleOEM */ CREATE SMALLFILE TABLESPACE "oracleplus" LOGGING DATAFILE '/dev/orcl_redo04'

SIZE 2000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ...

Thu Jun 12 19:36:23 2014

/* OracleOEM */ CREATE SMALLFILE TABLESPACE "oracleplus" LOGGING DATAFILE '/dev/orcl_redo03' SIZE 2000M EXTENT MANAGEMENT

LOCAL SEGMENT SPACE MANAGEMENT AUTO

Thu Jun 12 19:43:56 2014

ORA-604 signalled during: /* OracleO