Db2备份和恢复.docx
《Db2备份和恢复.docx》由会员分享,可在线阅读,更多相关《Db2备份和恢复.docx(13页珍藏版)》请在冰豆网上搜索。
Db2备份和恢复
Db2backupandrestore
1install
EB-DB-TEST@/#/software/veritas/NB_60MP4_UOptions_20061204b/install
VERITASInstallationScript
Copyright1993-2005VERITASSoftwareCorporation,AllRightsReserved.
InstallationOptions
1NetBackupAdd-OnProductSoftware
2NetBackupDatabaseAgentSoftware
qToquitfromthisscript
Chooseanoption[default:
q]:
2
**********
Therearetwowaystoinstalldatabaseagentsoftware.
1.RemoteInstallation:
Loadsthesoftwareonaserverwith
theintentofpushingdatabasesoftwareouttoaffectedclients.
2.LocalInstallation:
Loadsandinstallsthesoftwareonlytothis
localmachine.
**********
Doyouwanttodoalocalinstallation?
[y,n](n)y
**********
NetBackupDatabaseAgentInstallation
ChoosetheDatabaseAgentsyouwishtoinstall
oneatatimeorselectInstallAllDatabaseAgents.
1)NetBackupforDB2
2)NetBackupforInformix
3)NetBackupforLotusNotes
4)NetBackupforOracle
5)NetBackupforSAP
6)NetBackupforSybase
7)InstallAllDatabaseAgents
q)DoneSelectingAgents
x)ExitfromthisScript
Chooseanoption:
1
Chooseanoption:
q
YouhavechosentoinstalltheseDatabaseAgents:
NetBackupforDB2
Isthislistcorrect?
[y,n](y)
**********
Oftheagentsselected,thefollowingaresupported
onthisplatformandwillbeinstalled:
DB2
LoadingtheDatabaseAgentpackagesintothe
/usr/openv/netbackup/dbextdirectoryandinstalling.
**********
InstallingNetBackupforDB2
InstallingNetBackupforDB2...
Extractingfilesfrom/usr/openv/netbackup/dbext/DB2.rs6000_51.tar.Z...
xusr/openv/netbackup
xusr/openv/netbackup/bin
xusr/openv/netbackup/bin/bpubsdb2,144645bytes,283tapeblocks
xusr/openv/netbackup/bin/bpdbsbdb2,1281112bytes,2503tapeblocks
xusr/openv/netbackup/bin/bpdb2proxy,1266244bytes,2474tapeblocks
xusr/openv/netbackup/bin/db2_config,7072bytes,14tapeblocks
xusr/openv/netbackup/bin/nbdb2.sl,99193bytes,194tapeblocks
xusr/openv/netbackup/bin/db2uext2,99770bytes,195tapeblocks
xusr/openv/netbackup/bin/nbdb2.sl64,108131bytes,212tapeblocks
xusr/openv/netbackup/bin/db2uext2.64,108276bytes,212tapeblocks
xusr/openv/netbackup/bin/db2rhf,68380bytes,134tapeblocks
xusr/openv/netbackup/bin/db2rhf.64,75127bytes,147tapeblocks
xusr/openv/netbackup/ext
xusr/openv/netbackup/ext/db_ext
xusr/openv/netbackup/ext/db_ext/db2
xusr/openv/netbackup/ext/db_ext/db2/scripts
xusr/openv/netbackup/ext/db_ext/db2/scripts/db2.conf,2227bytes,5tapeblocks
xusr/openv/netbackup/ext/db_ext/db2/scripts/db2_backup,1736bytes,4tapeblocks
xusr/openv/netbackup/ext/db_ext/db2/scripts/db2_restore,1245bytes,3tapeblocks
xusr/openv/netbackup/ext/db_ext/db2/scripts/db2_all_backup_mpp,5269bytes,11tapeblocks
xusr/openv/netbackup/ext/db_ext/db2/scripts/db2_all_restore_mpp,5383bytes,11tapeblocks
xusr/openv/netbackup/dbext
xusr/openv/netbackup/dbext/DB2.rs6000_51.version,26bytes,1tapeblocks
xusr/openv/lib
xusr/openv/lib/libdbsbdb2.so,1898359bytes,3708tapeblocks
xusr/openv/lib/libnbbedb2.so,175382bytes,343tapeblocks
xusr/openv/lib/libnbbedb2MT.so,172370bytes,337tapeblocks
NetBackupforDB2installationcompleted.
**********
Executionof./install_dbextiscomplete.
Executionof./installiscomplete.
File/usr/openv/tmp/install_options_trace.811250containsatraceofthisinstall.
VERITASInstallationScript
Copyright1993-2005VERITASSoftwareCorporation,AllRightsReserved.
InstallationOptions
1NetBackupAdd-OnProductSoftware
2NetBackupDatabaseAgentSoftware
qToquitfromthisscript
Chooseanoption[default:
q]:
q
File/usr/openv/tmp/install_options_trace.811250containsatraceofthisinstall.
Thatfilecanbedeletedafteryouaresuretheinstallwassuccessful.
EB-DB-TEST@/#
2configuration
2.1getdbname
[db2inst8@EB-DB-TESTdb2dump]$db2listdbDIRECTORY
SystemDatabaseDirectory
Numberofentriesinthedirectory=1
Database1entry:
Databasealias=LIFEPLAN
Databasename=LIFEPLAN
Localdatabasedirectory=/db2data/db2inst8/lifeplan
Databasereleaselevel=b.00
Comment=LIFEPLANdatabase
Directoryentrytype=Indirect
Catalogdatabasepartitionnumber=0
Alternateserverhostname=
Alternateserverportnumber=
[db2inst8@EB-DB-TEST~]$db2listapplications
AuthIdApplicationAppl.ApplicationIdDB#of
NameHandleNameAgents
-----------------------------------------------------------------------------------------------------------
DB2INST8db2taskd10*LOCAL.DB2.080721060622LIFEPLAN1
DB2INST8db2stmm9*LOCAL.DB2.080721060621LIFEPLAN1
DB2INST8db2bp8*LOCAL.db2inst8.080721060617LIFEPLAN1
2.2db2_config
EB-DB-TEST@/usr/openv/netbackup/bin#./db2_config
PleasespecifytheDB2instancehomepathname:
/db2instance/db2inst8
DoyouhaveotherDB2instances?
(y/n)[n]
Linking/db2instance/db2inst8/sqllib/adm/db2uext2to/usr/openv/netbackup/bin/db2uext2.64.
Copying/usr/openv/netbackup/ext/db_ext/db2/scripts/db2.confto/db2instance/db2inst8/db2.conf.
Note:
说明数据库是64位,修改备份脚本MY_LIB
2.3Modifydb2.conf
1/[db2inst8@EB-DB-TEST~]$db2getdbcfgforlifeplan
Firstlogarchivemethod(LOGARCHMETH1)=DISK:
/db2data/db2inst6/alsydb_archivelog/
2/db2.conf
[db2inst8@EB-DB-TEST~]$moredb2.conf
#
#ThefollowingsettingsareusedbyNetBackuptobackup/restoreaDB2database.
#
#Reminders:
#1)Thespecifiedpolicymusthaveatypeof"DB2".
#2)Thespecifiedschedulemustbedefinedforthispolicy.
#3)TheDB2databasehostmustbeenteredasaclientforthispolicy.
#
DATABASELIFEPLAN
OBJECTTYPEDATABASE
POLICYdb2_test
SCHEDULEDefault-Application-Backup
ENDOPER
#
#ThefollowingsettingsareusedbyNetBackuptobackup/restoreDB2logfiles.
#
Reminders:
#1)DB2transcationlogscanbebackedup/restoredusingeither
#(a)DB2UserExitProgram
#Thespecifiedpolicymusthaveatypeof"Standard"(forUNIXDB2
#host)or"MS-Windows-NT"(forWindowsDB2host).
#
#(b)LOGARCHMETH1canbeconfiguredtouseNetBackup.
#(WhenLOGARCHMETH1="VENDOR:
NetBackupforDB2agent")
#Thisoptionispossibleonlyforversions8.2andabove.
#ThespecifiedpolicymusthaveatypeofDB2.
#
#2)Thespecifiedschedulemustbedefinedforthispolicy.
#3)TheDB2databasehostmustbeenteredasaclientforthispolicy.
#
#---------------------
#DB2UserExitProgram
#---------------------
#IfDB2logfilearchivingisenabled(DB2USEREXITON),DB2willinvoke
#theNetBackupuser-exitprogramtobackup&restoreDB2archivelogfiles.
#UsingARCFUNCSAVEcauseslogfilestobearchivedtoNetBackupstorage,
#asspecifiedbythepolicystorage-unitsetting.
#UsingARCFUNCCOPYcauseslogfilestobearchivedtoadiskdirectory.
#UseARCDIRtospecifythedestinationdirectoryforlogfilebackup.
#UseRETDIRtospecifythesourcedirectoryforlogfilerestore.
#
DATABASELIFEPLAN
OBJECTTYPEARCHIVE
POLICYdb2_test_log
SCHEDULEUser
#ARCFUNCSAVE
ARCFUNCCOPY
ARCDIR/db2log/db2inst8/lifeplan/NODE0000
#RETDIR/home/db2inst1/arcdir
ENDOPER
#--------------------------------------------------------------
#LOGARCHMETH1="VENDOR.."parameterforversions8.2andabove
#PolicyisoftypeDB2.
#--------------------------------------------------------------
#
#CommenttheaboveDB2UserExitsectionwhenusingLOGARCHMETH1="VENDOR.."
#
#DATABASESAMPLE
#OBJECTTYPEARCHIVE
#POLICYDB2_ARCH_Policy
#SCHEDULEDefault-Application-Backup
#ENDOPER
[db2inst8@EB-DB-TEST~]$
2.4Modifybackupshell
EB-DB-TEST@/usr/openv/scripts#moredb2_backup_db2inst8.bak
#!
/bin/sh
#bcpyrght
#***************************************************************************
#*$VRTScprght:
Copyright1993-2003VERITASSoftwareCorporation,AllRightsReserved$*
#***************************************************************************
#ecpyrght
#
#TheseenvironmentvariablesareinitializedbyNetbackup(bphdb)
#
echo"DB2_CLIENT=$DB2_CLIENT"
echo"DB2_SERVER=$DB2_SERVER"
echo"DB2_POLICY=$DB2_POLICY"
echo"DB2_SCHED=$DB2_SCHED"
echo"DB2_FULL=$DB2_FULL"#Is1ifFullbackupscheduled
echo"DB2_CINC=$DB2_CINC"#Is1ifCumulativeincrementalscheduled
echo"DB2_INCR=$DB2_INCR"#Is1ifDifferentialincrementalscheduled
#
#ChangeMY_LIBtothecorrectNetBackuplibrarynameforyourhost:
#SolarisorLinux32-bit=nbdb2.so
#Solaris64-bit=nbdb2.so64
#AIXorHPUX32-bit=nbdb2.sl
#AIXorHPUX64-bit=nbdb2.sl64
#
MY_LIB=/usr/openv/netbackup/bin/nbdb2.sl64
#
#ChangeMY_DB2tothecorrectDB2instancenameforyourdatabase.
#
MY_DB2=LIFEPLAN
#
#UsetheNetBackupscheduletypetosetDB2fullorincrementaloptions.
#
if["$DB2_FULL"="1"];then
MY_SCHED=""
elif["$DB2_CINC"="1"];then
MY_SCHED="INCREMENTAL"
elif["$DB2_INCR"="1"];then
MY_SCHED="INCREMENTALDELTA"
else
MY_SCHED=""
fi
#
#Initializethebackupcommandline.
#Customizethenumberofsessionsandbufferoptionsforyourenvironment.
#
CMD_LINE="db2BACKUPDATABASE$MY_DB2ONLINE$MY_SCHEDLOAD$MY_LIBINCLUDELOGS"
#
#ChangeMY_USERtotheproperDB2userforperformingbackups
#
MY_USER=db2inst8
echo"Executing:
$CMD_LINE"
su-$MY_USER-c"$CMD_LINE"
RETURN_STATUS=$?
#Return0forsuccess,non-zeroforerrors
exit$RETURN_STATUS
EB-DB-TEST@/usr/openv/scripts#
3.backup
1/修改LOGRETAINon
[db2inst8@EB-DB-TEST~]$db2updatedbcfgforlifeplanusingLOGRETAINon
DB20000ITheUPDATEDATABASECONFIGURATIONcommandcompletedsuccessfully.
2/离线备份
[db2inst8@EB-DB-TEST~]$db2connecttolifeplan
DatabaseConnectionInformation
Databaseserver=DB2/AIX649.1.2
SQLauthorizationID=DB2INST8
Localdatabasealias=LIFEPLAN
[db2inst8@EB-DB-TEST