我有完全的备份，但怎么也恢复不了。急求解决，谢谢

ALLSTARS_ORACLE

我有完全的备份，但怎么也恢复不了。
-rw-r-----   1 oracle   dba         3584 Jul  6 13:34 ar_JYC_20060706_72
-rw-r-----   1 oracle   dba      3153920 Jul  6 13:33 db_full_JYC_20060706_69
-rw-r-----   1 oracle   dba      148193280 Jul  6 13:33 db_full_JYC_20060706_70
-rw-r-----   1 oracle   dba      135766016 Jul  6 13:32 db_full_JYC_20060706_71

－－－－－－－－－－－－－－－－－－－－


RMAN> shutdown immediate

Oracle instance shut down

RMAN> startup nomount

connected to target database (not started)
Oracle instance started

Total System Global Area     320308312 bytes

Fixed Size                      730200 bytes
Variable Size                285212672 bytes
Database Buffers              33554432 bytes
Redo Buffers                    811008 bytes

RMAN> restore controlfile from '/home/oracle/rman_data/c-3866051836-20060706-05';

Starting restore at 24-7月 -06

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
replicating controlfile
input filename=/home/oracle/oradata/jyc/control01.ctl
output filename=/home/oracle/oradata/jyc/control02.ctl
output filename=/home/oracle/oradata/jyc/control03.ctl
Finished restore at 24-7月 -06

RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE DISK;
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL ch00;
3> 4> 5> 6> }

allocated channel: ch00
channel ch00: sid=11 devtype=DISK

Starting restore at 24-7月 -06

released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2006 10:17:28
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to 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

ALLSTARS_ORACLE

全备脚本

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup full database
format '/home/oracle/oradata/backup/jyc/db_full_%d_%T_%s'
tag = 'WHOLE_FULL'
plus archivelog
format '/home/oracle/oradata/backup/jyc/ar_%d_%T_%s'
tag = 'AR_FULL'
delete all input;
release channel c1;
release channel c2;
release channel c3;
}
－－－－－－
oracle版本

－－－－
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE    9.2.0.1.0       Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production



最初由 rollingpig 发布
[B]Try restore controfle from db_full_JYC_20060706_71 [/B]



RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area     320308312 bytes

Fixed Size                      730200 bytes
Variable Size                285212672 bytes
Database Buffers              33554432 bytes
Redo Buffers                    811008 bytes

RMAN> restore controlfile from '/home/oracle/oradata/backup/jyc/db_full_JYC_20060706_71';

Starting restore at 24-7月 -06

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: restoring controlfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2006 13:03:02
ORA-19615: some files not found in backup set
ORA-19613: datafile 0 not found in backup set

RMAN> restore controlfile from '/home/oracle/oradata/backup/jyc/db_full_JYC_20060706_70';

Starting restore at 24-7月 -06

using channel ORA_DISK_1
channel ORA_DISK_1: restoring controlfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2006 13:03:18
ORA-19615: some files not found in backup set
ORA-19613: datafile 0 not found in backup set

RMAN> restore controlfile from '/home/oracle/oradata/backup/jyc/db_full_JYC_20060706_69';

Starting restore at 24-7月 -06

using channel ORA_DISK_1
channel ORA_DISK_1: restoring controlfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2006 13:03:28
ORA-19615: some files not found in backup set
ORA-19613: datafile 0 not found in backup set


不行啊，如果controlfile找不到了，有办法恢复吗？

不行啊，

SQL> DECLARE
  2  devtype varchar2(256);
  3  done boolean;
  4  BEGIN
  5  devtype:=sys.dbms_backup_restore.deviceAllocate(type=>'',ident=>'T1');
  6  sys.dbms_backup_restore.restoreSetDatafile;
  7  sys.dbms_backup_restore.restoreControlfileTo(cfname=>'/home/oracle/oradata/jyc/control01.ctl');
  8  sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'/home/oracle/oradata/backup/jyc/db_full_JYC_20060706_71', params=>null);
sys.dbms_backup_restore.deviceDeallocate;
END;
/  9   10   11  
DECLARE
*
ERROR at line 1:
ORA-19583: conversation terminated due to error
ORA-19615: some files not found in backup set
ORA-19613: datafile 0 not found in backup set
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 1371
ORA-06512: at line 8