RMAN与带库Word文件下载.docx
《RMAN与带库Word文件下载.docx》由会员分享,可在线阅读,更多相关《RMAN与带库Word文件下载.docx(31页珍藏版)》请在冰豆网上搜索。
Home
BookList
Contents
Index
MasterIndex
Feedback
8
ConfiguringtheRecoveryManagerEnvironment
Thischapterdescribeshowtoperformsetupandconfigurationtasks.Thischaptercontainsthesetopics:
∙ConfiguringRMANtoMakeBackupstoaMediaManager
∙ConfiguringAutomaticChannels
∙ConfiguringtheControlFileandServerParameterFileAutobackup
∙ConfiguringtheBackupRetentionPolicy
∙ConfiguringtheMaximumSizeofBackupSets
∙ConfiguringBackupOptimization
∙ConfiguringtheNumberofBackupCopies
∙ConfiguringTablespacesforExclusionfromWholeDatabaseBackups
∙SettingGlobalizationSupportEnvironmentVariablesforRMAN
∙ConfiguringtheSnapshotControlFileLocation
∙SettingUpRMANforUsewithaSharedServer
∙SettingUpaRecoveryCatalog
ConfiguringRMANtoMakeBackupstoaMediaManager
Onmostplatforms,tobackuptoandrestorefromsequentialmediasuchastape,youmustintegrateamediamanagerwithOracle.AmediamanagerisnotanOracleproductandmustbeobtainedfromathird-partyvendor.IfyouchoosetouseRMANwithamediamanager,thenyoumustobtainallproduct-specificinformationfromthevendor.
ThissectiondescribesthegenericstepsforconfiguringRMANforusewithamediamanager.TheactualstepsdependonthemediamanagementproductthatyouinstallandtheplatformonwhichyouarerunningOracle.
Readthefollowingsectionsinorderwhenconfiguringthemediamanager:
1.PrerequisitesforUsingaMediaManagerwithRMAN
2.HowOracleInteractswiththeMediaManager
3.IntegratingRMANwiththeMediaManager:
BasicSteps
4.TestingWhethertheMediaManagerLibraryIsIntegratedCorrectly
5.ConfiguringAutomaticChannelsforUsewithaMediaManager
SeeAlso:
"
MediaManagement"
foranoverviewofmediamanagementsoftwareanditsimplicationsforRMAN
PrerequisitesforUsingaMediaManagerwithRMAN
BeforeyoucanbeginusingRMANwithamediamanager,youmustinstallitandmakesurethatRMANcancommunicatewithit.Instructionsforthisprocedureshouldbeavailableinthemediamanagervendor'
ssoftwaredocumentation.
Dependingontheproductthatyouareinstalling,thefollowingbasicstepsapply:
1.Installandconfigurethemediamanagementsoftwareonthetargethostorproductionnetwork.NoRMANintegrationisrequiredatthisstage.
2.Ensurethatyoucanmakenon-RMANbackupsofoperatingsystemfilesonthetargetdatabasehost.Thisstepmakeslatertroubleshootingmucheasier.Refertoyourmediamanagementdocumentationtolearnhowtobackupfilestothemediamanager.
3.Obtainandinstallthethird-partymediamanagementmoduleforintegrationwiththeOracleserver.ThismodulemustcontainthelibrarythatOracleloadswhenaccessingthemediamanager.
Ifyouhavenotperformedtheprecedingsteps,thendonotproceedwiththemediamanagementconfiguration.
HowOracleInteractswiththeMediaManager
Tomakebackupstoamediamanager,RMANmustcommunicatewithamediamanagementlibrary.TheprocedureforusingRMANwithamediamanagerinOracle9ihasnotchangedfrompreviousreleases.
Theloadingofamediamanagerlibraryisoperatingsystemspecific.WhenyouRMANallocateschannels,itusesthefollowingalgorithmwhendecidingwhichlibrarytoload:
1.AttemptstoloadthelibraryindicatedbytheSBT_LIBRARYparameterintheALLOCATECHANNELorCONFIGURECHANNELcommand.IftheSBT_LIBRARYparameterisnotspecified,thenOracleproceedstothenextstep.
2.Attemptstoloadthedefaultmediamanagementlibrary.Thefilenameofthedefaultlibraryisoperatingsystemspecific.OnUNIX,thelibraryfilenameis$ORACLE_HOME/lib/libobk.so,withtheextensionnamevaryingaccordingtoplatform:
.so,.sl,.a,andsoforth.OnWindowsNTthelibraryisnamed%ORACLE_HOME%\bin\orasbt.dll.
Note:
ThedefaultmediamanagementlibraryfileisnotpartofthestandardOracleinstallationasinpreviousreleases,soyoucanonlycreateitbyinstallingthird-partymediamanagementsoftware.
3.IfOracleisunabletolocatethedefaultlibraryinthepreviousstep,thenRMANissuesanORA-27211errorandexits.
Wheneverchannelallocationfails,OraclewritesatracefiletotheUSER_DUMP_DESTdirectory.Thefollowingshowssampleoutput:
SKGFQOSD:
Errorinfunctionsbtinitonline2278
LookforSBTTracemessagesinfile/oracle/rdbms/log/sbtio.log
SBTInitializefailedfor/oracle/lib/libobk.so
IntegratingRMANwiththeMediaManager:
BasicSteps
Afteryouinstallthemediamanagementsoftware,themediamanagementlibraryshouldalreadybeintegratedwiththeOracleserver.Youshouldnothavetoperformfurtherintegration.However,youmaychoosetofollowtheprocedureint