Home > 2021年7月15日发布的文章
  • 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...
    阅读全文 →