[转]Netbackup 6 备份 oracle 9.2

bqw_5189

浏览: 32359 次
性别:
来自: 北京

最近访客更多访客>>

xjgood

youshouyiqi

wuqiang901017

boobycn

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (23)

社区版块

存档分类

Oracle SQL Server 配置管理 VSS SQL

环境描述：
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 'SYS/*****@ORCL' 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.

http://blog.chinaunix.net/u/7315/showart_262131.html

分享到：