当前位置：首页 > 数据库 > Oracle教程 > ORA-10873 故障解决 > 正文

ORA-10873 故障解决

来源：这里教程网 时间：2026-03-03 11:46:11 作者：
打开库的时候报如下错误

点击(此处)折叠或打开

    Errors in file /u01/app/oracle/diag/rdbms/mgkdb/mgkdb/trace/mgkdb_ora_3062.trc:
         ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
     ORA-01110: data file 1: '/u01/app/oracle/oradata/mgkdb/system01.dbf'
     ORA-10873 signalled during: alter database open...

查询备份情况

点击(此处)折叠或打开

    SQL> select * from V$BACKUP;
              FILE# STATUS CHANGE# TIME
     ---------- ------------------ ---------- ------------------
              1 ACTIVE 534855 30-JUN-18
              2 ACTIVE 524860 30-JUN-18
              3 ACTIVE 524865 30-JUN-18
              4 ACTIVE 534870 30-JUN-18
              5 ACTIVE 534870 30-JUN-18
              6 ACTIVE 554875 30-JUN-18
              7 ACTIVE 554875 30-JUN-18
              8 ACTIVE 554881 30-JUN-18


 
 结束备份

点击(此处)折叠或打开

    SQL> alter database end backup;



点击(此处)折叠或打开

    SQL> select * from V$BACKUP;
              FILE# STATUS CHANGE# TIME
     ---------- ------------------ ---------- ------------------
              1 INACTIVE 534855 30-JUN-18
              2 INACTIVE 524860 30-JUN-18
              3 INACTIVE 524865 30-JUN-18
              4 INACTIVE 534870 30-JUN-18
              5 INACTIVE 534870 30-JUN-18
              6 INACTIVE 554875 30-JUN-18
              7 INACTIVE 554875 30-JUN-18
              8 INACTIVE 554881 30-JUN-18


产生此错误主要是由于任务计划里面有一个expdp备份脚本，关机之前未备份完导致

编辑推荐：

相关推荐

最新软件资讯

ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-32004: obsolete and/or deprecated parameter(s) specified

热文推荐

天极热推