Posts tagged ‘netbackup’

NBU备份时出现NBU Status 800错误,提示Disk volume is down

NBU服务器(for win2003_x32)备份Redhat服务器的本地文件时出现了NBU Status 800错误,提示Disk volume is down,错误如下:

2014-7-11 22:10:53 – requesting resource backup
2014-7-11 22:10:53 – requesting resource fds-48bf70868bb.NBU_CLIENT.MAXJOBS.oracle1
2014-7-11 22:10:53 – requesting resource fds-48bf70868bb.NBU_POLICY.MAXJOBS.filebackup
2014-7-11 22:10:53 – Error nbjm(pid=1640) NBU status: 800, EMM status: Disk volume is down   
resource request failed(800)

截图如下:

nbuerr01

因为备份目标卷使用的本地磁盘的空间,在系统盘C盘根目录下新建目录backup,查找原因后发现,就是因为把备份目录放在了系统盘上,所以会出现上面的错误,进入 NetBackup Management->Storage->Storage Units,点右键新建目录,如下图,点击Browse选择好备份目录后,下面有个选项:This directory can exist on the root file system or system disk。意思为备份目录可以存在于根目录或者系统磁盘上。

nbuerr02

将上图中的选项钩打上,再次备份,就可以顺利备份了。

nbuerr03

Symantec NetBackup6.5在win下的常用命令

写下WIN下常用的NETBACKUP6.5命令:

1、默认安装位置:C:Program FilesVERITASNetBackup

2、启动及停止netbackup

(1)停止

C:Program FilesVERITASNetBackupbin>bpdown

NetBackup 6.5 — Shutdown Utility

NetBackup software will be shutdown.  This may cause backups to fail.
Do you wish to proceed? (y/n) y
Shutting down services
Calling nbproxyreq to cleanup nbproxy processes.

Shutdown completed successfully.

(2)启动

C:Program FilesVERITASNetBackupbin>bpup

NetBackup 6.5 — Startup Utility

NetBackup services are about to be started.
Do you wish to proceed? (y/n) y
Starting services

Start up completed successfully.

3、列出可用磁带信息

C:Program FilesVERITASNetBackupbingoodies>available_media.cmd

media   media   robot   robot   robot   side/   ret    size     status
ID     type    type      #     slot    face    level  KBytes
—————————————————————————-
CatalogBackup pool

DataStore pool

NetBackup pool

0401L3  HCART3   TLD      0       2      –       –     –        AVAILABLE
0402L3  HCART3   TLD      0       3      –       –     –        AVAILABLE
0403L3  HCART3   TLD      0       4      –       –     –        AVAILABLE
0404L3  HCART3   TLD      0       5      –       –     –        AVAILABLE
0405L3  HCART3   TLD      0       6      –       –     –        AVAILABLE
0406L3  HCART3   TLD      0       7      –       –     –        AVAILABLE
0407L3  HCART3   TLD      0       8      –       –     –        AVAILABLE
0408L3  HCART3   TLD      0       9      –       –     –        AVAILABLE
0409L3  HCART3   TLD      0       10     –       –     –        AVAILABLE

wxgadpt pool

0420L3  HCART3   TLD      0       73     –       3     55693440 ACTIVE
041YL3  HCART3   TLD      0       71     –       –     –        AVAILABLE
041ZL3  HCART3   TLD      0       72     –       –     –        AVAILABLE
0421L3  HCART3   TLD      0       74     –       –     –        AVAILABLE
0422L3  HCART3   TLD      0       75     –       –     –        AVAILABLE
0423L3  HCART3   TLD      0       76     –       –     –        AVAILABLE
0424L3  HCART3   TLD      0       77     –       –     –        AVAILABLE
0425L3  HCART3   TLD      0       78     –       –     –        AVAILABLE
0426L3  HCART3   TLD      0       79     –       –     –        AVAILABLE
0427L3  HCART3   TLD      0       80     –       –     –        AVAILABLE
040AL3  HCART3   TLD      0       11     –       3     356334144        FULL
040BL3  HCART3   TLD      0       12     –       3     356334144        FULL
040CL3  HCART3   TLD      0       13     –       3     356334240        FULL
040DL3  HCART3   TLD      0       14     –       3     356334240        FULL
040EL3  HCART3   TLD      0       15     –       3     356333888        FULL
040FL3  HCART3   TLD      0       16     –       3     356333888        FULL
040GL3  HCART3   TLD      0       17     –       3     356333984        FULL
040HL3  HCART3   TLD      0       18     –       3     356334240        FULL
040IL3  HCART3   TLD      0       19     –       3     356334240        FULL
040JL3  HCART3   TLD      0       20     –       3     356334240        FULL

wxgajwpt pool

040UL3  HCART3   TLD      0       31     –       3     5679104  ACTIVE
040VL3  HCART3   TLD      0       32     –       3     22806528 ACTIVE
040WL3  HCART3   TLD      0       33     –       3     8496672  ACTIVE
040YL3  HCART3   TLD      0       35     –       –     –        AVAILABLE
0410L3  HCART3   TLD      0       37     –       –     –        AVAILABLE
0411L3  HCART3   TLD      0       38     –       –     –        AVAILABLE
0412L3  HCART3   TLD      0       39     –       –     –        AVAILABLE
0413L3  HCART3   TLD      0       40     –       –     –        AVAILABLE
040XL3  HCART3   TLD      0       34     –       3     0        FROZEN
040ZL3  HCART3   TLD      0       36     –       3     0        FROZEN

wxgaqbpt pool

040TL3  HCART3   TLD      0       30     –       3     284681952        ACTIVE
040PL3  HCART3   TLD      0       26     –       –     –        AVAILABLE
040QL3  HCART3   TLD      0       27     –       –     –        AVAILABLE
040KL3  HCART3   TLD      0       21     –       3     356330752        FULL
040LL3  HCART3   TLD      0       22     –       3     356330464        FULL
040ML3  HCART3   TLD      0       23     –       3     356330976        FULL
040NL3  HCART3   TLD      0       24     –       3     356330752        FULL
040OL3  HCART3   TLD      0       25     –       3     356331008        FULL
040RL3  HCART3   TLD      0       28     –       3     356330752        FULL
040SL3  HCART3   TLD      0       29     –       3     356330848        FULL

4、单盘磁带信息

C:Program FilesVERITASNetBackupbinadmincmd>bpmedialist -m 040JL3
Server Host = p570b01

id                rl     images      allocated                    last updated                 density     kbytes     restores
vimages    expiration                     last read                        <——- STATUS ——->
——————————————————————————–
040JL3   3          22            2010-06-18 02:19   2010-06-19 02:48   hcart3   356334240     0
22            2010-07-20 02:48        N/A                                               FULL

5、解除冻结(FROZEN)的磁带

C:Program FilesVERITASNetBackupbinadmincmd>bpmedia -unfreeze -m 040XL3

6、使磁带过期及可写

C:Program FilesVERITASNetBackupbinadmincmd>bpexpdate -m 040ZL3 -d 0

7、列出备份文件目录

C:Program FilesVERITASNetBackupbin>bplist -C p570b01 -t 4 -R /

cntrl_236_1_722661541:
al_235_1_722661254:
al_234_1_722661063:
al_233_1_722661063:
bk_232_1_722660906:
bk_231_1_722660580:
bk_230_1_722660175:
bk_229_1_722659849:

利用NBU6.5备份AIX5.3下的ORACLE 10G数据库

声明:此文档仅作参考,如出现任何问题,文档编写者不承担任何责任!水平有限,文中定有错误之处,见谅!编写:老管,email:funpower#gmail.com

NBU服务器端由一台IBM 226服务器及一台昆腾虚拟带库组成,需备份的客户端为安装AIX5.3的IBM小机,备份的对象为ORACLE 10G数据库。

整个备份的拓扑图如下:

环境说明:
1、NBU备份主服务器与昆腾虚拟带库已配置完成
2、次只为增加的一台Oracle数据库服务器安装NBU客户端相关软件并调试,然后在NBU备份主服务器上添加此客户端并建立备份策略等相关调试
3、IP地址(化名):
NBU备份主服务器:10.31.111.111
Oracle数据库服务器:10.31.111.100

操作步骤:

1、配置Oracle数据库服务器的hosts文件

#cd /etc
#vi hosts

添加一行:
10.31.111.111 nbuserver
保存退出。

2、安装NBU clients软件
通过FTP将NBU客户端软件上传至小机的TMP目录下,然后运行:

#cd /tmp
#chmod –R 777 unixclients
#cd unixclients
#./install

Symantec Installation Script
Copyright 1993 – 2007 Symantec Corporation, All Rights Reserved.

        Installing NetBackup Client Software

 NOTE:  To install NetBackup Server software, insert the appropriate
        NetBackup Server cdrom.

Do you wish to continue? [y,n] (y)   //输入y
Do you want to install the NetBackup client software for this client? [y,n] (y)      //输入y
This package will install RS6000/AIX5 client.
This package will install NetBackup client 6.5.
Enter the name of the NetBackup server : nbuserver       //输入NBU备份主服务器hostname
Would you like to use “oracle1” as the configured
name of the NetBackup client? [y,n] (y)       //输入y,使用原小机的hostsname:oracle1

确认后,就开始安装NBU客户端软件,安装的默认路径为/usr/openv/netbackup。

3、配置和查看bp.conf

#cd /usr/openv/netbackup
#cat bp.conf

SERVER = nbuserver
CLIENT_NAME = oracle1

4、安装database agent
将database agent安装文件上传至上机的/tmp文件夹中,然后:

#cd /tmp
#chmod –R 777 /agents
#./install

Symantec Installation Script
Copyright 1993 – 2007 Symantec Corporation, All Rights Reserved.

        Installation Options

        1 NetBackup Add-On Product Software
        2 NetBackup Database Agent Software

        q To quit from this script
Choose an option [default: q]: 2   //选择2,安装database agent

**********

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
    local machine.

**********

Do you want to do a local installation? [y,n] (n) y     //进行本地安装
**********

        NetBackup Database Agent Installation

Choose the Database Agents you wish to install
one 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 Oracle
        5)  NetBackup for SAP
        6)  NetBackup for Sybase

        7)  Install All Database Agents

        q)  Done Selecting Agents
        x)  Exit from this Script

Choose an option: 4      //选择oracle

Choose an option: q       //完成选择操作

You have chosen to install these Database Agents:
        NetBackup for Oracle
Is this list correct? [y,n] (y)        //确定安装oracle agents

5、编辑sh备份脚本
Database agent安装完后,会在/usr/openv/netbackup/ext/db_ext/oracle/samples/rman中有一些例子文件,利用其中的一个,运行:

#cd /usr/openv/netbackup/ext/db_ext/oracle/samples/rman
#cp hot_database_backup.sh hot_database_backup.10.31.111.100.sh

然后使用vi编辑该sh,只需修改如下参数:
ORACLE_HOME=/oracle/product/10G
export ORACLE_HOME
ORACLE_SID=orcl2
export ORACLE_SID
ORACLE_USER=oracle
TARGET_CONNECT_STR=/

完成设置后,保存退出。

6、链接NetBackup for Oracle 和RMAN

#su – oracle
#cd /usr/openv/netbackup/bin
#./oracle_link

Mon Mar 15 11:29:34 BEIST 2010
All Oracle instances should be shutdown before running this script.

Please log into the Unix system as the Oracle owner for running this script

Do you want to continue? (y/n) [n] y     //输入y,开始安装

LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/product/10G
Oracle version: 10.2.0.3.0
Linking LIBOBK:
ln -s /usr/openv/netbackup/bin/libobk.a64 /oracle/product/10G/lib/libobk.a
Done

Please check the trace file located in /tmp/make_trace.856304
to make sure the linking process was successful.

出现上面文字后,说明动态链接库已链接成功。

7、NBU备份主服务器设置

首先设置主服务器的hosts文件,将IBM小机的hostname:oracle1添加至hosts中,用记事本打开c:windowssystem32driversetchosts,添加如下:
10.31.111.100 oracle1

打开NBU主界面,开始为10.31.111.100创建一个备份策略

在policies上点右键选择new policy,输入相应策略名称后点击确定

设置attributes选项卡,policy类型选择oracle,policy storage unix选择有效的存储单元

设置Schedules选项卡,点击选项卡下面的New…按扭,新建一个备份日程,选择automatic full backup,全备,frequency选择每星期一次备份,retention选择保留两个星期

备份开始时间为星期日晚上9点开始

设置完后,schedules有两个备份策略,全备和增量备份

设置clients,输入IBM小机的hostname:oracle1,操作系统选择RS6000/AIX5

设置backup selections,将上面新建并编辑好的.sh备份脚本输入至对话框中,点击确定后,完成策略的新建

开始测试备份,在新建的policies的10.31.111.100上点右键选择Manual Backup…,手动启动备份
 

转至Activity Monitor,查看备份情况

至此,IBM小机上的ORACLE已经可以定期的备份至昆腾虚拟磁带库中。