dd命令的简单使用解决ORA-01200错误参考
/
数据库版本:11.2.0.4
平台:Linux x86
关键错误信息:ORA-01200
先看错误信息:
SQL> alter database open;
alter database open*
ERROR at line 1:
ORA-01122: database file12 failed verification check
ORA-01110: data file 12: ‘/u01/app/oracle/oradata/orcl/datafile/tb01.dbf’
ORA-01200: actual file size of 32434 is smaller than correct size of 32436 blocks
打开告警日志
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_3542.trc...
阅读全文 →