控制文件OLD錯(cuò)誤_第1頁
控制文件OLD錯(cuò)誤_第2頁
控制文件OLD錯(cuò)誤_第3頁
全文預(yù)覽已結(jié)束

下載本文檔

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

1、SQL首先需要查找redo文件的存放路徑：select group#,type,member from v$logfile; 方法2：模擬ORA-01207錯(cuò)誤很簡(jiǎn)單，不再描述：u 思路：用舊的控制文件恢復(fù)，最后用resetlogs打開數(shù)據(jù)庫。u 具體步驟：1：startup mount;2：recover database using backup controlfile until cancel;然后根據(jù)情況，指定archive log和redo file。3：alter database open resetlogs;u 操作演示：oraclelinuxfreeoracleoradata

2、orcl sqlplus as sysdbaSQLPlus Release 10.2.0.1.0 - Production on 星期日 11月 19 1357512006Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL startupORACLE instance started.Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 88082676 bytesDat

3、abase Buffers 75497472bytesRedo Buffers 2973696 bytesDatabase mounted.ORA-01122 database file 1 failed verification checkORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'ORA-01207 file is more recent than control file - old control file執(zhí)行恢復(fù)：SQL recover database using backup controlfi

4、le until cancel;ORA-00279 change 891145 generated at 11182006 060211 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_47_%u_.arcORA-00280 change 891145 for thread 1 is in sequence #47Specify log =suggested filename AUTO CANCELauto （由于o1_mf_1_47_%u_

5、.arc這個(gè)歸檔日志，我這里有這個(gè)文件，所以指定auto，此時(shí)應(yīng)用了一些歸檔日志）ORA-00279 change 911145 generated at 11192006 134924 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_48_%u_.arcORA-00280 change 911145 for thread 1 is in sequence #48ORA-00278 log file'freeoracleflash_r

6、ecovery_areaORCLarchivelog2006_11_19o1_mf_1_47_2ozw355r_.arc' no longer needed for this recoveryORA-00279 change 911687 generated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1

7、 is in sequence #49ORA-00278 log file'freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_48_2ozwf289_.arc' no longer needed for this recoveryORA-00308 cannot open archived log'freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arc'ORA-27037 unable to obtain

8、 file statusLinux Error 2 No such file or directoryAdditional information 3ORA-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152 file 1 was not restored from a sufficiently old backupORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'這種恢復(fù)方式，不會(huì)自動(dòng)去找聯(lián)機(jī)redo文

9、件，所以必須要手工指定！SQL recover database using backup controlfile until cancel;ORA-00279 change 911687 generated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1 is in sequence #49Specify lo

10、g =suggested filename AUTO CANCELfreeoracleoradataorclredo01.logORA-00310 archived log contains sequence 47; sequence 49 requiredORA-00334 archived log 'freeoracleoradataorclredo01.log'ORA-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152 file 1 was not restor

11、ed from a sufficiently old backupORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'需要的不是這個(gè)redo文件，繼續(xù)指定！SQL recover database using backup controlfile until cancel;ORA-00279 change 911687 generated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaOR

12、CLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1 is in sequence #49Specify log =suggested filename AUTO CANCELfreeoracleoradataorclredo02.logORA-00310 archived log contains sequence 48; sequence 49 requiredORA-00334 archived log 'freeoracleoradataorclredo02.log'OR

13、A-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152 file 1 was not restored from a sufficiently old backupORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'仍然不是，繼續(xù)指定!SQL recover database using backup controlfile until cancel;ORA-00279 change 911687 gene

14、rated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1 is in sequence #49Specify log =suggested filename AUTO CANCELfreeoracleoradataorclredo03.logLog applied.Media recovery complete.SQL alter database open resetlogs;Database altered.SQL select count() from gaojf; COUNT()- 791392SQL

溫馨提示

  • 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

最新文檔

評(píng)論

0/150

提交評(píng)論