rman备份恢复到异机报ORA-01110 ORA-01180错误

[Oracle@server1 ORACLE]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Thu Jul 31 13:51:40 2014Copyright （c） 1982, 2007, Oracle. All rights reserved.connected to target database （not started）RMAN> set dbid 1619708557executing command: SET DBIDRMAN> startup nomountOracle instance startedTotal System Global Area 8388608000 bytesFixed Size 2109640 bytesVariable Size 5117054776 bytesDatabase Buffers 3221225472 bytesRedo Buffers 48218112 bytesRMAN> restore controlfile from "/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854376584_9xmsr8fm_.bkp";Starting restore at 31-JUL-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=1084 devtype=DISK
channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:01output filename=/home/oracle/orabase/oradata/ORACLE/control01.ctloutput filename=/home/oracle/orabase/oradata/ORACLE/control02.ctloutput filename=/home/oracle/orabase/oradata/ORACLE/control03.ctlFinished restore at 31-JUL-14
RMAN> alter database mount;
database mountedreleased channel: ORA_DISK_1 --------------------------------------------------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm-------------------------------------------------------------------------------- RMAN> restore database;
启动 restore 于 31-7月-14使用通道 ORA_DISK_1
创建数据文件 fno = 1 名称 = /home/oracle/orabase/oradata/ORACLE/system01.dbfMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: restore 命令（在 07/31/2014 12:06:00 上）失败ORA-01180: 无法创建数据文件 1ORA-01110: 数据文件 1: "/home/oracle/orabase/oradata/ORACLE/system01.dbf"
RMAN>
RMAN> crosscheck backupset;
Starting implicit crosscheck backup at 31-JUL-14allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=1084 devtype=DISKCrosschecked 10 objectsFinished implicit crosscheck backup at 31-JUL-14
Starting implicit crosscheck copy at 31-JUL-14using channel ORA_DISK_1Finished implicit crosscheck copy at 31-JUL-14
searching for all files in the recovery areacataloging files...cataloging done
List of Cataloged Files=======================File Name: /home/oracle/orabase/flash_recovery_area/ORACLE/archivelog/2014_07_31/o1_mf_1_116_9xm5yprp_.arcFile Name: /home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp
using channel ORA_DISK_1crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3843 stamp=854328882crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3844 stamp=854329003crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3845 stamp=854331139crosschecked backup piece: found to be "AVAILABLE"backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846
stamp=854373190Crosschecked 9 objects
由于备份集过期导致无法还原数据库，重新注册备份片。RMAN> catalog backuppiece "/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak";cataloged backuppiecebackup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756RMAN> catalog backuppiece "/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak";cataloged backuppiecebackup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783RMAN> catalog backuppiece "/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak";cataloged backuppiecebackup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809 注册成功之后再次查看RMAN> crosscheck backupset;
allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=1087 devtype=DISKcrosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673crosschecked backup piece: found to be "EXPIRED"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910crosschecked backup piece: found to be "AVAILABLE"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756crosschecked backup piece: found to be "AVAILABLE"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783crosschecked backup piece: found to be "AVAILABLE"backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809crosschecked backup piece: found to be "AVAILABLE"backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846
stamp=854373190Crosschecked 9 objects
还原数据库RMAN> restore database;恢复数据库到指定序列。RMAN> recover database until sequence 13908恢复结束后，启动数据库。RMAN> alter database open resetlogs更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址