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 2014 Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started) RMAN> set dbid 1619708557 executing command: SET DBID RMAN> startup nomount Oracle instance started Total System Global Area 8388608000 bytes Fixed Size 2109640 bytes Variable Size 5117054776 bytes Database Buffers 3221225472 bytes Redo Buffers 48218112 bytes RMAN> 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-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=1084 devtype=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output filename=/home/oracle/orabase/oradata/ORACLE/control01.ctl output filename=/home/oracle/orabase/oradata/ORACLE/control02.ctl output filename=/home/oracle/orabase/oradata/ORACLE/control03.ctl Finished restore at 31-JUL-14 RMAN> alter database mount;database mounted released channel: ORA_DISK_1--------------------------------------------------------------------------------RMAN 配置归档日志删除策略Oracle基础教程之通过RMAN复制数据库RMAN备份策略制定参考内容RMAN备份学习笔记Oracle数据库备份加密 RMAN加密Linux-6-64下安装Oracle 12C笔记在CentOS 6.4下安装Oracle 11gR2(x64) Oracle 11gR2 在VMWare虚拟机中安装步骤Debian 下 安装 Oracle 11g XE R2--------------------------------------------------------------------------------RMAN> restore database;启动 restore 于 31-7月-14使用通道 ORA_DISK_1创建数据文件 fno = 1 名称 = /home/oracle/orabase/oradata/ORACLE/system01.dbf MAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: restore 命令 (在 07/31/2014 12:06:00 上) 失败ORA-01180: 无法创建数据文件 1 ORA-01110: 数据文件 1: '/home/oracle/orabase/oradata/ORACLE/system01.dbf'RMAN>RMAN> crosscheck backupset;Starting implicit crosscheck backup at 31-JUL-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=1084 devtype=DISK Crosschecked 10 objects Finished implicit crosscheck backup at 31-JUL-14 Starting implicit crosscheck copy at 31-JUL-14 using channel ORA_DISK_1 Finished implicit crosscheck copy at 31-JUL-14 searching for all files in the recovery area cataloging 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_.arc File Name: /home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp using channel ORA_DISK_1 crosschecked 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=854156234 crosschecked 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=854158551 crosschecked 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=854242543 crosschecked 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=854242673 crosschecked 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=854244910 crosschecked 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=854328882 crosschecked 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=854329003 crosschecked 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=854331139 crosschecked 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=854373190 Crosschecked 9 objects由于备份集过期导致无法还原数据库，重新注册备份片。
RMAN> catalog backuppiece '/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak';cataloged backuppiece backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756 RMAN> catalog backuppiece '/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak';cataloged backuppiece backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783 RMAN> catalog backuppiece '/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak';cataloged backuppiece backup 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_1 channel ORA_DISK_1: sid=1087 devtype=DISK crosschecked 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=854156234 crosschecked 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=854158551 crosschecked 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=854242543 crosschecked 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=854242673 crosschecked 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=854244910 crosschecked 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=854373756 crosschecked 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=854373783 crosschecked 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=854373809 crosschecked 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=854373190 Crosschecked 9 objects还原数据库RMAN> restore database;恢复数据库到指定序列。
RMAN> recover database until sequence 13908恢复结束后，，启动数据库。
RMAN> alter database open resetlogs