..0TIME\@"yyyy-MM-dd"2018-11-20汪善平相關的文件文檔更新記錄TIME\@"yyyy-MM-dd"2018-11-20文檔創建汪善平1.0目錄TOC\o"1-3"\h\z1文檔信息21.1版本21.2相關的文件21.3文檔更新記錄22目錄33文檔說明44環境說明55軟件安裝65.1NBU客戶端軟件安裝65.2安裝MEB插件96備份配置116.1創建備份腳本11MySQL備份說明11備份腳本116.2創建備份策略217恢復步驟377.1準備工作377.2恢復說明377.3恢復步驟37文檔說明此文檔說明使用VeritasNetbackup通過OracleMySQLEnterpriseBackup來對MySQL數據庫進行備份恢復的步驟；此文檔僅供******使用；環境說明備份系統：主機名IP地址操作系統角色NBU-PRIMARY1RedHatEnterpriseLinuxServerrelease6.1NBUMasterServer主機NBU-PRIMARY1RedHatEnterpriseLinuxServerrelease6.1NBUMasterServer備機NBUMASTERRedHatEnterpriseLinuxServerrelease6.1NBUMasterServerNBU-QUCHONGRedHatEnterpriseLinuxServerrelease6.1NBUMediaServerNBU-QUCHONG2RedHatEnterpriseLinuxServerrelease6.1NBUMediaServer備份軟件：VeritasNetbackupEnterpriseServerMySQL服務器：主機名IP地址操作系統角色yhzd-db3RedHatEnterpriseLinuxServerrelease6.5MySQL服務器yhzd1RedHatEnterpriseLinuxServerrelease6.5MySQL恢復測試服務器MySQL版本：mysqlVer14.14Distrib5.6.22,forLinux<x86_64>usingEditLinewrapper軟件安裝NBU客戶端軟件安裝在NBUMasterServer,MediaServer的/etc/hosts中添加MySQL服務器的主機名解析：#mysqldb1yhzd-db1.52yhzd-db2在MySQL服務器的/etc/hosts中添加NBUMasterServer,MediaServer的主機名解析：1NBU-PRIMARY12NBU-PRIMARY26NBU-QUCHONG27NBU-QUCHONG3NBUVIP-em1NBUMASTER登陸NBUMasterServer,進行客戶端軟件推送：[root@NBU-PRIMARY1RedHat2.6.18]#./sftp_to_clientyhzd-db3rootConnectingto3...root@3'spassword:sftpcompletedsuccessfully.Therootuseron3mustnowexecutethecommand"sh/tmp/bp.10261/client_config[-L]".Theoptionalargument,"-L",isusedtoavoidmodificationoftheclient'scurrentbp.conffile.[root@NBU-PRIMARY1RedHat2.6.18]#推送完成后,登陸客戶端yhzd-db3進行NBU客戶端軟件安裝：root@yhzd-db3tmp]#cdbp.10261/[root@yhzd-db3bp.10261]#lsbin_net.tarclient_configopenv[root@yhzd-db3bp.10261]#./client_configCheckingforrequiredsystemconditions...Checkingforrecommendedsystemconditions...oknb_7604_hotfix_auditor:NopotentialforregressionofhotfixesorEEBswasdetected.Blocksize=20records././bp_servers./bp_client_nameSavingclientbinariesforLinux/RedHat2.6.18.InstallingPBX...Pleasewaitwhileinstallationisinprogress...InstallationcompletedSuccessfullyInstallationloglocatedhere:/var/tmp/installpbx-1183-052416104325.logUnpackingSYMCnbcltpackage.Checkingforpre-existingSYMCnbcltpackage.InstallingSYMCnbcltpackage.InstallationofSYMCnbcltwassuccessful.MoredetailsregardingSYMCnbcltcanbefoundinfile/tmp/install_cltpkg_trace.1033onyhzd-db3.TerminatingNetBackupand/orMediaManagerprocesses.Checkingnetworkconnections.bp.conf:IP_ADDRESS_FAMILY=AF_INET:defaultvalue,noupdateneededNo[x]inetdprocessfound.InstallingNB-Java.UnpackingSYMCnbjavapackage.Checkingforpre-existingSYMCnbjavapackage.InstallingSYMCnbjavapackage.InstallationofSYMCnbjavawassuccessful.MoredetailsregardingSYMCnbjavacanbefoundinfile/tmp/install_javapkg_trace.2272onyhzd-db3.UnpackingSYMCnbjrepackage.Checkingforpre-existingSYMCnbjrepackage.InstallingSYMCnbjrepackage.InstallationofSYMCnbjrewassuccessful.MoredetailsregardingSYMCnbjrecanbefoundinfile/tmp/install_jrepkg_trace.2272onyhzd-db3.Directory/usr/openv/logsdoesnotexist.Nologfilestomigrate.CheckingforSYMCpddeapackage...InstallingPDDEagentpackage</tmp/bp.10261/openv/netbackup/client/Linux/RedHat2.6.18/pddeagent.tar.gz>...ExtractingpackageSYMCpddeain/tmp/pdde_pkg_dir_2422.PackageSYMCpddeaextractedto/tmp/pdde_pkg_dir_2422.InstallingpackageSYMCpddea.PackageSYMCpddeainstalled.PDDEinstallfinishedsuccessfully.FullPDDEinstallationlogsavedto:/var/log/puredisk/2016-05-24_10:48-pdde-install.logThefollowingautomaticstartupandshutdownscripts<respectively>havebeeninstalled.TheywillcausetheNetBackupdaemonstobeautomaticallyshutdownandrestartedeachtimethesystemboots./etc/rc.d/rc2.d/S77netbackup/etc/rc.d/rc3.d/S77netbackup/etc/rc.d/rc5.d/S77netbackup/etc/rc.d/rc0.d/K01netbackup/etc/rc.d/rc1.d/K01netbackup/etc/rc.d/rc6.d/K01netbackupSuccessfullyupdatedthesessioncacheparameters.Startingvnetd...Startingbpcd...Startingnbftclnt...Startingnbdisco...Startingmtstrmd...Startingbmrbd...InstallationofJavaLiveUpdateagentsucceeded.Refertofile/tmp/JLU-Log/JavaLiveUpdate-Install.logonyhzd-db3forinstallationdetails.CheckingLiveUpdateregistrationforthefollowingproducts:CLTThismaytakeafewminutes.ProductCLTisinstalledandwillberegistered.UpdatingLiveUpdateregistrationnow...thismaytakesometime.Clientinstallcomplete.等待客戶端軟件安裝完成；安裝MEB插件Netbackup通過Oracle提供的MEB〔MySQLEnterpriseBackup對MySQL數據庫進行備份,在MySQL服務器上需要安裝MEB插件；下載MEB插件并上傳到MySQL服務器上；安裝MEB插件：[root@yhzd-db3tmp]#rpm-ivhmeb-3.12.2-el6.x86_64.rpmwarning:meb-3.12.2-el6.x86_64.rpm:HeaderV3DSA/SHA1Signature,keyID5072e1f5:NOKEYPreparing...###########################################[100%]1:meb###########################################[100%][root@yhzd-db3tmp]#rpm-qa|grep-imeb備份配置創建備份腳本MySQL備份說明使用MEB備份MySQL數據庫分為全備份和增量備份；全備份是一份完整的備份數據；增量備份通過參數：--incremental-base來控制此次增量備份依據什么時候的數據來進行：history:backup,依據上一次成功的備份中的lsndir:<backupdir>,依據上一次成功備份的目錄中的metadata文件中的lsn在這里我們通過dir:<fullbackupdir>來實現每次增量備份都使用上一次成功的全備份中的metadata文件的lsn進行增量,從而達到累計增量備份的效果；增量備份參數：--incremental-with-redo-log-only此參數使得增量備份時通過MySQL的redolog來判斷此次增量部分數據；由于redo要求log是循環使用的,因此使用此參數要求redolog的大小必須能容納上次備份到此次備份之間的數據變化；備份腳本在MySQL服務器上創建以下目錄：#mkdir-p/usr/openv/scripts/#mkdir-p/usr/openv/scripts/logs/創建全備份腳本：#!/bin/sh#Copyright:##mysqlbackupexecutablefilepathMYSQLBACKUP=/opt/mysql/meb-3.12/bin/mysqlbackup#theMysqlportPort=3306#theMysqlprotocolProtocol=tcp#theMysqlusernameandpasswordusedforbackupUSER=temsbackuppassword=backuptems#NetbackupMasterServerNB_ORA_SERV=NBUMASTER#MySqlDBServerNB_ORA_CLIENT=yhzd-db3#NetBackupMySQLDatabaseBackupPolicyNameNB_ORA_POLICY=yhzddb3_mysql_fullFile_Backup=yhzddb3_mysql_metadataCMD=/usr/openv/netbackup/bin/bpbackup#thetemporarydirectoryusedbymysqlbackupbackup_dir_home=/usr/openv/scripts/metadatafull_bkp_home=$backup_dir_home/fullincr_bkp_home=$backup_dir_home/incrBkpType="Full"#BkpStatus=0#LogDir=/usr/openv/scripts/logs#initialize<>{CURDATE=`date+%Y%m%d_%H%M%S`dLIB=/usr/openv/netbackup/bin/libobk.so64dBACKUPIMAGENAME=sbt:bkNB$BkpType$CURDATEdOUTLOG=$LogDir/$NB_ORA_POLICY-$CURDATE.logdERRORLOG=$LogDir/$NB_ORA_POLICY-$CURDATE-error.logdCLEANUP=0 mkdir-p$LogDir#mkdir-p$backup_dir_home}cleanup<>{CURDATE=`date+%Y%m%d_%H%M%S`echo>>$dOUTLOGecho"">>$dOUTLOGif[$BkpStatus-ne0];thenecho"MYSQLBACKUPFAILEDat$CURDATE,PLEASECHECK">>$dOUTLOG#rm-rf$backup_dir_home/*elseecho"MYSQLBackupSuccessfulat$CURDATE">>$dOUTLOGfiecho"">>$dOUTLOGecho>>$dOUTLOG}do_fullbackup<>{ rm-rf$full_bkp_home mkdir-p$full_bkp_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"StartFullBackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=*******--backup-dir=$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-image=$dBACKUPIMAGENAMEbackup-to-image">>$dOUTLOG$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=$password--backup-dir=$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-image=$dBACKUPIMAGENAMEbackup-to-image2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndFullBackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGcat$dOUTLOG|grep"mysqlbackupcompletedOK"|grep-vprintBkpStatus=$?}do_conf_backup<>{if[$BkpStatus-eq0];thenecho>>$dOUTLOGecho"">>$dOUTLOGecho"BackupMetadatafilesat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"TheMetadatafilesare:">>$dOUTLOGls-lR$backup_dir_home>>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$CMD-p$File_Backup$backup_dir_home">>$dOUTLOG$CMD-p$File_Backup$backup_dir_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndMetadatafilesbackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGfi}do_validate<>{echo>>$dOUTLOGecho"">>$dOUTLOGecho"StartValidateat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--backup-image=$dBACKUPIMAGENAME--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"validate">>$dOUTLOG$MYSQLBACKUP--backup-image=$dBACKUPIMAGENAME--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"validate2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndValidateat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOG}do_incremental_with_redo_log_only<>{rm-rf$incr_bkp_homemkdir-p$incr_bkp_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"Startredologonlyat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=password--incremental-with-redo-log-only--incremental-base=history:last_backup--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image">>$dOUTLOG$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=$password--incremental-with-redo-log-only--incremental-base=history:last_backup--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"Endredologonlyat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGcat$dOUTLOG|grep"mysqlbackupcompletedOK"|grep-vprintBkpStatus=$?}do_incremental_backup<>{rm-rf$incr_bkp_homemkdir-p$incr_bkp_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"Startincrementalbackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=******--incremental--incremental-base=dir:$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image">>$dOUTLOG$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=$password--incremental--incremental-base=dir:$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndIncrementalBackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGcat$dOUTLOG|grep"mysqlbackupcompletedOK"|grep-vprintBkpStatus=$?}initializedo_fullbackup#do_incremental_with_redo_log_onlydo_conf_backup#do_validate#cleanupexit$BkpStatus創建增量備份腳本：#!/bin/sh#Copyright:##mysqlbackupexecutablefilepathMYSQLBACKUP=/opt/mysql/meb-3.12/bin/mysqlbackup#theMysqlportPort=3306#theMysqlprotocolProtocol=tcp#theMysqlusernameandpasswordusedforbackupUSER=temsbackuppassword=backuptems#NetbackupMasterServerNB_ORA_SERV=NBUMASTER#MySqlDBServerNB_ORA_CLIENT=yhzd-db3#NetBackupMySQLDatabaseBackupPolicyNameNB_ORA_POLICY=yhzddb3_mysql_incrFile_Backup=yhzddb3_mysql_metadataCMD=/usr/openv/netbackup/bin/bpbackup#thetemporarydirectoryusedbymysqlbackupbackup_dir_home=/usr/openv/scripts/metadatafull_bkp_home=$backup_dir_home/fullincr_bkp_home=$backup_dir_home/incrBkpType="Incr"#BkpStatus=0#LogDir=/usr/openv/scripts/logs#initialize<>{CURDATE=`date+%Y%m%d_%H%M%S`dLIB=/usr/openv/netbackup/bin/libobk.so64dBACKUPIMAGENAME=sbt:bkNB$BkpType$CURDATEdOUTLOG=$LogDir/$NB_ORA_POLICY-$CURDATE.logdERRORLOG=$LogDir/$NB_ORA_POLICY-$CURDATE-error.logdCLEANUP=0 mkdir-p$LogDir#mkdir-p$backup_dir_home}cleanup<>{CURDATE=`date+%Y%m%d_%H%M%S`echo>>$dOUTLOGecho"">>$dOUTLOGif[$BkpStatus-ne0];thenecho"MYSQLBACKUPFAILEDat$CURDATE,PLEASECHECK">>$dOUTLOG#rm-rf$backup_dir_home/*elseecho"MYSQLBackupSuccessfulat$CURDATE">>$dOUTLOGfiecho"">>$dOUTLOGecho>>$dOUTLOG}do_fullbackup<>{ rm-rf$full_bkp_home mkdir-p$full_bkp_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"StartFullBackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=*******--backup-dir=$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-image=$dBACKUPIMAGENAMEbackup-to-image">>$dOUTLOG$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=$password--backup-dir=$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-image=$dBACKUPIMAGENAMEbackup-to-image2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndFullBackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGcat$dOUTLOG|grep"mysqlbackupcompletedOK"|grep-vprintBkpStatus=$?}do_conf_backup<>{if[$BkpStatus-eq0];thenecho>>$dOUTLOGecho"">>$dOUTLOGecho"BackupMetadatafilesat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"TheMetadatafilesare:">>$dOUTLOGls-lR$backup_dir_home>>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$CMD-p$File_Backup$backup_dir_home">>$dOUTLOG$CMD-p$File_Backup$backup_dir_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndMetadatafilesbackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGfi}do_validate<>{echo>>$dOUTLOGecho"">>$dOUTLOGecho"StartValidateat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--backup-image=$dBACKUPIMAGENAME--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"validate">>$dOUTLOG$MYSQLBACKUP--backup-image=$dBACKUPIMAGENAME--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"validate2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndValidateat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOG}do_incremental_with_redo_log_only<>{ rm-rf$incr_bkp_home mkdir-p$incr_bkp_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"Startredologonlyat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOGecho"$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=password--incremental-with-redo-log-only--incremental-base=history:last_backup--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image">>$dOUTLOG$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=$password--incremental-with-redo-log-only--incremental-base=history:last_backup--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"Endredologonlyat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGcat$dOUTLOG|grep"mysqlbackupcompletedOK"|grep-vprintBkpStatus=$?}do_incremental_backup<>{ rm-rf$incr_bkp_home mkdir-p$incr_bkp_homeecho>>$dOUTLOGecho"">>$dOUTLOGecho"Startincrementalbackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGecho"Executecommand:">>$dOUTLOG echo"$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=******--incremental--incremental-base=dir:$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image">>$dOUTLOG$MYSQLBACKUP--port=$Port--protocol=$Protocol--user=$USER--password=$password--incremental--incremental-base=dir:$full_bkp_home--sbt-lib-path=$dLIB--sbt-environment="NB_ORA_SERV=$NB_ORA_SERV,NB_ORA_CLIENT=$NB_ORA_CLIENT,NB_ORA_POLICY=$NB_ORA_POLICY"--backup-dir=$incr_bkp_home--backup-image=$dBACKUPIMAGENAMEbackup-to-image2>>$dOUTLOGecho>>$dOUTLOGecho"">>$dOUTLOGecho"EndIncrementalBackupat$CURDATE">>$dOUTLOGecho"">>$dOUTLOGecho>>$dOUTLOGcat$dOUTLOG|grep"mysqlbackupcompletedOK"|grep-vprintBkpStatus=$?}initialize#do_fullbackup#do_incremental_with_redo_log_onlydo_incremental_backupdo_conf_backup#do_validate#cleanupexit$BkpStatus創建備份策略在NetbackupAdminConsole中新建一個全備份備份策略：PolicyType：Oracle為這個Policy添加Schedule：Type： FullBackupRetention：6MonthsFrequency：每周五添加客戶端：添加備份腳本：以同樣的步驟添加每月1號的全備：以同樣的步驟創建增量備份策略：單獨創建一個userbackup類型的備份策略,用戶備份期間產生的metadata配置文件：恢復步驟準備工作在恢復測試機上安裝好Netbackup客戶端軟件,MEB軟件；恢復測試機操作系統版本、MySQL版本和原備份機保持一致；由于MySQL恢復是先將備份集從Netbackup存儲單元中恢復到MySQL服務器的存儲上,然后應用日志,然后copy到MySQL的數據目錄中,所以要求MySQL服務器上除了有存儲空間用于存放MySQL數據外,還需要同樣的空間用于存放恢復數據。建議將恢復測試機的主機名修改為和原備份主機名一致；恢復說明MySQL數據庫的恢復步驟為：先將全備份、增量備份從Netbackup存儲單元中恢復到MySQL服務器文件系統的不同目錄中；此目錄不是MySQL的數據目錄；將日志合并應用到全備份中；將增量備份合并應用到全備份中；關閉測試機上的MySQL數據庫；將全備份恢復到MySQL數據目錄；使用f啟動MySQL數據庫,進行驗證；恢復步驟登陸恢復測試機,查看已經備份的MySQL備份集：[root@yhzd1netbackup]#/usr/openv/netbackup/bin/bplist-Cyhzd-db3-t4-R//bkpsbtNBRedo20160525_195254/bkpsbtNB20160525_185254/bkpsbtNBRedo20160524_195251/bkpsbtNBRedo20160524_153831/bkpsbtNB20160524_151955/bkpsbtNB20160524_145230/bkpsbtNB20160524_131604確定需要從哪個備份集中恢復,例如：bkpsbtNB20160525_185254；運行以下命令,將備份集恢復到MySQL服務器上：[root@yhzd1bin]#./mysqlbackup--sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64--sbt-environment="NB_ORA_SERV=NBUMASTER,NB_ORA_CLIENT=yhzd-db3"--backup-dir=/data/backup/20160526/--backup-image=sbt:bkpsbtNB20160525_185254image-to-backup-dir輸出如下：MySQLEnterpriseBackupversion3.12.2Linux-3.8.13-16.2.1.el6uek.x86_64-x86_64[2016/01/19]Copyright<c>2003,2016,Oracleand/oritsaffiliates.AllRightsReserved.mysqlbackup:INFO:Startingwithfollowingcommandline..../mysqlbackup--sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64--sbt-environment=NB_ORA_SERV=NBUMASTER,NB_ORA_CLIENT=yhzd-db3--backup-dir=/data/backup/20160526/--backup-image=sbt:bkpsbtNB20160525_185254image-to-backup-dirmysqlbackup:INFO:mysqlbackup:INFO:sbt-environment:'NB_ORA_SERV=NBUMASTER,NB_ORA_CLIENT=yhzd-db3'IMPORTANT:Pleasecheckthatmysqlbackupruncompletessuccessfully.Attheendofasuccessful'image-to-backup-dir'runmysqlbackupprints"mysqlbackupcompletedOK!".16052611:02:35mysqlbackup:INFO:meb_sbt_session_open:MMSversion''16052611:02:35mysqlbackup:INFO:meb_sbt_session_open:MMSis'VeritasNetBackupforOracle-Release7.6<2014102419>'mysqlbackup:INFO:BackupImageMEBversionstring:3.12.2[2016/01/19]mysqlbackup:INFO:Creating14bufferseachofsize16777216.16052611:03:17mysqlbackup:INFO:Imagetobackup-diroperationstartswithfollowingthreads1read-threads6process-threads1write-threads16052611:03:17mysqlbackup:INFO:Extract:[Dir]:/data/backup/20160526/meta16052611:03:17mysqlbackup:INFO:Copyingdatadir/ibdata1.mysqlbackup:ProgressinMB:20040060080010001200140016001800200016052611:06:21mysqlbackup:INFO:Copyingdatadir/mysql/innodb_index_stats.ibd.16052611:06:21mysqlbackup:INFO:Copyingdatadir/mysql/innodb_table_stats.ibd.16052611:06:21mysqlbackup:INFO:Copyingdatadir/mysql/slave_master_info.ibd.16052611:06:21mysqlbackup:INFO:Extract:[Dir]:/data/backup/20160526/datadir/mysql16052611:06:21mysqlbackup:INFO:Copyingdatadir/mysql/slave_relay_log_info.ibd.16052611:06:21mysqlbackup:INFO:Copyingdatadir/mysql/slave_worker_info.ibd.16052611:06:21mysqlbackup:INFO:Extract:[Dir]:/data/backup/20160526/datadir/performance_schema16052611:06:21mysqlbackup:INFO:Extract:[Dir]:/data/backup/20160526/datadir/tems16052611:06:21mysqlbackup:INFO:Copyingdatadir/tems/boss_to_tems_itr_log.ibd.mysqlbackup:ProgressinMB:2200240026002800300016052611:07:51mysqlbackup:INFO:Copyingdatadir/tems/device_mac.ibd.mysqlbackup:ProgressinMB:320034003600380016052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_auth.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_auth_copy.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_auth_oper.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_config.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_datadic_group.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_datadic_item.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_datadic_item_copy.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_department.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_notice.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_notify.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_notify_template.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_role.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_role_auth_join.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_role_ugroup_join.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_ugroup_auth_join.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_user.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_user_auth_join.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_user_department.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_user_group.ibd.16052611:09:13mysqlbackup:INFO:Copyingdatadir/tems/sys_user_log.ibd.16052611:09:15mysqlbackup:INFO:Copyingdatadir/tems/sys_user_role_join.ibd.mysqlbackup:ProgressinMB:400016052611:09:15mysqlbackup:INFO:Copyingdatadir/tems/sys_user_ugroup_join.ibd.16052611:09:15mysqlbackup:INFO:Copyingdatadir/tems/sys_variable.ibd.16052611:09:15mysqlbackup:INFO:Copyingdatadir/tems/tems_balance_file.ibd.16052611:09:15mysqlbackup:INFO:Copyingdatadir/tems/tems_balance_operdate.ibd.16052611:09:15mysqlbackup:INFO:Copyingdatadir/tems/tems_balance_stock.ibd.16052611:09:17mysqlbackup:INFO:Copyingdatadir/tems/tems_balance_transceivers.ibd.16052611:09:17mysqlbackup:INFO:Copyingdatadir/tems/tems_device_base#P#p0.ibd.mysqlbackup:ProgressinMB:4200440016052611:10:00mysqlbackup:INFO:Copyingdatadir/tems/tems_device_base#P#p1.ibd.16052611:10:05mysqlbackup:INFO:Copyingdatadir/tems/tems_device_base#P#p2.ibd.mysqlbackup:ProgressinMB:4600480016052611:10:33mysqlbackup:INFO:Copyingdatadir/tems/tems_device_base#P#p3.ibd.mysqlbackup:ProgressinMB:500052005400560016052611:11:40mysqlbackup:INFO:Copyingdatadir/tems/tems_device_base#P#p4.ibd.mysqlbackup:ProgressinMB:5800600062006400660068007000720074007600780080008200840086008800900092009400960016052611:17:46mysqlbackup:INFO:Copyingdatadir/tems/tems_device_base#P#p5.ibd.mysqlbackup:ProgressinMB:980016052611:18:02mysqlbackup:INFO:Copyingdatadir/tems/tems_device_batch_detail.ibd.16052611:18:03mysqlbackup:INFO:Copyingdatadir/tems/tems_device_batch_query.ibd.16052611:18:03mysqlbackup:INFO:Copyingdatadir/tems/tems_device_boss_temp.ibd.16052611:18:04mysqlbackup:INFO:Copyingdatadir/tems/tems_device_cm#P#p0.ibd.mysqlbackup:ProgressinMB:1000016052611:18:25