?

二.恢復(fù)Oracle 10g

• 在機(jī)器上安裝Oracle 10g軟件
  • 注意點(diǎn)1 ：一定要安裝對(duì)應(yīng)的Oracle版本，否則會(huì)因?yàn)檐浖姹竞蛿?shù)據(jù)庫文件(*.dbf)版本不一致而導(dǎo)致運(yùn)行失敗。
  • 注意點(diǎn)2 ：不同安裝包，相同的Oracle版本。可能會(huì)導(dǎo)致某些安裝后的文件夾路徑不一樣。在數(shù)據(jù)庫恢復(fù)后，你需要手動(dòng)修改配置文件才能正常運(yùn)。為了避免不必要的麻煩，建議使用與之前一樣的Oracle安裝包。
  • 注意點(diǎn)3 ：安裝Oracle軟件時(shí)，選擇和之前相同的安裝路徑，避免以后修改配置文件。
• 拷貝備份文件至對(duì)應(yīng)目錄，覆蓋之前的文件/目錄
  
• 啟動(dòng)數(shù)據(jù)庫
  • 設(shè)置環(huán)境變量
    
    • 開打.bash_profile文件
      • <!-- <br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> vim? / home / oracle /. bash_profile
    • 置環(huán)境變量?
      • <!-- <br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> export?ORACLE_BASE =/ u01 / app / oracle
        export?ORACLE_SID = orcl
        export?ORACLE_HOME = $ORACLE_BASE / product / 10.1 . 0 / db_1
        export?PATH = $PATH : $ORACLE_HOME / bin
        
  • 檢查tnsnames.ora，spfile$ORACLE_SID.ora文件配置是否正確
    • 檢查tnsnames.ora文件：
      • <!-- <br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> vim? $ORACLE_HOME / network / admin / tnsnames . ora
    • 檢查spfile$ORACLE_SID.ora文件
      • <!-- <br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> [oracle @vmlincn80ce5 ?database]$?sqlplus? / ?as?sysdba
        
        SQL * Plus : ?Release? 10.2 . 0.3 . 0 ? - ?Production?on?Mon?Sep? 28 ? 10 : 22 : 37 ? 2009
        Copyright?(c)? 1982 , ? 2006 , ?Oracle . ??All?Rights?Reserved .
        
        Connected?to :
        Oracle?Database?10g?Enterprise?Edition?Release? 10.2 . 0.3 . 0 ? - ?64bit?Production
        With?the?Partitioning , ?OLAP?and?Data?Mining?options
        SQL > create?pfile?from?spfile;
        SQL > exit
        [oracle @vmlincn80ce5 ? / ] $vim ? $ORACLE_HOME / dbs / init $ORACLE_SID . ora
        
        # #如果沒有需要修改的參數(shù)，完成退出！
        ##如果有需要修改的參數(shù)，并且已經(jīng)修改完成，繼續(xù)以下步驟。
        [oracle @vmlincn80ce5 ?database]$?sqlplus? / ?as?sysdba
        
        SQL * Plus : ?Release? 10.2 . 0.3 . 0 ? - ?Production?on?Mon?Sep? 28 ? 10 : 22 : 37 ? 2009
        
        Copyright?(c)? 1982 , ? 2006 , ?Oracle . ??All?Rights?Reserved .
        
        
        Connected?to :
        Oracle?Database?10g?Enterprise?Edition?Release? 10.2 . 0.3 . 0 ? - ?64bit?Production
        With?the?Partitioning , ?OLAP?and?Data?Mining?options
        SQL > create?spfile?from?pfile;
        # #完成。
    • 啟動(dòng)數(shù)據(jù)庫
      • <!-- <br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> [oracle @vmlincn80ce5 ?admin]$?sqlplus? / nolog
        
        SQL * Plus : ?Release? 10.2 . 0.3 . 0 ? - ?Production?on?Sun?Aug? 16 ? 14 : 41 : 27 ? 2009
        Copyright?(c)? 1982 , ? 2005 , ?Oracle . ??All?rights?reserved .
        
        SQL > ?conn?sys / youpassword?as?sysdba
        Connected?to?an?idle?instance .
        SQL > startup
        SQL > ?startup
        ORACLE?instance?started .
        
        Total? System ?Global?Area?? 188743680 ?bytes
        Fixed?Size??????????????????? 778036 ?bytes
        Variable?Size????????????? 162275532 ?bytes
        Database?Buffers??????????? 25165824 ?bytes
        Redo ?Buffers????????????????? 524288 ?bytes
        Database?mounted .
        Database?opened .
        SQL >
        # #啟動(dòng)數(shù)據(jù)庫完成!
    • 啟動(dòng)監(jiān)聽器?
    • 重新配置tnsnames.ora
      
    • 啟動(dòng)監(jiān)聽器?
      • <!-- <br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />--> [oracle @vmlincn80ce5 ?admin]$?lsnrctl?start
• 其他的后續(xù)操作(比如，重建同義詞，DBLink.......)

備份及恢復(fù)Oracle 10g