RMAN-06026错误,在线等待高手解答

Qinriwei 2003-04-16 03:55:55
我用oracle中backup备份工具备份了一个数据库,
RMAN> run {
2> allocate channel gtja type disk format 'd:\gtja';
3> backup
4> ( database include current controlfile );
5> }
6>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: gtja
RMAN-08500: channel gtja: sid=9 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel gtja: starting full datafile backupset
RMAN-08502: set_count=1 set_stamp=491396455 creation_time=APR 15 2003 11:00:55
RMAN-08010: channel gtja: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00002 name=C:\ORACLE\ORADATA\SHANGHAI\RBS01.DBF
RMAN-08522: input datafile fno=00003 name=C:\ORACLE\ORADATA\SHANGHAI\USERS01.DBF
RMAN-08522: input datafile fno=00004 name=C:\ORACLE\ORADATA\SHANGHAI\TEMP01.DBF
RMAN-08522: input datafile fno=00001 name=C:\ORACLE\ORADATA\SHANGHAI\SYSTEM01.DBF
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00006 name=C:\ORACLE\ORADATA\SHANGHAI\INDX01.DBF
RMAN-08522: input datafile fno=00005 name=C:\ORACLE\ORADATA\SHANGHAI\TOOLS01.DBF
RMAN-08013: channel gtja: piece 1 created
RMAN-08503: piece handle=D:\GTJA comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:06:09
RMAN-08031: released channel: gtja

Recovery Manager complete.

然后将oracle彻底删除,现在新装一个oracle来恢复,恢复时报错:
RMAN> run {
2> allocate channel gtja type disk format 'd:\gtja';
3> restore ( database);
4> recover database ;
5>
6> }
7>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: gtja
RMAN-08500: channel gtja: sid=11 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: gtja
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Recovery Manager complete.
child process exited abnormally

困扰我好几天了,高手救命啊
...全文
67 点赞 收藏 3
写回复
3 条回复
penitent 2003年04月16日
如果用了catalog,
还有两中情况
一是用的mount下的数据库的一致性备份,只需要restore就可以了
如果用的open方式的备份,需要有归档,才可以考虑用不完全恢复,因为你连联机日志都没有了。
回复 点赞
penitent 2003年04月16日
你这么说还是没有说清楚
用catalog了没有
如果没有用catalog,你这个测试是肯定不成功的
回复 点赞
hrb_qiuyb 2003年04月16日
你还真问着了,这个问题前几天我做测试时刚遇到过,先告诉你如何处理,然后给你稍做解释,另你的恢复脚本也有一些问题。
1、把你的恢复脚本修改成如下就可以了。
RMAN> run {
2> allocate channel gtja type disk format 'd:\gtja';
3> set until time '15-APR-03 10:00:00';
4> restore controlfile;
5> alter database mount;
6> restore database;
7> release channel gata;
8> }
需要特别注意的是"3>",这里的时间是我随便写的,指的是你在建新库和备份之间的某一个时间点。
2、解释
如果你不使用set until,rman便试图恢复到新库现在所处的时间点,那怎么可能呢?
回复 点赞
发动态
发帖子
基础和管理
创建于2007-09-28

7175

社区成员

9.5w+

社区内容

Oracle 基础和管理
社区公告
暂无公告