首页 > Linux操作系统 > Linux操作系统 > 数据库报ORA-01110错误
日志中显示:
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (3, 28) on object 66529.
Mon Dec 3 14:47:06 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_5787.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2770385]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
exp导出的时候报:
. . exporting table TMP_GL_TMPDETAILPKKCC0
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 2, block # 22697)
ORA-01110: data file 2: '/oracle/oradata/orcl/undotbs01.dbf'
删除这两个表:
SQL> connect user01/user01
Connected.
SQL> show user;
USER is "user01"
SQL> select * from TMP_GL_TMPDETAILPKKCC0
2 ;
select * from TMP_GL_TMPDETAILPKKCC0
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 2, block # 22697)
ORA-01110: data file 2: '/oracle/oradata/tonykorn/undotbs01.dbf'
SQL> drop table TMP_GL_TMPDETAILPKKCC0;
Table dropped.
SQL> drop table TMP_GL_VOUCHERPKKD6B;
Table dropped.
SQL> exit
重新导出时不报错了!
切换日志
SQL> alter system switch logfile;
System altered.
切换日志后从alter里面查看还是有坏块
Completed: ALTER DATABASE OPEN
Mon Dec 3 20:49:00 2007
Thread 1 advanced to log sequence 754
Current log# 3 seq# 754 mem# 0: /oracle/oradata/tonykorn/redo03.log
Mon Dec 3 20:49:07 2007
SMON: Restarting fast_start parallel rollback
SMON: ignoring slave err,downgrading to serial rollback
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (1, 22) on object 67951.
Mon Dec 3 20:49:07 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_19048.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2934737]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (3, 28) on object 66529.
Mon Dec 3 20:49:08 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_19048.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2770385]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (4, 25) on object 66621.
Mon Dec 3 20:49:08 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_19048.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2866970]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
Mon Dec 3 20:50:03 2007
Shutting down archive processes
Mon Dec 3 20:50:08 2007
ARCH shutting down
ARC2: Archival stopped
dbca删除后重建,然后用exp导出的文件重新导入.没有办法,oracle水平不行只能用最简单的方法了。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/312079/viewspace-245815/ ,如需转载,请注明出处,否则将追究法律责任。