Db2备份和恢复.docx

1、Db2备份和恢复Db2 backup and restore1 installEB-DB-TEST/# /software/veritas/NB_60MP4_UOptions_20061204b/installVERITAS Installation ScriptCopyright 1993 - 2005 VERITAS Software Corporation, All Rights Reserved. Installation Options 1 NetBackup Add-On Product Software 2 NetBackup Database Agent Software q

2、To quit from this scriptChoose an option default: q: 2*There are two ways to install database agent software.1. Remote Installation: Loads the software on a server with the intent of pushing database software out to affected clients.2. Local Installation: Loads and installs the software only to this

3、 local machine.*Do you want to do a local installation? y,n (n) y* NetBackup Database Agent InstallationChoose the Database Agents you wish to installone at a time or select Install All Database Agents. 1) NetBackup for DB2 2) NetBackup for Informix 3) NetBackup for Lotus Notes 4) NetBackup for Orac

4、le 5) NetBackup for SAP 6) NetBackup for Sybase 7) Install All Database Agents q) Done Selecting Agents x) Exit from this ScriptChoose an option: 1Choose an option: qYou have chosen to install these Database Agents: NetBackup for DB2Is this list correct? y,n (y) *Of the agents selected, the followin

5、g are supportedon this platform and will be installed: DB2Loading the Database Agent packages into the/usr/openv/netbackup/dbext directory and installing.* Installing NetBackup for DB2 Installing NetBackup for DB2.Extracting files from /usr/openv/netbackup/dbext/DB2.rs6000_51.tar.Z .x usr/openv/netb

6、ackupx usr/openv/netbackup/binx usr/openv/netbackup/bin/bpubsdb2, 144645 bytes, 283 tape blocksx usr/openv/netbackup/bin/bpdbsbdb2, 1281112 bytes, 2503 tape blocksx usr/openv/netbackup/bin/bpdb2proxy, 1266244 bytes, 2474 tape blocksx usr/openv/netbackup/bin/db2_config, 7072 bytes, 14 tape blocksx us

7、r/openv/netbackup/bin/nbdb2.sl, 99193 bytes, 194 tape blocksx usr/openv/netbackup/bin/db2uext2, 99770 bytes, 195 tape blocksx usr/openv/netbackup/bin/nbdb2.sl64, 108131 bytes, 212 tape blocksx usr/openv/netbackup/bin/db2uext2.64, 108276 bytes, 212 tape blocksx usr/openv/netbackup/bin/db2rhf, 68380 b

8、ytes, 134 tape blocksx usr/openv/netbackup/bin/db2rhf.64, 75127 bytes, 147 tape blocksx usr/openv/netbackup/extx usr/openv/netbackup/ext/db_extx usr/openv/netbackup/ext/db_ext/db2x usr/openv/netbackup/ext/db_ext/db2/scriptsx usr/openv/netbackup/ext/db_ext/db2/scripts/db2.conf, 2227 bytes, 5 tape blo

9、cksx usr/openv/netbackup/ext/db_ext/db2/scripts/db2_backup, 1736 bytes, 4 tape blocksx usr/openv/netbackup/ext/db_ext/db2/scripts/db2_restore, 1245 bytes, 3 tape blocksx usr/openv/netbackup/ext/db_ext/db2/scripts/db2_all_backup_mpp, 5269 bytes, 11 tape blocksx usr/openv/netbackup/ext/db_ext/db2/scri

10、pts/db2_all_restore_mpp, 5383 bytes, 11 tape blocksx usr/openv/netbackup/dbextx usr/openv/netbackup/dbext/DB2.rs6000_51.version, 26 bytes, 1 tape blocksx usr/openv/libx usr/openv/lib/libdbsbdb2.so, 1898359 bytes, 3708 tape blocksx usr/openv/lib/libnbbedb2.so, 175382 bytes, 343 tape blocksx usr/openv

11、/lib/libnbbedb2MT.so, 172370 bytes, 337 tape blocksNetBackup for DB2 installation completed.*Execution of ./install_dbext is complete.Execution of ./install is complete.File /usr/openv/tmp/install_options_trace.811250 contains a trace of this install.VERITAS Installation ScriptCopyright 1993 - 2005

12、VERITAS Software Corporation, All Rights Reserved. Installation Options 1 NetBackup Add-On Product Software 2 NetBackup Database Agent Software q To quit from this scriptChoose an option default: q: qFile /usr/openv/tmp/install_options_trace.811250 contains a trace of this install.That file can be d

13、eleted after you are sure the install was successful.EB-DB-TEST/#2 configuration2.1 get dbnamedb2inst8EB-DB-TEST db2dump$db2 list db DIRECTORY System Database Directory Number of entries in the directory = 1Database 1 entry: Database alias = LIFEPLAN Database name = LIFEPLAN Local database directory

14、 = /db2data/db2inst8/lifeplan Database release level = b.00 Comment = LIFEPLAN database Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number =db2inst8EB-DB-TEST $db2 list applicationsAuth Id Application Appl. Application Id DB

15、 # of Name Handle Name Agents- - - - - -DB2INST8 db2taskd 10 *LOCAL.DB2.080721060622 LIFEPLAN 1 DB2INST8 db2stmm 9 *LOCAL.DB2.080721060621 LIFEPLAN 1 DB2INST8 db2bp 8 *LOCAL.db2inst8.080721060617 LIFEPLAN 1 2.2 db2_configEB-DB-TEST/usr/openv/netbackup/bin# ./db2_configPlease specify the DB2 instance

16、 home path name:/db2instance/db2inst8Do you have other DB2 instances? (y/n) n Linking /db2instance/db2inst8/sqllib/adm/db2uext2 to /usr/openv/netbackup/bin/db2uext2.64.Copying /usr/openv/netbackup/ext/db_ext/db2/scripts/db2.conf to /db2instance/db2inst8/db2.conf.Note: 说明数据库是64位，修改备份脚本MY_LIB2.3 Modif

17、y db2.conf1/ db2inst8EB-DB-TEST $db2 get db cfg for lifeplanFirst log archive method (LOGARCHMETH1) = DISK:/db2data/db2inst6/alsydb_archivelog/2/ db2.conf db2inst8EB-DB-TEST $more db2.conf # The following settings are used by NetBackup to backup/restore a DB2 database.# Reminders:# 1) The specified

18、policy must have a type of DB2.# 2) The specified schedule must be defined for this policy.# 3) The DB2 database host must be entered as a client for this policy.#DATABASE LIFEPLANOBJECTTYPE DATABASEPOLICY db2_test SCHEDULE Default-Application-BackupENDOPER# The following settings are used by NetBac

19、kup to backup/restore DB2 log files.# Reminders:# 1) DB2 transcation logs can be backed up/restored using either # (a) DB2 User Exit Program# The specified policy must have a type of Standard (for UNIX DB2 # host) or MS-Windows-NT (for Windows DB2 host).# (b) LOGARCHMETH1 can be configured to use Ne

20、tBackup.# (When LOGARCHMETH1 = VENDOR:NetBackup for DB2 agent)# This option is possible only for versions 8.2 and above.# The specified policy must have a type of DB2.# 2) The specified schedule must be defined for this policy.# 3) The DB2 database host must be entered as a client for this policy.#

21、-# DB2 User Exit Program# -# If DB2 log file archiving is enabled (DB2 USEREXIT ON), DB2 will invoke# the NetBackup user-exit program to backup & restore DB2 archive log files.# Using ARCFUNC SAVE causes log files to be archived to NetBackup storage,# as specified by the policy storage-unit setting.

22、# Using ARCFUNC COPY causes log files to be archived to a disk directory.# Use ARCDIR to specify the destination directory for log file backup.# Use RETDIR to specify the source directory for log file restore.#DATABASE LIFEPLANOBJECTTYPE ARCHIVEPOLICY db2_test_logSCHEDULE User#ARCFUNC SAVEARCFUNC CO

23、PYARCDIR /db2log/db2inst8/lifeplan/NODE0000#RETDIR /home/db2inst1/arcdirENDOPER# -# LOGARCHMETH1 = VENDOR. parameter for versions 8.2 and above# Policy is of type DB2.# -# Comment the above DB2 User Exit section when using LOGARCHMETH1 = VENDOR.# #DATABASE SAMPLE#OBJECTTYPE ARCHIVE#POLICY DB2_ARCH_P

24、olicy#SCHEDULE Default-Application-Backup#ENDOPERdb2inst8EB-DB-TEST $2.4 Modify backup shellEB-DB-TEST/usr/openv/scripts# more db2_backup_db2inst8.bak#!/bin/sh#bcpyrght#*#* $VRTScprght: Copyright 1993 - 2003 VERITAS Software Corporation, All Rights Reserved $ *#*#ecpyrght# These environment variable

25、s are initialized by Netbackup (bphdb)#echo DB2_CLIENT = $DB2_CLIENTecho DB2_SERVER = $DB2_SERVERecho DB2_POLICY = $DB2_POLICYecho DB2_SCHED = $DB2_SCHEDecho DB2_FULL = $DB2_FULL # Is 1 if Full backup scheduledecho DB2_CINC = $DB2_CINC # Is 1 if Cumulative incremental scheduledecho DB2_INCR = $DB2_I

26、NCR # Is 1 if Differential incremental scheduled# Change MY_LIB to the correct NetBackup library name for your host:# Solaris or Linux 32-bit = nbdb2.so# Solaris 64-bit = nbdb2.so64# AIX or HPUX 32-bit = nbdb2.sl# AIX or HPUX 64-bit = nbdb2.sl64#MY_LIB=/usr/openv/netbackup/bin/nbdb2.sl64# Change MY_

27、DB2 to the correct DB2 instance name for your database.#MY_DB2=LIFEPLAN# Use the NetBackup schedule type to set DB2 full or incremental options.#if $DB2_FULL = 1 ; then MY_SCHED=elif $DB2_CINC = 1 ; then MY_SCHED=INCREMENTALelif $DB2_INCR = 1 ; then MY_SCHED=INCREMENTAL DELTAelse MY_SCHED=fi# Initia

28、lize the backup command line.# Customize the number of sessions and buffer options for your environment.#CMD_LINE=db2 BACKUP DATABASE $MY_DB2 ONLINE $MY_SCHED LOAD $MY_LIB INCLUDE LOGS# Change MY_USER to the proper DB2 user for performing backups#MY_USER=db2inst8echo Executing: $CMD_LINEsu - $MY_USE

29、R -c $CMD_LINERETURN_STATUS=$?# Return 0 for success, non-zero for errorsexit $RETURN_STATUSEB-DB-TEST/usr/openv/scripts# 3. backup1/ 修改LOGRETAIN ondb2inst8EB-DB-TEST $db2 update db cfg for lifeplan using LOGRETAIN onDB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.2/ 离线备份db2inst8EB-DB-TEST $db2 connect to lifeplan Database Connection Information Database server = DB2/AIX64 9.1.2 SQL authorization ID = DB2INST8 Local database alias = LIFEPLANdb2inst8EB-DB-TEST