求nbu 备份 oracle rac database 的脚本(cold 和hot )

发布于 2022-09-02 20:18:51 字数 3222 浏览 7 评论 9

查看NetBackup_AdminGuide_Oracle_Unix ,里提到是下面的脚本.

RUN
{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_SERV=$NB_ORA_SERV';
BACKUP
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_SERV=$NB_ORA_SERV';
BACKUP
ARCHIVELOG ALL ;
RELEASE CHANNEL ch00;
}

可我运行时报错

RMAN> RUN
2> {
3> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
4> SEND 'NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_SERV=$NB_ORA_SERV';
5> BACKUP
6> DATABASE;
7> sql 'alter system archive log current';
8> RELEASE CHANNEL ch00;
9> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
10> SEND 'NB_ORA_CLIENT=$NB_ORA_CLIENT, NB_ORA_SERV=$NB_ORA_SERV';
11> BACKUP
12> ARCHIVELOG ALL ;
13> RELEASE CHANNEL ch00;
14> }

using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=141 instance=racg2 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010051100)

sent command to channel: ch00

Starting backup at 28-JUL-10
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00006 name=/bbbb/odm2.dbf
input datafile file number=00002 name=/oracle/racg/sysaux01.dbf
input datafile file number=00001 name=/oracle/racg/system01.dbf
input datafile file number=00003 name=/oracle/racg/undotbs01.dbf
input datafile file number=00005 name=/oracle/racg/undotbs02.dbf
input datafile file number=00004 name=/oracle/racg/users01.dbf
channel ch00: starting piece 1 at 28-JUL-10
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 07/28/2010 15:07:06
ORA-19506: failed to create sequential file, name="1flju60e_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSAValidateFeatureId: Failed with error:
Server Status: cannot connect on socket

网上找到另一个
RUN {
ALLOCATE CHANNEL ch00 device type sbt connect'sys/oracle@racg1'parms "ENV=(NB_ORA_CLIENT=hp01)" ;
ALLOCATE CHANNEL ch01 device type sbt connect'sys/oracle@racg2'parms "ENV=(NB_ORA_CLIENT=hp02)" ;
SEND 'NB_ORA_CLIENT=$NB_ORA_CLIENT';
BACKUP
TAG hot_backup
FORMAT 'rac_backup_%d_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}

我运行这2个都有问题, 哪位有做过?谢谢

分享到QQ

分享到微博