我有完全的备份，但怎么也恢复不了。急求解决，谢谢
我有完全的备份，但怎么也恢复不了。
-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 全备脚本
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 发布
Try restore controfle from db_full_JYC_20060706_71
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
页:
[1]