各位好:我通过rman从A服务器异地恢复B服务器,B服务器只安装了
oracle10.2产品,我还原了spfile文件和controlfile文件,但是在还原数据文件时报错,一直找不到解决方法,求大神指点迷经……
RMAN> catalog start with '/home/oracle/oracle_back/';
Starting implicit crosscheck backup at 28-AUG-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
Crosschecked 3 objects
Finished implicit crosscheck backup at 28-AUG-13
Starting implicit crosscheck copy at 28-AUG-13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 28-AUG-13
searching for all files in the recovery area
cataloging files...
no files cataloged
searching for all files that match the pattern /home/oracle/oracle_back/
List of Files Unknown to the Database
=====================================
File Name: /home/oracle/oracle_back/whole_ORCL_26oiej27_1_1
File Name: /home/oracle/oracle_back/whole_ORCL_24oiej19_1_1
File Name: /home/oracle/oracle_back/whole_ORCL_23oieiv7_1_1
File Name: /home/oracle/oracle_back/whole_ORCL_25oiej1o_1_1
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /home/oracle/oracle_back/whole_ORCL_26oiej27_1_1
File Name: /home/oracle/oracle_back/whole_ORCL_24oiej19_1_1
File Name: /home/oracle/oracle_back/whole_ORCL_23oieiv7_1_1
File Name: /home/oracle/oracle_back/whole_ORCL_25oiej1o_1_1
RMAN> restore database preview summary;
Starting restore at 28-AUG-13
using channel ORA_DISK_1
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
56 B F A DISK 28-AUG-13 1 1 NO TAG20130828T155519
57 B F A DISK 28-AUG-13 1 1 NO TAG20130828T155519
58 B F A DISK 28-AUG-13 1 1 NO TAG20130828T155519
archive logs generated after SCN 302605265 not found in repository
Media recovery start SCN is 302605265
Recovery must be done beyond SCN 302605299 to clear data files fuzziness
Finished restore at 28-AUG-13
RMAN> restore database;
Starting restore at 28-AUG-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /home/oracle/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00004 to /home/oracle/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /home/oracle/oracle/oradata/orcl/example01.dbf
restoring datafile 00006 to /mnt/oracle/oradata/orcl/sms.dbf
restoring datafile 00007 to /mnt/oracle/oradata/orcl/ZJPM.dbf
restoring datafile 00008 to /mnt/oracle/oradata/orcl/usrzjpay.dbf
restoring datafile 00009 to /mnt/oracle/oradata/orcl/USP.dbf
restoring datafile 00010 to /mnt/oracle/oradata/orcl/INTEGPAY.dbf
restoring datafile 00011 to /home/oracle/oracle/oradata/orcl/CMCCPAY.dbf
restoring datafile 00012 to /mnt/oracle/oradata/orcl/stl.dbf
restoring datafile 00013 to /mnt/oracle/oradata/orcl/MANAGEMENT.dbf
restoring datafile 00014 to /mnt/oracle/oradata/orcl/TRANS.dbf
restoring datafile 00015 to /mnt/oracle/oradata/orcl/LOG.dbf
restoring datafile 00016 to /mnt/oracle/oradata/orders.dbf
restoring datafile 00017 to /mnt/oracle/oradata/orcl/SETTLE.dbf
restoring datafile 00018 to /mnt/oracle/oradata/orcl/ubp591.dbf
restoring datafile 00019 to /mnt/oracle/oradata/orcl/shhaistl.dbf
restoring datafile 00020 to /mnt/oracle/oradata/orcl/fjstl.dbf
restoring datafile 00021 to /mnt/oracle/oradata/orcl/KQ.dbf
restoring datafile 00022 to /mnt/oracle/oradata/orcl/JXEC.dbf
restoring datafile 00023 to /mnt/oracle/oradata/orcl/POSP.dbf
restoring datafile 00024 to /mnt/oracle/oradata/orcl/LY.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/oracle_back/whole_ORCL_23oieiv7_1_1
ORA-19870: error reading backup piece /home/oracle/oracle_back/whole_ORCL_23oieiv7_1_1
ORA-19502: write error on file "/home/oracle/oracle/oradata/orcl/undotbs01.dbf", blockno 14353 (blocksize=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4
Additional information: 14353
Additional information: 49152
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /home/oracle/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/oracle_back/whole_ORCL_24oiej19_1_1
ORA-19870: error reading backup piece /home/oracle/oracle_back/whole_ORCL_24oiej19_1_1
ORA-19502: write error on file "/home/oracle/oracle/oradata/orcl/system01.dbf", blockno 14257 (blocksize=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4
Additional information: 14257
Additional information: 77824
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /home/oracle/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/oracle_back/whole_ORCL_25oiej1o_1_1
ORA-19870: error reading backup piece /home/oracle/oracle_back/whole_ORCL_25oiej1o_1_1
ORA-19502: write error on file "/home/oracle/oracle/oradata/orcl/sysaux01.dbf", blockno 14257 (blocksize=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4
Additional information: 14257
Additional information: 77824
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/28/2013 16:11:12
RMAN-06026: some targets not found - aborting 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