《mysql数据库备份恢复实施报告-v1.0》由会员分享，可在线阅读，更多相关《mysql数据库备份恢复实施报告-v1.0（60页珍藏版）》请在金锄头文库上搜索。
1、Veritas Consulting ServicesGreater China* MySQL数据库备份恢复报告21文档信息1.1 版本1.2 相关的文件IdTitleOrganisationAuthorVersion1.3 文档更新记录DateDetailAuthorVersion2018-10-04文档创建汪善平1.0Document Title*-MySQL 数据库备份恢复实施报告.docSubjectVeritas 大中国区顾问服务Version1.0Date2018-10-04Author汪善平FilenameComments32目录1文档信息21.1版本21.2相关的文件 .21.
2、3文档更新记录22目录33文档说明44环境说明55软件安装65.1NBU 客户端软件安装65.2安装 MEB 插件 .96备份配置116.1创建备份脚本116.1.1MySQL 备份说明116.1.2备份脚本.116.2创建备份策略217恢复步骤377.1准备工作.377.2恢复说明.377.3恢复步骤.3743文档说明此文档说明使用 Veritas Netbackup 通过 Oracle MySQL Enterprise Backup 来对 MySQL数据库进行备份恢复的步骤；此文档仅供*使用；54环境说明1)备份系统：主机名IP 地址操作系统角色NBU-PRIMARY1 Red Hat E
3、nterprise Linux Server release 6.1 NBU Master Server 主机NBU-PRIMARY1 Red Hat Enterprise Linux Server release 6.1 NBU Master Server 备机NBUMASTER Red Hat Enterprise Linux Server release 6.1 NBU Master ServerNBU-QUCHONG Red Hat Enterprise Linux Server release 6.1 NBU Media ServerNBU-QUCHONG2 Red Hat Ente
4、rprise Linux Server release 6.1 NBU Media Server2)备份软件：Veritas Netbackup Enterprise Server 7.6.0.43)MySQL 服务器：主机名IP 地址操作系统角色yhzd-db3 Red Hat Enterprise Linux Server release 6.5MySQL 服务器yhzd1 Red Hat Enterprise Linux Server release 6.5MySQL 恢复测试服务器4)MySQL 版本：mysql Ver 14.14 Distrib 5.6.22, for Linux
5、(x86_64) using EditLine wrapper65软件安装5.1 NBU 客户端软件安装1)在 NBU Master Server，Media Server 的/etc/hosts 中添加 MySQL 服务器的主机名解析：#mysql db192.168.232.51 yhzd-db1192.168.232.52 yhzd-db2192.168.232.53 yhzd-db3 yhzd-2)在 MySQL 服务器的/etc/hosts 中添加 NBU Master Server，Media Server 的主机名解析：192.168.238.21 NBU-PRIMARY1192
6、.168.238.22 NBU-PRIMARY2192.168.238.16 NBU-QUCHONG2192.168.238.17 NBU-QUCHONG192.168.238.23 NBUVIP-em1 NBUMASTER3)登陆 NBU Master Server，进行客户端软件推送：rootNBU-PRIMARY1 RedHat2.6.18# ./sftp_to_client yhzd-db3 rootConnecting to 192.168.232.53.root192.168.232.53s password: sftp completed successfully.The roo
7、t user on 192.168.232.53 must now execute the command“sh /tmp/bp.10261/client_config -L“. The optional argument, “-L“,is used to avoid modification of the clients current bp.conf file.rootNBU-PRIMARY1 RedHat2.6.18#74)推送完成后，登陆客户端 yhzd-db3 进行 NBU 客户端软件安装：rootyhzd-db3 tmp# cd bp.10261/rootyhzd-db3 bp.1
8、0261# lsbin_net.tar client_config openvrootyhzd-db3 bp.10261# ./client_config Checking for required system conditions.Checking for recommended system conditions.ok nb_7604_hotfix_auditor: No potential for regression of hotfixes or EEBs was detected.Blocksize = 20 records././bp_servers./bp_client_nam
9、eSaving client binaries for Linux/RedHat2.6.18.Installing PBX.Please wait while installation is in progress.Installation completed SuccessfullyInstallation log located here: /var/tmp/installpbx-1183-052416104325.logUnpacking SYMCnbclt package.Checking for pre-existing SYMCnbclt package.Installing SY
10、MCnbclt package.Installation of SYMCnbclt was successful.More details regarding SYMCnbclt can be found in file/tmp/install_cltpkg_trace.1033 on yhzd-db3.Terminating NetBackup and/or Media Manager processes.Checking network connections.9bp.conf: IP_ADDRESS_FAMILY = AF_INET: default value, no update n
11、eededNo xinetd process found.Installing NB-Java.Unpacking SYMCnbjava package.Checking for pre-existing SYMCnbjava package.Installing SYMCnbjava package.Installation of SYMCnbjava was successful.More details regarding SYMCnbjava can be found in file/tmp/install_javapkg_trace.2272 on yhzd-db3.Unpackin
12、g SYMCnbjre package.Checking for pre-existing SYMCnbjre package.Installing SYMCnbjre package.Installation of SYMCnbjre was successful.More details regarding SYMCnbjre can be found in file/tmp/install_jrepkg_trace.2272 on yhzd-db3.Directory /usr/openv/logs does not exist.No log files to migrate.Check
13、ing for SYMCpddea package.Installing PDDE agent package (/tmp/bp.10261/openv/netbackup/client/Linux/RedHat2.6.18/pddeagent.tar.gz).Extracting package SYMCpddea in /tmp/pdde_pkg_dir_2422.Package SYMCpddea extracted to /tmp/pdde_pkg_dir_2422.Installing package SYMCpddea.Package SYMCpddea installed.PDD
14、E install finished successfully.Version now installed: 8.0004.0014.0917Full PDDE installation log saved to: /var/log/puredisk/2016-05-24_10:48-pdde- install.logThe following automatic startup and shutdown scripts (respectively)have been installed. They will cause the NetBackup daemons to beautomatic
15、ally shut down and restarted each time the system boots.10/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/K01netbackupSuccessfully updated the session cache parameters.Starting vnetd.Starting
16、bpcd.Starting nbftclnt.Starting nbdisco.Starting mtstrmd.Starting bmrbd.Installation of Java LiveUpdate agent succeeded. Refer to file/tmp/JLU-Log/JavaLiveUpdate-Install.log on yhzd-db3for installation details.Checking LiveUpdate registration for the following products: CLT This may take a few minutes.Product CLT is installed and will be registered.Updating LiveUpdate registration now.this may take some time.Client install complete
