ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN恢复数据库问题

RMAN恢复数据库问题

原创 Linux操作系统 作者:雪亦龙 时间:2013-08-28 16:34:28 0 删除 编辑
各位好:我通过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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28646132/viewspace-769439/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-03-20

  • 博文量
    1
  • 访问量
    2575