Thisexampleassumes:
v TheTivoliStorageManagerbackup-archiveclientisinstalledonNodeA1inthe /usr/tivoli/tsm/client/ba/bindirectory.
v DataProtectionforOracleisinstalledonNodeA1inthe/usr/tivoli/tsm/
client/oracle/bin64directory.
v AnAIXoperatingsystemisused.
Itisrecommendedthatthepasswordexpirationfor theData ProtectionforOracle node (NodeA1)be settonotexpire.Otherwisethepasswordwillbecomeoutof syncbetweenData ProtectionforOracle andthescheduler.Thiscanbe doneby specifying passwordaccessgenerate. However,ifpasswordaccess promptisalready specified,youcanpreventpasswordexpirationbyissuingthefollowingcommand:
update node NodeA1 passexp=0
Scheduling DataProtectionforOraclebackupswith theTivoliStorageManager scheduler requiresspecialconfigurationissuestobe addressed.Thisprocedure addressesthis issuebycreating adsm.sysfilefromwhichtoassociatenodesfor your client,DataProtectionforOracle,andscheduledbackups:
1. Createa dsm.sysfileinthe/usr/tivoli/tsm/client/ba/bindirectory(ifone doesnotalreadyexist) andaddthefollowingservernamestanzas:
|
|
|
|
|
|
|
|
|
|
a. Addaservernamestanzaforthefilesystembackupsassociatedwith your TivoliStorageManagerbackup-archiveclient.
Forexample:
servername TSMbackup
commmethod tcpip
tcpserveraddress site.xyzinc.com
tcpport 1500
nodename client
passwordaccess generate
TheservernameTSMbackupsettingmustbe specifiedinthedsm.optfile associatedwiththeTivoliStorageManagerbackup-archiveclient.The defaultdirectorylocationis/usr/tivoli/tsm/client/ba/bin.
b. Addaservernamestanzaforthebackupsassociatedwith DataProtection forOracle.
Forexample:
servername TSMOracle
commmethod tcpip
Replace<oracleuser>withtheOracleUserIDofthetargetOracledatabase instance.TheservernameTSMOraclesettingmustbe specifiedinthedsm.opt fileassociatedwithData ProtectionforOracle.Thedefaultdirectory
locationis/usr/tivoli/tsm/client/oracle/bin64.Thisdsm.opt filecan haveauniquename,suchasdsmoracle.opt.Makesurethedsmi_orc_config optionspecifiestheuser optionsfile(dsmoracle.optinStep1b)associated withData ProtectionforOracle.For example:
dsmi_orc_config /usr/tivoli/tsm/client/oracle/bin64/dsmoracle.opt c. Addaservernamestanzaforthescheduled backupsassociatedwithData
ProtectionforOracle.
Replace<oracleuser>withtheOracleUserIDofthetargetOracle database instance.
2. Makesurethereisasymboliclinktothisdsm.sysfilesothatthefileis available totheTivoliStorageManagerAPIdirectory(/usr/tivoli/tsm/
client/api/bin64).
3. Createtheschedulerbackupscript(schedbkdb.scr)inthe/usr/tivoli/tsm/
client/oracle/sched/directory.Thisisthescheduler backupscriptthatwas definedfortheschedulerinStep1in“PartI:On theTivoliStorageManager server” onpage66.Thisschedulerbackupscriptwillrunthecommandscript (mysched.scr),whichwillruntheRMANbackupscript(bkdb.scr).Thisisan
|
4. Createthecommandscript (mysched.scr)inthe/home/oracle/sched/ directory.
Thisisan exampleofthecommandscript(mysched.scr):
#!/bin/ksh
export ORACLE_HOME=/orc91/app/oracle/product/912 export PATH=$ORACLE_HOME/bin:$PATH
rman target agnttest/agnttest@target rcvcat rman/rman@rman
cmdfile /home/oracle/sched/bkdb.scr msglog /home/oracle/sched/bkdb.log You must placethecommandtext, rman target agnttest/agnttest@target rcvcat rman/rman@rman and cmdfile /home/oracle/sched/bkdb.scr msglog /home/oracle/sched/bkdb.log,onthesamelineinthis commandscript.The commandtextisplacedontwolinesinthisexample toaccommodatepage formatting.
5. CreatetheRMANbackupscript(bkdb.scr)inthe/home/oracle/sched/
directory.ThisisanexampleoftheRMANbackupscript(bkdb.scr):
run {
allocate channel t1 type ’sbt_tape’ parms
’ENV=(TDPO_OPTFILE=/home/oracle/sched/tdpo.opt)’;
allocate channel t2 type ’sbt_tape’ parms
’ENV=(TDPO_OPTFILE=/home/oracle/sched/tdpo.opt)’;
backup
format ’df_%t_%s_%p_%u_%c’
(database); }
6. Loginastherootuser tothemachine whereDataProtectionforOracleis installedasnodenameNodeA1.
7. Starttheschedulerintheinittab.Usetheservernameparametertospecifythe correctstanza touseinthedsm.sysfile:
dsmc sched -servername=DPSched
Data ProtectionforOracle isnow enabledforscheduledbackups.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Appendix C. Support information
Ifyouhaveaproblemwithyour IBMsoftware,youwanttoresolveit quickly.This section describesthefollowingoptionsforobtaining supportforIBMsoftware products:
v “Whattodowhen youencountera problem”
v “Searchingknowledgebases”onpage71 v “Obtainingfixes”onpage71
v “Receivingweeklysupportupdates”onpage72 v “ContactingIBMSoftwareSupport”onpage72
What to do when you encounter a problem
Ifyouencountera problemwhileusingData Protectionfor Oracleorifyoucannot start DataProtectionforOracle,dothefollowing:
1. Runthetdpoconfutilityshowenvironmentcommandtocollectinformationon your optionsfile(–TDPO_OPTFILE=)and specifiedoutputfiles(–outfile=).
2. Iftheabovecommandransuccessfully,checkitsoutputtoseeif thesetup workedasexpected.
3. Iftheabovecommandfailed,check thetdpoerror.log anddsierror.logfiles.The tdpoerror.log isa logfilecreated intheinstallationdirectory bydefault.The dsierror.logisgeneratedbytheTivoliStorageManagerAPIwhena problem occurswiththeTivoliStorageManagerAPIsetup.
4. Fix theproblemandrunthetdpoconfutilityagain.
5. VerifythattheOracletargetdatabase instanceissymbolicallylinkedwithData ProtectionforOracle:
a. Login astheOracleuser.
b. Runthefollowingcommand:
$ ls -al $ORACLE_HOME/lib/libobk.a
Lookforthelibobk link(s)inthesystem'srespective32-bit or64-bitlibrary directory.
c. Verifythatthelinkpoints toafilethatexists.Forexample:
$ORACLE_HOME/lib/libobk.a -> /opt/tivoli/tsm/client/oracle/bin64/libobk64.a
or
$ORACLE_HOME/lib/libobk.so -> /usr/lib/sparcV9/libobk.so
/usr/lib/sparcV9/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk64.so
Makesurethatthefinallinkdestinationisthecorrectbitleveland pointsto afilethatexists.
6. Iftheproblempersists,gatherthefollowinginformation:
v Thetdpo.optfilespecifiedbyTDPO_OPTFILEvariableintheRMANscript v Thedsm.opt filespecifiedbydsmi_orc_configinthetdpo.optfile
v Thedsm.sys file
v TheData Protectionfor Oracleerrorlogfile(tdpoerror.log) inthefollowing location(listedfromhighest tolowestprecedence):
– Thevalue oftheTivoliStorageManagerAPIerrorlognameoption specifiedinthedsm.sysfile.
– Thevalue ofthedsmi_logenvironmentvariable. Makesuredsmi_log (specifiedinthetdpo.optfile)specifiesa directorywithRead/Write permissionsfortheOracleuser.By default,thedsmi_logenvironment variable specifiesadirectory ownedbyroot.
– Ifa failureoccursduring optionprocessingfortheinitialization,the tdpoerror.log filemaybe locatedin$ORACLE_HOME/bin.
v TheTivoliStorageManagerAPIerrorlogfile(dsierror.log)inthefollowing location(listedfromhighest tolowestprecedence):
– Thevalue oftheTivoliStorageManagerAPIerrorlognameoption
specifiedinthedsm.sysfile.Makesureerrorlognamespecifiesa directory andfilenamewithRead/WritepermissionsfortheOracleuser.
– Thevalue ofthedsmi_logenvironmentvariable.
v TheRMAN logfile
v TheTivoliStorageManagerAPItracefile
TogeneratetheTivoliStorageManagerAPItracefile,addthefollowinglines inyour dsm.optfile:
tracefile /home/oracle/rman/tsmapi.out traceflag service
v Thenode informationontheTivoliStorageManagerserver.Toobtainthis information,enter:
query node <nodename> format=detail v
TheTivoliStorageManagerserveractivity log.Toobtainthisinformation, enterthisTivoliStorageManageradministratorcommand:
query actlog
Notethatthiscommandprovidesoneprevioushourofactivity. Sincethe activity logshouldbe obtainedforthetimeperiodimmediatelypriortothe failed operationuntilafewmomentsafterthefailedoperation,youcan specifythefollowingsettingstoobtainactivityfortheexacttimeoffailure:
query actlog begindate=MM/DD/YYYY begintime=HH:MM:SS v TheData Protectionfor Oracletracefile
TogeneratetheDataProtectionforOracletracefile,addthefollowinglines inyour tdpo.optfile:
tdpo_trace_flags orclevel0 orclevel1 orclevel2 tdpo_trace_file /home/oracle/rman/tdpo.out
where:
orclevel0
Traces outfunctionexitpoints whenerrorsoccur.
orclevel1
Traces outnormalfunctionentryandexitpoints.
orclevel2
Traces outmoredetailedinformation.
Note: Anypath andfilenamecanbe specifiedforthetdpo_trace_fileand tracefileoptions.However,thedirectorymust existand havewritable rights.
Searching knowledge bases
Youcansearchtheavailableknowledgebasestodeterminewhetheryour problem was alreadyencountered andisalreadydocumented.
Searching the information center
IBM providesextensivedocumentationthatcanbe installedonyour local computeroronan intranetserver.Youcanusethesearchfunctionofthis informationcenter toqueryconceptualinformation,instructions forcompleting tasks, andreferenceinformation.
Searching the Internet
Ifyoucannotfindananswertoyourquestionintheinformationcenter,searchthe Internet forthelatest,mostcompleteinformationthatmighthelpyouresolveyour problem.
Tosearchmultiple Internetresourcesforyour product,goto thisproductsupport website: http://www.ibm.com/software/sysmgmt/products/support/
IBMTivoliStorageManager.htmlandlookforthesectiontosearchthesupport knowledgebase.From thissection,youcansearcha varietyofresources including:
v IBMtechnotes v IBMdownloads v IBMRedbooks™
v Forumsand newsgroups
YoucanalsosearchtheIBMTivoliStorageManager:ProblemDeterminationGuidefor helpfuldiagnosticinformationat thisWebsite:http://publib.boulder.ibm.com/
infocenter/tivihelp/v1r1
/topic/com.ibm.itsmm.doc/update/main.html
Obtaining fixes
Aproductfixmightbe availabletoresolveyour problem.Todeterminewhatfixes are availableforyour IBMsoftwareproduct,followthesesteps:
1. GototheIBM SoftwareSupportWebsiteathttp://www.ibm.com/software/
support.
2. ClickDownloadsanddriversintheSupporttopicssection.
3. SelecttheSoftwarecategory.
4. Selecta productintheSub-categorylist.
5. IntheFinddownloadsanddriversbyproductsection,selectonesoftware categoryfromtheCategorylist.
6. SelectoneproductfromtheSub-categorylist.
7. Typemore searchtermsintheSearchwithinresultsifyouwanttorefineyour search.
8. ClickSearch.
For moreinformationaboutthetypesoffixesthatareavailable,seetheIBM SoftwareSupportHandbookat http://techsupport.services.ibm.com/guides/
handbook.html.
Receiving weekly support updates
Toreceiveweeklye-mailnotificationsaboutfixesandothersoftwaresupportnews, followthesesteps:
1. GototheIBMSoftwareSupportWebsiteat http://www.ibm.com/software/
support.
2. Click Mysupportintheupperrightcornerofthepage.
3. If youhavealreadyregisteredforMy support,signinand skiptothenext step. Ifyouhavenotregistered,click registernow.Completetheregistration form usingyour e-mailaddress asyourIBMIDandclick Submit.
4. Click Editprofile.
5. IntheProductslist,selectSoftware.Asecondlistisdisplayed.
6. Inthesecondlist,selecttheproductsegment,StorageManagement.Athird listisdisplayed.
7. Inthethirdlist,selecttheproductsub-segment,Data Protection.Alistof applicable productsisdisplayed.
8. Select theproductsforwhichyouwanttoreceiveupdates,forexample,IBM TivoliStorageManagerforDatabases.
9. Click Addproducts.
10. Afterselectingallproductsthatareofinterest toyou,clickSubscribeto email ontheEditprofiletab.
11. SelectPlease sendthesedocumentsbyweeklyemail.
12. Update youre-mailaddressasneeded.
13. IntheDocumentslist,selectSoftware.
14. Select thetypesofdocumentsthatyouwanttoreceiveinformationabout.
15. Click Update.
Ifyouexperienceproblemswith theMy supportfeature,youcanobtainhelpin one ofthefollowingways:
Online
[email protected],describingyour problem.
By phone
Call1-800-IBM-4You(1-800-426-4968).
Contacting IBM Software Support
IBM SoftwareSupportprovides assistancewith productdefects.
Before contactingIBMSoftwareSupport,yourcompanymusthaveanactiveIBM software maintenancecontract,and youmustbe authorizedtosubmitproblemsto IBM. Thetypeofsoftwaremaintenancecontractthatyouneed dependsonthe type ofproductyouhave:
v ForIBMdistributed softwareproducts(including,butnotlimited to,Tivoli, Lotus®,and Rational®products,aswellasDB2®and WebSphere®productsthat runonWindows® orUNIX®operatingsystems),enroll inPassportAdvantage® inoneofthefollowingways:
Online
GotothePassportAdvantage Websiteat http://www.lotus.com/
services/passport.nsf/WebDocs/
Passport_Advantage_Home andclickHowto Enroll.
Byphone
For thephonenumber tocallinyourcountry,gototheIBMSoftware SupportWebsiteathttp://techsupport.services.ibm.com/guides/
contacts.html andclickthenameofyourgeographicregion.
v ForcustomerswithSubscriptionandSupport(S&S)contracts,go tothe SoftwareServiceRequestWebsiteathttps://techsupport.services.ibm.com/
ssr/login.
v ForcustomerswithIBMLink,CATIA,Linux,OS/390,iSeries,pSeries,zSeries, andothersupportagreements,gototheIBM SupportLine Websiteat http://www.ibm.com/services/us/index.wss/so/its/a1000030/dt006.
v ForIBMeServer™software products(including, butnotlimitedto,DB2and WebSphereproductsthatrunin zSeries,pSeries,andiSeries environments),you canpurchasea softwaremaintenanceagreementbyworkingdirectlywithan IBMsalesrepresentativeoranIBMBusiness Partner.For moreinformation aboutsupport foreServersoftware products,go totheIBM TechnicalSupport AdvantageWebsiteathttp://www.ibm.com/servers/eserver/techsupport.html. Ifyouarenotsurewhattypeofsoftwaremaintenancecontractyouneed,call 1-800-IBMSERV (1-800-426-7378)intheUnitedStates.Fromothercountries,goto thecontactspageoftheIBMSoftwareSupportHandbookontheWebat
http://techsupport.services.ibm.com/guides/contacts.htmland clickthename of yourgeographicregionforphonenumbersofpeoplewhoprovidesupportfor your location.
Tocontact IBMSoftwaresupport,followthese steps:
1. “Determiningthebusinessimpact”
2. “Describingproblemsand gatheringinformation”onpage74 3. “Submittingproblems”onpage74
Determining the business impact
Whenyoureporta problemtoIBM,youareasked tosupplyaseveritylevel.
Therefore,youneed tounderstandand assessthebusinessimpactof theproblem thatyouarereporting.Usethefollowingcriteria:
Severity1
Theproblemhasacriticalbusinessimpact.Youareunabletousethe program, resultinginacriticalimpactonoperations.Thiscondition requiresanimmediatesolution.
Severity2
Theproblemhasasignificantbusinessimpact.Theprogramisusable,but it isseverelylimited.
Severity3
Theproblemhassomebusinessimpact.The programisusable,butless significantfeatures(notcriticalto operations)areunavailable.
Severity4
Describing problems and gathering information
Whendescribinga problemtoIBM,beasspecificaspossible.Includeallrelevant backgroundinformationsothatIBMSoftwareSupportspecialists canhelp you solve theproblemefficiently.Tosave time,knowtheanswers tothesequestions:
v Whatistheoperatingsystemplatform,version,andrelease levelofthemachine onwhichyour TivoliStorageManagerserverproductisinstalled?
v
Whatistheversionand releaselevelofyour TivoliStorageManagerserver product?Enterthequerystatuscommandtodeterminethis information.For example:
query status
v TheversionandreleaselevelofyourData ProtectionforOracleproductand the TivoliStorageManagerAPI.Youcanlocatethisinthereadmedporc_enu.htmfile orbyrunningthefollowingcommands:
– AIX:
lslpp -L "tivoli.tsm.*"
Youcanalsoenterthewhat/usr/lib/libobk.acommand – HP-UX:
swlist -v <Data Protection for Oracle installable file>
swlist -v TIVsmCapi
YoucanalsolistallTivolipackage nameswiththiscommand:
swlist | grep Tivoli – Linux:
rpm -qa "TDP*"
rpm -qa "TIVsm-API*"
– Solaris:
pkginfo -l <Data Protection for Oracle installable file>
pkginfo -l TIVsmCapi
YoucanalsolistallTivolipackage nameswiththiscommand:
pkginfo -l | grep Tivoli
Youcanalsoenterthewhat/usr/lib/libobk.socommand.
v Whatsoftwareversionswere yourunningwhentheproblemoccurred?
v WhatarethebitlevelsoftheOracleinstance,Data ProtectionforOracle,and TivoliStorageManagerAPI?Thesebitlevelsshouldbe thesameamongthese threeproducts.
v Doyouhavelogs,traces,andmessagesthatare relatedtotheproblem symptoms?IBMSoftwareSupportislikelytoaskforthis information.
v Canyoucreatetheproblemagain?Ifso, whatstepswereperformedtocreate theproblem?
v Didyoumakeanychangestothesystem?Forexample,didyoumakechanges tothehardware,operatingsystem,networkingsoftware,andsoon.
v Areyoucurrentlyusingaworkaround fortheproblem? Ifso,beprepared to explaintheworkaroundwhenyoureporttheproblem.
Submitting problems
Youcansubmityour problemtoIBM SoftwareSupportinoneoftwoways:
Online
Click SubmitandtrackproblemsontheIBMSoftwareSupportsiteat
http://www.ibm.com/software/support/probsub.html.Type your informationintotheappropriateproblemsubmissionform.
By phone
For thephonenumberto callinyour country,gotothecontactspageof theIBMSoftwareSupportHandbookat http://
techsupport.services.ibm.com/guides/contacts.htmlandclick thename ofyour geographicregion.
Iftheproblemyousubmit isfora softwaredefectorformissingorinaccurate documentation, IBMSoftwareSupportcreatesanAuthorized ProgramAnalysis Report (APAR).TheAPARdescribestheproblemindetail.Wheneverpossible, IBM SoftwareSupportprovides aworkaroundforyoutoimplementuntilthe APARisresolvedand afixisdelivered.IBM publishesresolvedAPARsonthe IBM productsupport Webpagesdaily,sothatotheruserswhoexperiencethe same problemcanbenefitfromthesameresolutions.
For moreinformationaboutproblemresolution,seeSearchingknowledgebases and Obtainingfixes.
Appendix D. Accessibility
Accessibilityfeatureshelpuserswithphysicaldisabilities, suchasrestricted mobilityorlimited vision,tousesoftwareproductssuccessfully.Themajor accessibilityfeaturesinthisproductenable userstodo thefollowing:
v Useassistivetechnologies,suchasscreen-readersoftwareanddigitalspeech synthesizer,tohearwhatisdisplayedonthescreen.Consult theproduct
documentationoftheassistivetechnologyfordetailsonusingthosetechnologies withthisproduct.
v Operatespecificor equivalentfeaturesusingonlythekeyboard.
v Magnifywhatisdisplayedonthescreen.
Inaddition,theproductdocumentationwasmodifiedtoincludefeaturestoaid accessibility:
v Alldocumentationisavailable inbothHTMLandconvertiblePDFformatsto givethemaximumopportunityforuserstoapplyscreen-readersoftware.
v
Allimagesinthedocumentationareprovided withalternativetextsothatusers
Allimagesinthedocumentationareprovided withalternativetextsothatusers