oracle 磁带 恢复,关于磁带库rman备份恢复的案例

我把当初的步骤在描述一下:

1、目标数据库所有文件没有,仅保存有arch文件

2、作恢复:

run

{allocate channel ch00 type 'sbt_tape';

restore controlfile;

restore database;

recover database;

release channel ch00;}

运行正常,需要的文件都restore,recover 的时候,需要的一部分arch文件也从备份中读出,但是

由于需要的其后一部分arch文件磁带库里没有,所以最终没有正确结束,于是运行svrmgrl,作recover database 并auoto,最终alter database open resetlogs;

数据库正常了,但是以前定时的正常备份不知为什么不行了,查了资料也得不到答案

于是注销掉目标库并重新注册,有点奇怪的时,在执行register database;命令后,除了前几行什么compile正常,一直光标闪动,不结束,等了近一个多小时也没反应,但是查找目录库里db表里已经注册上了,就直接关掉了。

于是作了一个简单的测试:

run

{allocate channel ch00 type 'sbt_tape';

backup tablespace tools;

release channel ch00;}

也是很长时间没反应,今早一看报如下错误:

RMAN-03022: compiling command: backup

RMAN-03024: performing implicit full resync of recovery catalog

RMAN-03023: executing command: full resync

RMAN-08002: starting full resync of recovery catalog

RMAN-08004: full resync complete

RMAN-03023: executing command: backup

RMAN-08008: channel ch00: starting full datafile backupset

RMAN-08502: set_count=7128 set_stamp=613420748 creation_time=01-FEB-07

RMAN-08010: channel ch00: specifying datafile(s) in backupset

RMAN-08522: input datafile fno=00005 name=E:\ORACLE\ORADATA\LYFK\TOOLS01.DBF

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03007: retryable error occurred during execution of command: backup

RMAN-07004: unhandled exception during command execution on channel ch00

RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file

, name="uoi903mc_1_1", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: VxBSACreateObject: Failed with error:

Server Status: the specified client does not exist in an active policy withi

n the configuration database

RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECRE

ATE

数据库:winnt+oracle817

采用veritas netbackup5.0

netbackup报的错是

the specified client does not exist in an active policy within the configuration database(236)

请各位指教呀

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值