NBU实现数据库异地备份问题

tsmao

master服务器和clinet服务器为不同的server，oracle安装再client服务器上，nbu安装在
master服务器上，要实现把oracle备份到master服务器的硬盘上，脚本如下，但每次在n'bu上手动执行时，oracle全部备份到了client服务器上的硬盘，没有保存在异地，为什么，
脚本如下
{
allocate channel dev1 type disk;
SEND 'NB_ORA_POLICY=test,NB_ORA_SERV=inms_back,NB_ORA_CLIENT=ts_oss_bak,NB_ORA_SCHED=Default-Application-Backup';
backup incremental level 0 database
format 'ctrl%t%s.%p';
}

科学球

allocate channel dev1 type disk;
改成
allocate channel dev1 type sbt_tape;

tsmao

不行啊RMAN> run { execute script 'hot_database_backup_ctrl';}
RMAN-03021: executing script: hot_database_backup_ctrl

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script hot_database_backup_ctrl
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel c1
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Additional information: 4110
ORA-19511: SBT error = 4110, errno = 0, BACKUP_DIR environment variable is not set
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DEVICEALLOCATE

RMAN>
仍然报错

swish

要将oracle软件的libobk库文件link到nbu的libobk库文件

tsmao

楼上请说详细一点
谢谢

tsmao

我的nbu和目标数据库不在一台server上

alex_linux

#/usr/openv/netbackup/bin
#./oracle_link

change  disk  to  sbt_tape

in policies select  SU

tsmao

老大
in policies select  SU
是什么意思

tsmao

还是有问题
logRMAN> RMAN> ery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: INMS (DBID=2915309801)
RMAN-06008: connected to recovery catalog database

RMAN> run { execute script 'hot_database_backup_ctrl';}
RMAN-03021: executing script: hot_database_backup_ctrl

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev1
RMAN-08500: channel dev1: sid=20 devtype=SBT_TAPE
RMAN-08526: channel dev1: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: dev1

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel dev1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=34 set_stamp=607364975 creation_time=24-NOV-06
RMAN-08010: channel dev1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00013 name=/opt/oracle/db01/inmsdb/data/static1/INMS_TBLS_DATA_STATIC.dbf
RMAN-08522: input datafile fno=00015 name=/opt/oracle/db01/inmsdb/rbs1/INMS_TBLS_RBS.dbf
RMAN-08522: input datafile fno=00009 name=/opt/oracle/db01/inmsdb/data/dynamic1/INMS_TBLS_DATA_DYNAMIC03.dbf
RMAN-08522: input datafile fno=00010 name=/opt/oracle/db01/inmsdb/data/dynamic1/INMS_TBLS_DATA_DYNAMIC04.dbf
RMAN-08522: input datafile fno=00007 name=/opt/oracle/db01/inmsdb/data/dynamic1/INMS_TBLS_DATA_DYNAMIC01.dbf
RMAN-08522: input datafile fno=00008 name=/opt/oracle/db01/inmsdb/data/dynamic1/INMS_TBLS_DATA_DYNAMIC02.dbf
RMAN-08522: input datafile fno=00011 name=/opt/oracle/db01/inmsdb/idx/dynamic1/INMS_TBLS_IDX_DYNAMIC01.dbf
RMAN-08522: input datafile fno=00012 name=/opt/oracle/db01/inmsdb/idx/dynamic1/INMS_TBLS_IDX_DYNAMIC02.dbf
RMAN-08522: input datafile fno=00014 name=/opt/oracle/db01/inmsdb/idx/static1/INMS_TBLS_IDX_STATIC.dbf
RMAN-08522: input datafile fno=00003 name=/opt/oracle/db01/oradata/inms/rbs01.dbf
RMAN-08522: input datafile fno=00004 name=/opt/oracle/db01/oradata/inms/temp01.dbf
RMAN-08522: input datafile fno=00001 name=/opt/oracle/db01/oradata/inms/system01.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00006 name=/opt/oracle/db01/oradata/inms/indx01.dbf
RMAN-08522: input datafile fno=00002 name=/opt/oracle/db01/oradata/inms/tools01.dbf
RMAN-08522: input datafile fno=00005 name=/opt/oracle/db01/oradata/inms/users01.dbf
RMAN-08522: input datafile fno=00016 name=/opt/oracle/db01/rmandb/rmants.dbf
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script hot_database_backup_ctrl
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel dev1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="ctrl60736497534.1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to open for backup.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
急呀
大侠指教

yddll

最好是从头开始学学
这么问，要学到猴年马月去呀