rman恢復時ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oradata/datafile1/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/15/2015 17:50:56
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 2220 and starting SCN of 8429237
解決方法:
是由於controlfile裡所記錄的scn與datafile裡的scn不一致。後來查了一下發現restore controlfile時取了一份較早的檔案。
於是:
1.shutdown immediate
2.startup nomount
3.rman 下 set dbid
4.重新restore 一份較晚的controlfile.
5.alter database mount;
6.重新recover database 到原先指定的時間點,這裡不用restore database是因為原來已經restore成功了
7.alter database open resetlogs;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29863023/viewspace-1734732/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01152: file 1 was not restored from a sufficiently old backupREST
- 遭遇ORA-01152: file 1 was not restored from a sufficiently old backupREST
- 群友問題之ORA-01152: file 1 was not restored from a sufficiently old backupREST
- 徹底解決rman恢復碰到ora-01152錯
- Backup And Recovery User's Guide-RMAN資料修復概念-RMAN介質恢復GUIIDE
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- rman恢復到指定時間點
- Backup And Recovery User's Guide-執行RMAN表空間時間點恢復(TSPIRT)GUIIDE
- RMAN恢復 執行重要檔案RMAN恢復
- rman恢復時跳過資料檔案,進行恢復
- rman backup recovery備份恢復效能優化tuning方法二優化
- 資料庫恢復後開啟時遇到 ORA-01152資料庫
- 刪除表空間,有rman全備的恢復(使用dbms_backup_restore來進行恢復)REST
- RMAN 恢復之控制檔案篇(1/5)
- rman恢復的時候可以使用LASTSCNAST
- 【RMAN】RMAN跨版本恢復(上)
- 【RMAN】RMAN跨版本恢復(中)
- How to copy a datafile from ASM to a file system not using RMANASM
- RMAN恢復 執行不重要檔案的RMAN恢復
- rman備份恢復-rman恢復資料檔案測試
- Backup And Recovery User's Guide-從RMAN開始-恢復表空間GUIIDE
- RMAN恢復實踐
- rman恢復方案和oracle異機恢復Oracle
- rman 恢復機制與恢復測試
- oracle實驗記錄 (恢復-rman恢復)Oracle
- RMAN學習小結1:不完全恢復
- oracle實驗記錄 (恢復-rman維護(1))Oracle
- rman備份恢復-rman入門
- FROM ASM Migrating to FILE SYSTEM Using RMAN(三)ASM
- 【RMAN】表空間基於時間點的RMAN恢復-TSPITR
- oracle實驗記錄 (恢復-表空間基於時間點恢復(rman))Oracle
- 【RMAN】RMAN備份恢復1 RMAN冷備指令碼與crontab計劃任務指令碼
- rman恢復--丟失控制檔案的恢復
- rman恢復 使用switch映像副本進行恢復
- 資料庫resetlogs後進行rman恢復1資料庫
- oracle實驗記錄 (恢復-rman reset incatnation(1))Oracle
- Oracle RMAN恢復測試Oracle
- RMAN恢復控制檔案