温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

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

发布时间:2020-07-09 12:55:04 来源:网络 阅读:937 作者:jason_125 栏目:关系型数据库

[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


向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI