ORA-10873 故障解决

打开库的时候报如下错误

点击(此处)折叠或打开

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

查询备份情况

点击(此处)折叠或打开

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

 
 结束备份

点击(此处)折叠或打开

1. SQL> alter database end backup;

点击(此处)折叠或打开

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

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24486203/viewspace-2157174/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24486203/viewspace-2157174/