RMAN-06023 no backup or copy of datafile 1 found to restore

梓沐發表於2016-03-25
REST

錯誤詳情：

  1. RMAN> restore database from tag="NEAL_LV0";

  3. Starting restore at 09-MAR-16
  4. using channel ORA_DISK_1
  5. RMAN-00571: ===========================================================
  6. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  7. RMAN-00571: ===========================================================
  8. RMAN-03002: failure of restore command at 03/09/2016 10:11:53
  9. RMAN-06026: some targets not found - aborting restore
  10. ......
  11. RMAN-06023: no backup or copy of datafile 3 found to restore
  12. RMAN-06023: no backup or copy of datafile 2 found to restore
  13. RMAN-06023: no backup or copy of datafile 1 found to restore


檢查了一下備份檔案發現都是存在的。最後發現是incarnation的問題，由於之前做了一次不完全恢復，進行了alter database open resetlogs;

  1. RMAN> list incarnation;

  3. List of Database Incarnations
  4. DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
  5. ------- ------- -------- ---------------- --- ---------- ----------
  6. 1 1 NEAL 4033362200 PARENT 1 24-AUG-13
  7. 2 2 NEAL 4033362200 PARENT 925702 06-NOV-15
  8. 3 3 NEAL 4033362200 PARENT 1623729 19-NOV-15
  9. 4 4 NEAL 4033362200 PARENT 1716084 17-NOV-15
  10. 5 5 NEAL 4033362200 CURRENT 7160370 09-MAR-16
解決方法：

將資料庫重置到上一次的incarnation，這裡即是4，然後還原資料庫，問題解決。

  1. RMAN> reset database to incarnation 4;
  2. database reset to incarnation 4

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29812844/viewspace-2063693/，如需轉載，請註明出處，否則將追究法律責任。

相關文章