iis服务器助手广告广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >RMAN 备份，no backup of copy of datafile
  • 308

0
分享到

RMAN 备份，no backup of copy of datafile

2024-04-02 19:04:59 308人浏览 薄情痞子
摘要

在RMAN 异机恢复过程中，我第一做了一个不完全恢复，，然后再恢复的时候提示一下错误：Starting restore at 29-DEC-15using channel ORA_DISK_1RMAN-00

在RMAN 异机恢复过程中，我第一做了一个不完全恢复，，然后再恢复的时候提示一下错误：

Starting restore at 29-DEC-15

using channel ORA_DISK_1


RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 12/29/2015 16:56:34

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 4 found to restore

RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 2 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore


检查备份文件，发现都是存在的，根本没有问题。最后检查发现是incarnation的问题，因为中间我对该数据库做了一次不完全恢复，做了resetlogs操作。

解决办法：

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       CWERPDB  490184294        PARENT  1          24-AUG-13

2       2       CWERPDB  490184294        PARENT  925702     27-JUL-15

3       3       CWERPDB  490184294        CURRENT 12939483587242 24-DEC-15

RMAN> reset database to incarnation 2;


database reset to incarnation 2


 run

{set newname for datafile 4 to "/home/u01/oracle/oradata/CWERPDB/users.259.886161065";

set newname for datafile 3 to "/home/u01/oracle/oradata/CWERPDB/undotbs1.258.886161065";

set newname for datafile 2 to "/home/u01/oracle/oradata/CWERPDB/sysaux.257.886161065";

set newname for datafile 1 to "/home/u01/oracle/oradata/CWERPDB/system.256.886161065";

set newname for datafile 5 to "/home/u01/oracle/oradata/CWERPDB/proframe.dbf";

set newname for datafile 6 to "/home/u01/oracle/oradata/CWERPDB/proframe01.dbf";

set newname for datafile 7 to "/home/u01/oracle/oradata/CWERPDB/cosmos_in01.dbf";

set newname for datafile 8 to "/home/u01/oracle/oradata/CWERPDB/cosmos_in02.dbf";

set newname for datafile 9 to "/home/u01/oracle/oradata/CWERPDB/cosmos_in03.dbf";

set newname for datafile 10 to "/home/u01/oracle/oradata/CWERPDB/cosmos01.dbf";

set newname for datafile 11 to "/home/u01/oracle/oradata/CWERPDB/cosmos02.dbf";

set newname for datafile 12 to "/home/u01/oracle/oradata/CWERPDB/cosmos03.dbf";

set newname for datafile 13 to "/home/u01/oracle/oradata/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01.DBF";

set newname for datafile 14 to "/home/u01/oracle/oradata/CWERPDB/statlog.dbf";

restore database;

3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> switch datafile all;}


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


Starting restore at 29-DEC-15

using channel ORA_DISK_1


channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00008 to /home/u01/oracle/oradata/CWERPDB/cosmos_in02.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3iqq1v45_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3iqq1v45_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:35

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00009 to /home/u01/oracle/oradata/CWERPDB/cosmos_in03.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3jqq1v45_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3jqq1v45_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:35

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00010 to /home/u01/oracle/oradata/CWERPDB/cosmos01.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3kqq1v48_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3kqq1v48_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:45

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00011 to /home/u01/oracle/oradata/CWERPDB/cosmos02.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3lqq1v48_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3lqq1v48_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:35

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00012 to /home/u01/oracle/oradata/CWERPDB/cosmos03.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3MQq1v4n_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3mqq1v4n_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:05

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00007 to /home/u01/oracle/oradata/CWERPDB/cosmos_in01.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3oqq1v4v_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3oqq1v4v_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:05

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00005 to /home/u01/oracle/oradata/CWERPDB/proframe.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3nqq1v4n_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3nqq1v4n_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:07:05

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00006 to /home/u01/oracle/oradata/CWERPDB/proframe01.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3pqq1v52_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3pqq1v52_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:06:25

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /home/u01/oracle/oradata/CWERPDB/system.256.886161065

channel ORA_DISK_1: restoring datafile 00002 to /home/u01/oracle/oradata/CWERPDB/sysaux.257.886161065

channel ORA_DISK_1: restoring datafile 00003 to /home/u01/oracle/oradata/CWERPDB/undotbs1.258.886161065

channel ORA_DISK_1: restoring datafile 00004 to /home/u01/oracle/oradata/CWERPDB/users.259.886161065

channel ORA_DISK_1: restoring datafile 00013 to /home/u01/oracle/oradata/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01.DBF

channel ORA_DISK_1: restoring datafile 00014 to /home/u01/oracle/oradata/CWERPDB/statlog.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/data_3qqq1vfr_1_1.bak

channel ORA_DISK_1: piece handle=/home/oracle/level0/data_3qqq1vfr_1_1.bak tag=DB0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:15

Finished restore at 29-DEC-15


datafile 1 switched to datafile copy

input datafile copy RECID=15 STAMP=899746532 file name=/home/u01/oracle/oradata/CWERPDB/system.256.886161065

datafile 2 switched to datafile copy

input datafile copy RECID=16 STAMP=899746532 file name=/home/u01/oracle/oradata/CWERPDB/sysaux.257.886161065

datafile 3 switched to datafile copy

input datafile copy RECID=17 STAMP=899746532 file name=/home/u01/oracle/oradata/CWERPDB/undotbs1.258.886161065

datafile 4 switched to datafile copy

input datafile copy RECID=18 STAMP=899746532 file name=/home/u01/oracle/oradata/CWERPDB/users.259.886161065

datafile 5 switched to datafile copy

input datafile copy RECID=19 STAMP=899746532 file name=/home/u01/oracle/oradata/CWERPDB/proframe.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=20 STAMP=899746532 file name=/home/u01/oracle/oradata/CWERPDB/proframe01.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=21 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos_in01.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=22 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos_in02.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=23 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos_in03.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=24 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos01.dbf

datafile 11 switched to datafile copy

input datafile copy RECID=25 STAMP=899746533 file name=/home/u01/oracle/oradata/CWERPDB/cosmos02.dbf

datafile 12 switched to datafile copy

input datafile copy RECID=26 STAMP=899746534 file name=/home/u01/oracle/oradata/CWERPDB/cosmos03.dbf

datafile 13 switched to datafile copy

input datafile copy RECID=27 STAMP=899746534 file name=/home/u01/oracle/oradata/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01.DBF

datafile 14 switched to datafile copy

input datafile copy RECID=28 STAMP=899746534 file name=/home/u01/oracle/oradata/CWERPDB/statlog.dbf


RMAN> alter database open;


RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 12/29/2015 17:36:35

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


RMAN> alter database open resetlogs;


RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 12/29/2015 17:36:42

ORA-01152: file 5 was not restored from a sufficiently old backup 

ORA-01110: data file 5: '/home/u01/oracle/oradata/CWERPDB/proframe.dbf'


RMAN> recover database;


Starting recover at 29-DEC-15

using channel ORA_DISK_1


starting media recovery


channel ORA_DISK_1: starting arcHived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=2710

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/arc_CWERPDBx_20151229_3tqq1vj0_1_1

channel ORA_DISK_1: piece handle=/home/oracle/level0/arc_CWERPDBx_20151229_3tqq1vj0_1_1 tag=TAG20151229T164208

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/home/u01/oracle/fast_recovery_area/CWERPDB/CWERPDB/archivelog/2015_12_29/o1_mf_1_2710_c84o213s_.arc thread=1 sequence=2710

channel default: deleting archived log(s)

archived log file name=/home/u01/oracle/fast_recovery_area/CWERPDB/CWERPDB/archivelog/2015_12_29/o1_mf_1_2710_c84o213s_.arc RECID=2730 STAMP=899746625

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=2711

channel ORA_DISK_1: reading from backup piece /home/oracle/level0/arc_CWERPDBx_20151229_3uqq1vj0_1_1

channel ORA_DISK_1: piece handle=/home/oracle/level0/arc_CWERPDBx_20151229_3uqq1vj0_1_1 tag=TAG20151229T164208

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

archived log file name=/home/u01/oracle/fast_recovery_area/CWERPDB/CWERPDB/archivelog/2015_12_29/o1_mf_1_2711_c84o23Go_.arc thread=1 sequence=2711

channel default: deleting archived log(s)

archived log file name=/home/u01/oracle/fast_recovery_area/CWERPDB/CWERPDB/archivelog/2015_12_29/o1_mf_1_2711_c84o23go_.arc RECID=2731 STAMP=899746627

unable to find archived log

archived log thread=1 sequence=2712

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 12/29/2015 17:37:09

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 2712 and starting SCN of 12939484174407


RMAN> alter database open resetlogs;


database opened


您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: RMAN 备份，no backup of copy of datafile

本文链接: https://www.lsjlt.com/news/39924.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
软考高级职称资格查询
iis服务器助手广告
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作