ORA-10873 故障解決

shawnloong發表於2018-07-01
開啟庫的時候報如下錯誤

點選(此處)摺疊或開啟

  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章