环境描述：

Netbackup Master Server:windows 2003  Veritas Netbackup

6.0

Netbackup Advanced Client:windows 2003 Oracle oracle 9.2

一、安装Veritas Netbackup Server 6.0和Netbackup Client

所有的license key

都在安装Netbackup Server时输入，

带有 Advanced Client 功能的 NetBackup for

Oracle具有快照备份、即时修复、脱离主机备份等功能

二、配置 NetBackup for Oracle 策略和日程表

2。1创建 Oracle

策略和日程表

1、单击开始 > 所有程序 > VERITAS NetBackup > NetBackup

管理控制台

2、右击所有策略(All Policies) 窗格，然后单击新建策略(New

Policy)

a、备份策略配置向导

b、策略名称和类型(Policy Name and Type)  选择 Oracle

作为策略类型

c、客户机列表(Client List)  添加 NetBackup forOracle

客户机名称。选择硬件和操作系统

d、备份类型(Backup Type)  默认值

e、循环(Rotation)

默认值

f、启动时段(Start Window) 默认值

g、完成(Finish)

如果需要设置Snapshot

Backup，在对应的策略Attributes上 选择perform snapshot Backups，Advanced snapshot

options选择VSS

3、创建日程表

日程表决定 NetBackup for Oracle 何时启动备份。一个 Oracle

备份至少需要两个不同的日程表：

◆ 一个应用程序备份日程表。在创建 Oracle 策略时， NetBackup for Oracle 自动创建一个

Default-Application-Backup 日程表。

◆

一个“自动完全备份”日程表。该日程表需要由您创建。使用该日程表，可以在客户机上执行预定的备份操作。

a、策略(Policy)

对话框－－日程表(Schedules) 选项卡

b、新建(New) 创建另一个日程表

c、选择自动完全备份(Automatic Full

Backup) 作为备份类型  保留期为 3 个月。复用路数为 1。

d、启动时段(Start Window) 选项卡

每天18:00-23:00

e、确定(OK)

2。2备份 Oracle 数据库

1、登录到客户机，然后调用备份向导，单击开始 > 所有程序 > VERITAS

NetBackup > 备份、归档和恢复

2、单击备份文件(Backup Files) 选项卡

3、确定是要备份完整 Oracle

实例

4、单击操作(Actions) > 开始备份标记的文件(Start Backup of Marked

Files)(Oracle处于归档模式)

5、调用备份向导

6、目标数据库登录凭据(Target Database Logon

Credentials) 对话框

7、“修复目录登录凭据(Recovery Catalog Logon

Credentials)

8、已归档的重做日志(Archived Redo Logs) 屏幕

9、配置选项(Configuration

Options) 屏幕。

10、数据库状态(Database State)屏幕。

11、NetBackup 配置变量(NetBackup

Configuration Variables) 屏幕

在备份策略名称(Backup policy name) 字段中，输入在 NetBackup

主服务器上创建的Oracle 策略的名称。备份服务器，客户名称

12、单击向导完成后立即执行备份(Perform backup immediately

after wizard finishes)

13、要开始备份，请单击完成(Finish)

以下通过View Status看到的备份log

INF - Begin progress logging for process:

(3968.4024)

INF - Using policy oracle9i to perform a user directed Standard

backup.

INF - Starting Oracle Recovery Manager.

INF - Using:

"e:\oracle\ora92\bin\rman.exe"

INF - Connection info: target nocatalog

INF - Start of

Recovery Manager input.

INF - Begin progress logging for process:

(336.560)

INF - #

-----------------------------------------------------------------

INF - #

RMAN command section

INF - #

-----------------------------------------------------------------

INF - RUN

{

INF - ALLOCATE CHANNEL ch00

INF -     TYPE 'SBT_TAPE';

INF - SEND

'NB_ORA_CLIENT=Oracle9i,NB_ORA_POLICY=oracle9i,NB_ORA_SERV=ASUS,NB_ORA_SCHED=app';

INF

- BACKUP

INF -     INCREMENTAL LEVEL=0

INF -     FORMAT

'bk_u%u_s%s_p%p_t%t'

INF -     DATABASE;

INF - RELEASE CHANNEL

ch00;

INF - # Backup Archived Logs

INF - sql 'alter system archive log

current';

INF - ALLOCATE CHANNEL ch00

INF -     TYPE 'SBT_TAPE';

INF -

SEND

'NB_ORA_CLIENT=Oracle9i,NB_ORA_POLICY=oracle9i,NB_ORA_SERV=ASUS,NB_ORA_SCHED=app';

INF

- BACKUP

INF -     FORMAT 'arch-s%s-p%p-t%t'

INF -     ARCHIVELOG

INF

-         ALL

INF -     DELETE INPUT;

INF - RELEASE CHANNEL ch00;

INF -

# Control file backup

INF - ALLOCATE CHANNEL ch00

INF -     TYPE

'SBT_TAPE';

INF - SEND

'NB_ORA_CLIENT=Oracle9i,NB_ORA_POLICY=oracle9i,NB_ORA_SERV=ASUS,NB_ORA_SCHED=app';

INF

- BACKUP

INF -     FORMAT 'bk_u%u_s%s_p%p_t%t'

INF -     CURRENT

CONTROLFILE;

INF - RELEASE CHANNEL ch00;

INF - }

INF - Start backup of

backup piece: (bk_u07id25h2_s7_p1_t617682466)

INF - End of Recovery Manager

input.

INF - Start of Recovery Manager output.

INF - Recovery Manager:

Release 9.2.0.1.0 - Production

INF - connected to target database: ORCL

(DBID=1132391046)

INF - using target database controlfile instead of recovery

catalog

INF - allocated channel: ch00

INF - channel ch00: starting

incremental level 0 datafile backupset

INF - including current SPFILE in

backupset

INF - including current controlfile in backupset

INF - input

datafile fno=00001 name=E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF

INF - input

datafile fno=00002 name=E:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF

INF - input

datafile fno=00005 name=E:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF

INF - input

datafile fno=00010 name=E:\ORACLE\ORADATA\ORCL\XDB01.DBF

INF - input datafile

fno=00006 name=E:\ORACLE\ORADATA\ORCL\INDX01.DBF

INF - input datafile

fno=00009 name=E:\ORACLE\ORADATA\ORCL\USERS01.DBF

INF - input datafile

fno=00003 name=E:\ORACLE\ORADATA\ORCL\CWMLITE01.DBF

INF - input datafile

fno=00004 name=E:\ORACLE\ORADATA\ORCL\DRSYS01.DBF

INF - input datafile

fno=00007 name=E:\ORACLE\ORADATA\ORCL\ODM01.DBF

INF - Backup id:

oracle9i_1174382945

INF - Policy: oracle9i

INF - Master server:

asus

INF - Beginning backup on server asus of client oracle9i.

INF - End

backup of backup piece: (bk_u07id25h2_s7_p1_t617682466)

INF - Server status =

0

INF - Begin progress logging for process: (336.560)

INF - Start backup

of backup piece: (arch-s8-p1-t617683382)

INF - Backup id:

oracle9i_1174383855

INF - Policy: oracle9i

INF - Master server:

asus

INF - Beginning backup on server asus of client oracle9i.

INF - End

backup of backup piece: (arch-s8-p1-t617683382)

INF - Server status =

0

INF - input datafile fno=00008

name=E:\ORACLE\ORADATA\ORCL\TOOLS01.DBF

INF - piece

handle=bk_u07id25h2_s7_p1_t617682466 comment=API Version 2.0,MMS Version

5.0.0.0

INF - channel ch00: backup set complete, elapsed time:

00:15:07

INF - released channel: ch00

INF - sql statement: alter system

archive log current

INF - allocated channel: ch00

INF - current log

archived

INF - channel ch00: starting archive log backupset

INF - input

archive log thread=1 sequence=8 recid=7 stamp=617683376

INF - input archive

log thread=1 sequence=9 recid=8 stamp=617683377

INF - input archive log

thread=1 sequence=10 recid=9 stamp=617683378

INF - input archive log thread=1

sequence=11 recid=10 stamp=617683381

INF - piece handle=arch-s8-p1-t617683382

comment=API Version 2.0,MMS Version 5.0.0.0

INF - channel ch00: backup set

complete, elapsed time: 00:04:56

INF - channel ch00: deleting archive

log(s)

INF - archive log filename=E:\ORACLE\ORA92\RDBMS\ARC00008.001 recid=7

stamp=617683376

INF - Begin progress logging for process: (336.560)

INF -

Start backup of backup piece: (bk_u09id26n1_s9_p1_t617683681)

INF - Backup

id: oracle9i_1174384149

INF - Policy: oracle9i

INF - Master server:

asus

INF - Beginning backup on server asus of client oracle9i.

INF - End

backup of backup piece: (bk_u09id26n1_s9_p1_t617683681)

INF - Server status =

0

INF - archive log filename=E:\ORACLE\ORA92\RDBMS\ARC00009.001 recid=8

stamp=617683377

INF - archive log filename=E:\ORACLE\ORA92\RDBMS\ARC00010.001

recid=9 stamp=617683378

INF - archive log

filename=E:\ORACLE\ORA92\RDBMS\ARC00011.001 recid=10 stamp=617683381

INF -

released channel: ch00

INF - allocated channel: ch00

INF - channel ch00:

starting full datafile backupset

INF - including current controlfile in

backupset

INF - piece handle=bk_u09id26n1_s9_p1_t617683681 comment=API

Version 2.0,MMS Version 5.0.0.0

INF - channel ch00: backup set complete,

elapsed time: 00:04:26

INF - released channel: ch00

INF - Recovery Manager

complete.

INF - End of Recovery Manager output.

INF - End Oracle Recovery

Manager.