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> 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

相关推荐