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

2014-11-24 17:15:54 · 作者: · 浏览: 1
ckup 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