Oracleݿѻָ 

Ű칫Զ͵ķٷչҵϢϵͳԽԽߣݿΪϢϵͳĺĵҪĽɫһЩݿɿҪܸߵҵС֤ȯŵȣͣݶʧʧʮֲءΪݿԱӦԾҵҪƶϸݿⱸѻָԣͨģ϶ÿֿܵϸԣֻܱ֤ݵĸ߿ԡݿıһڵḶָֻ́ڷ¹ʺУָԿǱݵָ̣ĳ̶ȵĺû̶ܴڱݵ⣬ݿԱڻָʱȡĲȷҲֱӰյĻָҪOracleݿĸֹṩӦĻָķҲο 

ҪOracleݿⱸָʶбҪݿļ״̬гֵ˽⡣Oracleݿ״̬ҪΪ3֣Ϊ 
l NomountǰװOracleֻǶȡiniļеϢʼSGA 
l MountװOracleҪȡiniļҪȡļлȡйݿṹϢ 
l Open򿪣ݿҪļͬһʱ㣬Դлָδعտûʡ 

ݿıҪΪͣ䱸ݣȱݣ߼ݣ 
ݿıݲǱ۵ص㣬ֻһҪĽܣOracleݿⱸҪУ 
l Cold Backup䱸ݣ Ҫָڹرݿ״̬½еݿȫݣݰļļ־ļiniļ 
l Hot Backupȱݣ ָݿ⴦״̬£ļͿļбݣҪʹȱݱ뽫ݿ(Archive Log)鵵ʽ¡ 
l Export߼ݣ򵥵ıݷɰݿĳĳûݿ֧ȫۼơַʽʹַݿ봦ڴ״̬ݿⲻrestrict״̬ܱ֤ݵһԡ 

ݿĻָɷΪࣺȫָȫָ 
ȫָָݿָϵʱ㣬ʧκݡȫָָݿָǰĳһʱ㣬ʱԺиĶᶪʧûǽӦʹȫָ 
OracleݿĻ̷ָУȽѴ־ļеõļ֮δύлعݾͻָһʱˡݿĻָֻڷ֮ǰļָʱ̣ܽļع֮ǰĳһʱ̡ٸӣһ2001/1/1ݿⱸݣ2001/5/1ʹǷݿݷңϣݿָ2001/4/30ʱ״ֻ̬Ȼָ2001/1/1ݿⱸȻ¼ʹǰ2001/4/30ʱ״̬ܽ2001/5/1ݿع2001/4/30 
ΪϵͳݿĻָȶԿĴз࣬OracleݿҪΪ5ࣺ 
l SQLʧ 
l ߳ʧ 
l ʵʧ 
l ûʧ 
l 洢豸ʧ 
ǰʧܣҪΪ棬OracleϵͳԶлָû͵ʧܣɾݣǲȡĲȴʩҪеµ߼ݻеĳһʱĲȫָOracle 8֮°汾˻ڱռʱָ(TSPITR)Եıռָָʱ䣬ضݿвȫֱָȽϼʱҲԿʹlogminerɷSQL 

Դ洢豸ʧܵȽϸҲǱ۵ص㣬洢豸ʧܱȻʹϵļΪãȽOracleݿ漰ļһ֣ҪɷΪ 
l OracleϵͳļָOracleļӦó 
l ݿļ 
l ݿ־ļ 
l ļ 
l 鵵־ļ 
һļʧҪϵͳԱвϵͳıݣ¹ʺֻϵͳݽָ 
ļм¼ݿĽṹÿļ״ϵͳSCNҪϢڴݿʱûָλſļ֮以Ϊ񣬵κһϣֻ轫iniļע͵ļͿ½пȫʧЧʱNomountģʽִcreate controlfileɿļṩredo logdata fileļ͵ַԼMAXLOGFILESMAXDATAFILESMAXINSTANCESϢʧ֮ǰйalter database backup controlfile to tracealter database backup controlfile to xxxԿļݣָʱʹɵĽűؽñļǣʹ˾ɵĿļڻָʱҪʹrecover xxx using backup controlfileѡлָʹresetlogsѡݿ⡣ 
ʧ־ļ1ʧǷǻ־ļ2ʧǵǰ־ļ 
ǵһϵ־ļ־жԱȽݿshutdownȻòϵͳ־ļкõ־Աļ𻵵ĳԱļǣͬһ־Աе־ļĸΪģλòÿɽ俽µϣʹalter database rename file xxxx to xxxxıļλã֮ݿ⣬Ͻһ䱸ݡ𻵵־ֻһ־Աmountݿ⣬תΪnoarchivelogģʽִalter database add logfile member xxx to group xһԱִalter database drop logfile member bad_file𻵵־ļɾݿĽṹ䶯Ҫݿļ֮ݿĻarchivelogģʽһ䱸ݡ 
ʧǵǰ־ļݿûоҵǰ־гԱΪáȽݿshutdown abortһȫлָеļݿmount״̬ԭ־ļλòãʹalter database rename file xxx to xxxıļĴλáȻʹrecover database until cancelָݿ⣬ֱʾһ鵵־֮cancel֮alter database open resetlogsݿ⣬û⣬һ䱸ݡע⣡а𻵵redo logеϢᶪʧҲ˵ݿǰѾύпܻᶪʧĳЩҪܸߵӦýʧأӦʹÿ־ж־Աҷڲͬһֹʹϡ 
ļϵҲΪ1ʧSYSTEMռļ2ʧûлعεķSYSTEMļ3ʧлعεķSYSTEMļ 
𻵵ϵͳռļΨһİ취Ǵһαлָļԭλòʹalter database renameıļλã֮ݿmount״ִ̬recover database/datafileݿлظܽݿ򿪡ע⣺SYSTEMռеļѻݿ޷򿪵ģ˱mount״̬½еĻָɡ 
ʧļϵͳռҲعʱпѡݿ״̬½лָ---ݿopen״̬ݿmount״̬ûڷݿδ𲿷ֵݻ𻵵ļлָҪܳʱ䣬ʹļѻݿ򿪸ûʣٻָļ£ݿmountʱصļռѻalter database datafile xxx offlineȻݿopenʹݿδĲȹûʣ֮ٽrecover datafile/tablespaceɺalter database datafile/tablespace xxx onlineʹָͿɱˡ ȻûҲѡݿmount״̬£recover database/datafileеĻָ꣬ļһ򿪹ûʡ 
ʧļһлعεķϵͳռļҲѡݿopen״̬mount״̬»ָһͬǵعεļʱʹofflineݿ򿪣ôݿǰδύ漰ı޷ʣҲ˵ڻعλָǰ漰Ķ󶼲ʡҵаعεļoffline״̬ʱݿ޷κDMLݿopen״ָ̬عεļʱȴʱعιʹcreate rollback segment temp1 tablespace system; alter rollback segment temp1 online;ļָٽɾalter rollback segment temp1 offline; drop rollback segment temp1;ע⣺ַʹָļonline֮еԭлعνoffline״ֹ̬ʹalter rollback segment RBSxx online;ʹǻָ״̬ܱݿʹáݿmount״̬лָҪ衣 
ʧļûûйǰļıݣԴӶʧļ罨֮һֱûʹùresetlogsѡ򿪹ݿ⡣Ҳ˵ûĿļ𻵵ļǰģ鵵־аļ¼ûͻһָֻûȽ𻵵ļռѻalter database datafile / tablespace xxx offlineִ֮alter database create datafile new/xxx.dbf as old/xxx.dbfݿݱڿļеϢؽһյļִ֮recover tablespace / datafile¼õļʹȫָǰ״̬֮ٽָ 
ʧһļ---鵵ļ鵵ļλòãshutdownݿ⣬һ䱸ݡȻ޸iniļеĹ鵵־ļĿ·ݿ⡣ԺٷֻµıнļָݿrecoverʱͲҪ֮ǰʧĹ鵵ļˡOracle 8֮°汾ṩlog_archive_duplex_destlog_archive_dest_1...5Ȳݹ鵵ļͬλãԶ˷Ӷ֤鵵ļĿɿԡ 

˵ݿָʱע 
1.Ĭǰݿڹ鵵(ARCHIVELOG)ʽ£ֻ漰һ㳣ĻָʹOracleṩĻָRMANҲлȽϸӽʹRMANݺͻָ 
2.һݿⷢѣڽлָ֮ǰһȫ䱸ݣԱڽлָʱԽвȡܴһݶʧڲȷĻָġ 
3.ݿɻָ֮ʹresetlogsѡݿ֮ҪϹرݿһȫ䱸ݡΪΪֹ־´λָʱٴãresetlogsѡ´redo logļļ㣬⽫ʹ֮ǰбݽΪãһ£ 
4.Ҫرע⵱ݿȫָӷϵʱǰıлָļʱһҪʹеredo logļ˵ǰredo logļֻܽвȫָҪʧһˡ 
ԭ: 
