Oracle英文版培訓課件之Backup and Recovery：Les-07-tspitr

PerformingTablespacePoint-in-TimeRecoveryObjectivesAftercompletingthislesson,youshouldbeableto:Determinewhentousetablespacepoint-in-timerecovery(TSPITR)ChoosethecorrectTSPITRtargettimePerformbasicRMANtablespacepoint-in-timerecoveryTablespacePoint-in-TimeRecovery(TSPITR)ConceptsTSPITRenablesyoutoquicklyrecoveroneormoretablespacestoanearliertime.TSPITRdoesnotaffectthestateofothertablespacesorobjectsinthedatabase.TablespacePoint-in-TimeRecovery(TSPITR):TerminologyTargettime:ThepointintimeorSCNthatthetablespacewillberecoveredtoRecoveryset:DatafilesthatcomposethetablespacestoberecoveredAuxiliaryset:DatafilesrequiredfortheTSPITRoftherecoverysetthatarenotpartoftherecoveryset.Ittypicallyincludes:SYSTEMtablespaceRollbackorundosegmenttablespacesTemporarytablespaceAuxiliarydestination:DisklocationtostorefilesTablespacePoint-in-TimeRecovery:ArchitectureTargetdatabaseAuxiliaryinstanceRMANDatafilebackupsArchivedredologfilesRecoveredtablespace12ControlfileRestoreRecoverRestoreTablespacePoint-in-TimeRecovery:ArchitectureTargetdatabaseAuxiliaryinstanceRMANRecoveredtablespace43ExportfileControlfile5ExportmetadataPointtorecoveredtablespaceImportmetadataUnderstandingWhentoUseTSPITRTSPITRcanbeusedinthefollowingsituations:TorecoverdatalostafteranerroneousTRUNCATE

TABLEstatementTorecoverfromlogicalcorruptionofatableToundotheeffectsofabatchjoborDMLstatementsthathaveaffectedonlyapartofthedatabaseTorecoveralogicalschematoadifferentpointfromtherestofthephysicaldatabaseTSPITRcannotbeusedto:RecoveradroppedtablespaceRecoverarenamedtablespacetoapointbeforeitwasrenamedPreparingforTSPITRPerformthefollowingstepstoprepareforTSPITR:Determinethecorrecttargettime.Determinewhatisneededintherecoveryset.IdentifyandpreserveobjectsthatwillbelostafterTSPITR.DeterminingtheCorrectTargetTimeYoucannotperformTSPITRasecondtimeunlessyouareusingarecoverycatalog.AfteryouperformTSPITRandbringthetablespaceonline,youcannotuseabackupfromanearliertime.Usethefollowingmethodstodeterminethecorrecttargettime:FlashbackQueryFlashbackTransactionQueryFlashbackVersionQueryDeterminingtheTablespacesfortheRecoverySetUsetheTS_PITR_CHECKviewtoidentifyrelationshipsthatspanrecoverysetboundaries.Ifobjectsinthetablespacethatyouarerecoveringhaverelationshipswithobjectsinothertablespaces,youcan:AddthetablespacethatcontainstherelatedobjectstotherecoverysetSuspendtherelationshipforthedurationofTSPITRRemovetherelationshipIdentifyingObjectsThatWillBeLostObjectscreatedinthetablespaceafterthetargetrecoverytimearelost.QueryTS_PITR_OBJECTS_TO_BE_DROPPEDtodeterminewhichobjectswillbelostfollowingTSPITR.UseExportpriortoTSPITRandImportfollowingTSPTIRtopreserveandre-createthelostobjects.PerformingBasicRMANTSPITRFullyautomatedTSPITR:Specifyanauxiliarydestination.RMANmanagesallaspectsofTSPITR.Thisistherecommendedmethod.CustomizedTSPITRwithanautomaticauxiliaryinstance:ThisisbasedonfullyautomatedTSPITR.Customizelocationoffiles.Specifyinitializationparameters.Specifychannelconfigurations.TSPITRusingyourownauxiliaryinstance:Configureandmanagetheauxiliaryinstance.PerformingFullyAutomatedTSPITRConfigurechannelsrequiredforTSPITRonthetargetinstance.SpecifytheauxiliarydestinationusingtheAUXILIARY

DESTINATIONoption.Backuptherecoveredtablespacesandbringthemonline.RMAN>CONNECTTARGETRMAN>RECOVERTABLESPACEusers,example>UNTILTIME'2006-03-31:08:00:00'>AUXILIARYDESTINATION>'/u01/app/oracle/oradata/aux';UsingEnterpriseManagertoPerformTSPITRUnderstandingTSPITRProcessingRMANperformsthefollowingsteps:Createstheauxiliaryinstance,startsit,andconnectstoitTakesthetablespacesthatwillberecoveredofflineRestoresabackupcontrolfilefromapointintimebeforethetargettimetotheauxiliaryinstanceRestoresthedatafilesfromtherecoverysettothetargetdatabaseandtheauxiliarysettotheauxiliaryinstanceRecoverstherestoreddatafilestothespecifiedtimeOpenstheauxiliarydatabasewiththeRESETLOGSoptionUnderstandingTSPITRProcessingExportsthedictionarymetadataaboutobjectsintherecoveredtablespacestothetargetdatabaseShutsdowntheauxiliaryinstanceImportsthedictionarymetadatafromtheauxiliaryinstancetothetargetinstanceDeletesallauxiliarysetfilesPerformingCustomizedRMANTSPITRwithanRMAN-ManagedAuxiliaryInstanceRenameorrelocateyourrecoverysetdatafiles.Specifyalocationotherthantheauxiliarydestinationforsomeoralloftheauxiliarysetdatafiles.CreateimagecopybackupsofyourdatafilesinadvanceofTSPITR.Useadifferentchannelconfigurationfortheauxiliaryinstance.SpecifydifferentinitializationparametersforyourRMAN-managedauxiliaryinstance.PerformingRMANTSPITRUsingYourOwnAuxiliaryInstanceNotrecommended,butsupportedPerformthefollowingsteps:CreateanOraclepasswordfilefortheauxiliaryinstance.Createaninitializationparameterfilefortheauxiliaryinstance.VerifyOracleNetconnectivitytotheauxiliaryinstance.StarttheauxiliaryinstanceinNOMOUNTmode.ConnecttheRMANclienttothetargetandauxiliaryinstances.ExecutetheRECOVER

TABLESPACEcommand.TroubleshootingRMANTSPITRFilenameconflicts:Ensureth