oracle备份与恢复

====================================================================================================================================================================[1](rman)[1.1]trace[1]--traceshutdownabort[2]--traceshutdown[3]--[4],[5],[5.1],[6],,shutdownabort[7],,shutdown[8],,shutdowncreatecontrolfilenoresetlogs,[1.2]RMANautobackup,catalog[1][2]--resetlogstrace[3]noresetlogtrace[4]?[5],,[1.3]RMAN,catalog[1.4],trace,[1]cleargroupor[2]traceresetlogs[3],,trace,resetlogs,[4],,trace,noresetlogs,,shutdownabort[1.5]trace,[1.5.1]trace,,shutdown[1.5.2]trace,,shutdownabort,[1]shutdownabort,resetlogtrace,,[2]shutdownabort,resetlogtrace,,,,trace[3]shutdownabort,,,,[1.5.3],trace[1.5.4],trace[1.6][1.7],,,[1](resetlogs),,,,,resetlogs,,,(resetlog,resetlogs,createdatafile)resetlogs,,1.12[2],,trace,[3],[4],,,trace,tracecreatedatafile[5],trace[6],,,[1.8],,,1.71[1.9],,,[1.10],,,[1.11][1.12],(,resetlogs)[1.13]resetlogsRMANresetlogs[1]resetlogs,resetlogs,resetlogs[2].(rman)[1],[2],MOUNT,[3],MOUNT,[4],MOUNT,OFFLINE[5],MOUNT,shutdownabort,[6],MOUNT,,[7],,,RMAN[8],,RMAN[9],,RMAN,[10],,RMAN,[3]redologfile(rman)[1][2]CLEARCLEARLOGFILECLEARLOGFILEUNARCHIVEDCLEARLOGFILEUNARCHIVEDGROUP?UNRECOVERABLEDATAFILE;[3],,trace,noresetlogs,,shutdownabort[4][5][6][4].(rman)[5]resetlogs[6]rmanRecoveringDatablocks[7].rmanRestoringDatafileCopiestoaNewHost[8].(rman)[8.1]rman[8.2]RMAN[8.3][8.4]rmantablespace[8.5]controlfile,datafile[8.6]rmansystem[9].[9.1].shutdown,,,[9.2].shutdownabort(),,,[9.3].shutdownabort(),,,[9.4].shutdownabort(),,,[9.5].shutdownabort(),,,[9.6].[10].[10.1][10.2][10.3][10.3_1][10.3_2]#######################################################################################################[1](rman)#######################################################################################################~~~~~~~~~~~~C:\DocumentsandSettings\lifeng.fangrmannocatalogtargetsys/sunsdl:9.2.0.1.0-ProductionCopyright(c)1995,2002,OracleCorporation.Allrightsreserved.:PDF(DBID=3171861129)--ID2334768642RMANconfigurecontrolfileautobackupon;RMAN:CONFIGURECONTROLFILEAUTOBACKUPON;RMANRMANconfigurecontrolfileautobackupformatfordevicetypediskto'c:\temp\%F';RMAN:CONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO'c:\temp\%F';RMANRMANRMANbackupdatabase;backup25-2-05:ORA_DISK_1ORA_DISK_1:sid=12devtype=DISK:ORA_DISK_2ORA_DISK_2:sid=13devtype=DISKORA_DISK_1:fullORA_DISK_1:fno=00002name=C:\ORACLE\ORADATA\PDF\UNDOTBS01.DBFfno=00003name=C:\ORACLE\ORADATA\PDF\INDX01.DBFfno=00005name=C:\ORACLE\ORADATA\PDF\USERS01.DBFORA_DISK_1:125-2-05ORA_DISK_2:fullORA_DISK_2:fno=00001name=C:\ORACLE\ORADATA\PDF\SYSTEM01.DBFfno=00004name=C:\ORACLE\ORADATA\PDF\TOOLS01.DBFORA_DISK_2:125-2-05ORA_DISK_1:125-2-05handle=C:\ORACLE\ORA92\DATABASE\07GDKT8C_1_1comment=NONEORA_DISK_1:,:00:00:56ORA_DISK_2:125-2-05handle=C:\ORACLE\ORA92\DATABASE\08GDKT8C_1_1comment=NONEORA_DISK_2:,:00:00:57backup25-2-05ControlFileandSPFILEAutobackup25-2-05handle=C:\TEMP\C-3171861129-20050225-00comment=NONEControlFileandSPFILEAutobackup25-2-05RMAN~~~~~~~~~~~~~~~~~~~~~~cpC:\ORACLE\ORADATA\PDF\*C:\ORACLE\ORADATA\bak####################################################[1.1]trace###################################################SQLaltersessionsettracefile_identifier=fanglf2;SQLalterdatabasebackupcontrolfiletotrace;SQLalterdatabasebackupcontrolfileto'c:\temp\controlfile.bak';~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~RMANRMANcopyCURRENTCONTROLFILETO'c:\cf.cpy';copy03-3-05:ORA_DISK_1ORA_DISK_1:sid=16devtype=DISKORA_DISK_1:=C:\CF.CPYcopy03-3-05~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SQLcolnameformata50SQLselect*fromv$controlfile;STATUSNAME---------------------------------------------------------C:\ORACLE\ORADATA\PDF\CONTROL01.CTLC:\ORACLE\ORADATA\PDF\CONTROL02.CTLC:\ORACLE\ORADATA\PDF\CONTROL03.CTL-~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ULTRAEDITCONTROL01.CTL~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~SQLselect*fromv$controlfile;STATUSNAME-------------------------------------------------------C:\ORACLE\ORADATA\PDF\CONTROL01.CTLC:\ORACLE\ORADATA\PDF\CONTROL02.CTLC:\ORACLE\ORADATA\PDF\CONTROL03.CTLSQLSQLcreatetabletest(aint,vvarchar(200));ULTRAEDITCONTROL01.CTLSQLselect*fromv$controlfile;-select*fromv$controlfile*ERROR1:ORA-12571:TNS:~~~~~~~~~~~~~~~~alert~~~~~~~~~~~~~~~~FriFeb2511:51:562005Errorsinfilec:\oracle\admin\pdf\bdump\pdf_ckpt_2556.trc:ORA-00227:corruptblockdetectedincontrolfile:(block1,#blocks1)ORA-00202:controlfile:'C:\ORACLE\ORADATA\PDF\CONTROL01.CTL'CKPT:terminatinginstanceduetoerror227FriFeb2511:51:582005Errorsinfilec:\oracle\admin\pdf\bdump\pdf_pmon_3084.trc:ORA-00227:corruptblockdetectedincontrolfile:(block,#blocks)InstanceterminatedbyCKPT,pid=2556~~~~~~~~~~~~~~~~trace~~~~~~~~~~~~~~~~Corruptblockrelativedba:0x00000001(file0,block1)Completelyzeroblockfoundduringcontrolfileheaderread***2005-02-2511:51:55.000ksedmp:internalorfatalerrorORA-00202:controlfile:'C:\ORACLE\ORADATA\PDF\CONTROL01.CTL'~~~~~~~~~~~~~~~~~~~~~~~~~~~~