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

共计 1112 个字符，预计需要花费 3 分钟才能阅读完成。

RMAN> restore database;

Starting restore at 2017-03-02 12:03:05

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=4269 instance=cqdb device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=4366 instance=cqdb device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=4463 instance=cqdb device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=4560 instance=cqdb device type=DISK

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

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

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

RMAN-03002: failure of restore command at 03/02/2017 12:03:07

RMAN-06026: some targets not found – aborting restore

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

RMAN>

还原数据库时报 RMAN-06023 no backup or copy of datafile 16 found to restore, 使用 list backup 命令查看指定文件所在备份集。

RMAN> list backup of datafile 16;

specification does not match any backup in the repository

RMAN>

没有匹配的备份集，应该是备份不完整因此无法还原。

更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址 ：http://www.linuxidc.com/Linux/2017-03/141354.htm