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

[Qinriwei]

我用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

困扰我好几天了，高手救命啊

[hrb_qiuyb]

你还真问着了，这个问题前几天我做测试时刚遇到过，先告诉你如何处理，然后给你稍做解释，另你的恢复脚本也有一些问题。
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便试图恢复到新库现在所处的时间点，那怎么可能呢？

[penitent]

你这么说还是没有说清楚
用catalog了没有
如果没有用catalog，你这个测试是肯定不成功的

[penitent]

如果用了catalog，
还有两中情况
一是用的mount下的数据库的一致性备份，只需要restore就可以了
如果用的open方式的备份，需要有归档，才可以考虑用不完全恢复，因为你连联机日志都没有了。