ORA-01245、ORA-01547錯誤的解決
資料庫rman restore database 之後,執行recover database的時候,報告ORA-01245錯誤,詳細的錯誤資訊如下:
SQL> recover database until cancel; ORA-00279: change 575876 generated at 12/01/2009 08:19:49 needed for thread 1 ORA-00289: suggestion : /oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc ORA-00280: change 575876 for thread 1 is in sequence #2 Specify log: { auto ORA-00308: cannot open archived log '/oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-00308: cannot open archived log '/oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01245: offline file 2 will be lost if RESETLOGS is done ORA-01110: data file 2: '/oracle/oradata/orcl/undotbs01.dbf' SQL> |
檢查ORA-01245那一行,發現是datafile 2狀態為offline,解決的方法就是首先將datafile 2 online,然後再recover database。
SQL> alter database datafile 2 online; Database altered. SQL> recover database until cancel; ORA-00279: change 575876 generated at 12/01/2009 08:19:49 needed for thread 1 ORA-00289: suggestion : /oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc ORA-00280: change 575876 for thread 1 is in sequence #2 Specify log: { cancel Media recovery cancelled. SQL> alter database open resetlogs; Database altered. SQL> |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22049049/viewspace-1029212/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01547、ORA-01994錯誤解決一例
- Ocelot錯誤解決
- undefined reference to錯誤的解決方法Undefined
- SAXParseException的錯誤解決之二Exception
- PHP錯誤“Thisfilehasexpired”的解決方法PHP
- VIM 常用錯誤解決
- sqldeveloper for windows 錯誤解決SQLDeveloperWindows
- dns錯誤怎麼辦 dns錯誤的解決辦法DNS
- vsftpd 錯誤:530 and 500 錯誤解決方法FTP
- 解決MySQL server has gone away錯誤的解決方案MySqlServerGo
- Qt報Multiple definition錯誤的解決QT
- Cocopods的升級錯誤解決
- 解決 ngrok 的 Domain 錯誤問題AI
- 錯誤Namenodeisinsafemode的解決方法
- 解決DBCA的ORA-32700錯誤
- 【MySQL】解決mysql的 1594 錯誤MySql
- latex 錯誤以及解決方案
- ora-27504錯誤解決
- Datastore error in 'dirbdb'錯誤解決ASTError
- ORA-27054 錯誤解決
- mysql與php錯誤解決MySqlPHP
- mysql錯誤解決總結MySql
- PbootCMS 404 錯誤解決方法boot
- 【故障解決】OGG-00446 錯誤解決
- 微信支付錯誤兩個問題的解決:curl出錯,錯誤碼:60
- 寬頻連線錯誤678 寬頻連線錯誤691錯誤的解決辦法
- dbfread報錯ValueError錯誤解決方法Error
- standby新增檔案錯誤的解決方法
- MYSQL中 TYPE=MyISAM 錯誤的解決方法MySql
- Mac上搭建chromedriver的錯誤解決方法MacChrome
- 一個 ExpressionChangedAfterItHasBeenCheckedError 錯誤的解決過程ExpressError
- scp出現錯誤的解決辦法
- [傳]解決DBCA的ORA-32700錯誤
- ORA-00091錯誤的解決方式
- sqplus 的 segmentation fault錯誤及解決!Segmentation
- 編譯EJB出現錯誤的解決編譯
- 解決ntp的錯誤 no server suitable for synchronization foundServerUI
- samba一個錯誤的解決辦法!Samba