今天给客户做文件系统数据文件转移到裸设备上的操作,用rman来完成,本来很简单的事情,但是却意外地碰到了下面的错误。 rman> backup database; Starting backup at 30-NOV-07 allocated channel: ora_DISK_1 channel ora_DISK_1: sid=23 devtype=DISK rman-00571: ============================= rman-00569: = ERROR MESSAGE STA C K FOLLOWS = rman-00571: ============================= rman-03002: failure of backup co...
在生产机上利用NBU全备份脚本进行全备份(包括数据文件\归档\控制文件),然后用NBU恢复到另外一台机器上,数据文件重定向,数据恢复没有问题,但在rman里恢复archive的时候有报错, 执行sqlplus>recover database using backup controlfile until cancel; cancel 显示介质恢复没有开始 执行sqlplus>alter database open resetlogs; 报错: ora-01152:file1 was not restored from a sufficiently old backup ora-01110:data file 1 :/ora...
最近闲来无事儿,玩一玩儿Bakbone 备份oracle备份过程中报rman-10031: ora-19624错,查询oracle错误代码,但一直没有解决,到google上一search发现好多关NBU关于此问题的贴,而且报错与我在使用netvault时一模一样,但就是没有人回复具体的解决办.详情见 http://www.ixpub.net/633026.html 内容如下: Veritas NBU备份报错 环境如下: 备份服务器:HP-UX 11.23 备份客户端:Tru64,oracle816。 报错信息如下: rman-06005: connected ...
rman-00571: =========================================================== rman-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== rman-00571: =========================================================== rman-03009: failure of allocate command on c1 channel at 10/21/2009 15:20:04 ora-19554: error allocating device, device type: SBT_TAPE, device name: ora-27000: skgfqsbi: failed to ini...
run{ allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; backup incremental level 1 tag 'db1' format 'db1_%t_%s_%p' diskratio=0 database skip readonly; sql 'alter system archive log current'; backup format 'arch_%t_%s_%p' diskratio=0 archivelog all; release channel t1; } channel t1: starting piece 1 at 21-AUG-05 released channel: t1 RMA...
rman target sys/atyu30@primary auxiliary sys/atyu30
rman> duplicate target database to ATYU30 nofilenamecheck;
我做了一个测试,关于rman的, 环境: oracle 10.2.0 rman nocatalog方式 1、首先设置 CONFIGURE CONTROLFILE AUTOBACKUP ON; 然后进行数据库全备份 rman> backup database; Starting backup at 21-APR-10 using channel ora_SBT_TAPE_1 channel ora_SBT_TAPE_1: starting full datafile backupset channel ora_SBT_TAPE_1: specifying datafile(s) in backupset input datafile fno=00001 name=/opt/oracle/oradata/test/system0...
比如A机器有oracle 没装rman B机器有oracle rman 能用 b 机器的rman 备份 a机器的oracle吗?/ 能的话怎么实现啊? :em17: :em17:
我定义rman保留策略----恢复窗口为7天(RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS)7天前的备份集标记成obsolete,但是不解的是刚刚产生的备份集(控制文件,其它类型的备份集正常)会被标记成obsolete;请各位指教,谢谢!