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
本文永久更新链接地址：