RError.com

RError.com Logo RError.com Logo

RError.com Navigation

  • 主页

Mobile menu

Close
  • 主页
  • 系统&网络
    • 热门问题
    • 最新问题
    • 标签
  • Ubuntu
    • 热门问题
    • 最新问题
    • 标签
  • 帮助
主页 / 问题 / 882729
Accepted
Viktorov
Viktorov
Asked:2020-09-18 22:25:19 +0000 UTC2020-09-18 22:25:19 +0000 UTC 2020-09-18 22:25:19 +0000 UTC

RMAN-05579:从备份还原数据库时找不到 CONTROLFILE 备份

  • 772

我有一个用 RMAN 创建的备份。脚本:

connect target /
shutdown immediate;
startup mount;
run{
allocate channel d1 type disk;
backup full format 'D:\Databases\Backups\02.RMAN_BKP\bkp__%d_%U.bus'
database;
}
startup;
exit;

结论:

connected to target database: DO_ETLN (DBID=4267723674)

using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area    2254802944 bytes

Fixed Size                     2283224 bytes
Variable Size                587204904 bytes
Database Buffers            1644167168 bytes
Redo Buffers                  21147648 bytes

allocated channel: d1
channel d1: SID=63 device type=DISK

Starting backup at 18-SEP-18
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00004 name=D:\DATABASES\DO_ETLN\BD\USERS01.DBF
input datafile file number=00005 name=D:\DATABASES\DO_ETLN\BD\INDEXES01.DBF
input datafile file number=00002 name=D:\DATABASES\DO_ETLN\BD\SYSAUX01.DBF
input datafile file number=00001 name=D:\DATABASES\DO_ETLN\BD\SYSTEM01.DBF
input datafile file number=00003 name=D:\DATABASES\DO_ETLN\BD\UNDOTBS01.DBF
input datafile file number=00006 name=D:\DATABASES\DO_ETLN\BD\LOB_TS_01.DBF
input datafile file number=00007 name=D:\DATABASES\DO_ETLN\BD\REPOSITORY_BO_01.DBF
input datafile file number=00008 name=D:\DATABASES\DO_ETLN\BD\TOOLS_01.DBF
channel d1: starting piece 1 at 18-SEP-18
channel d1: finished piece 1 at 18-SEP-18
piece handle=D:\DATABASES\BACKUPS\02.RMAN_BKP\BKP__DO_ETLN_01TDECMD_1_1.BUS tag=TAG20180918T170933 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:05
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel d1: starting piece 1 at 18-SEP-18
channel d1: finished piece 1 at 18-SEP-18
piece handle=D:\DATABASES\BACKUPS\02.RMAN_BKP\BKP__DO_ETLN_02TDECOF_1_1.BUS tag=TAG20180918T170933 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-SEP-18
released channel: d1

database is already started
database opened

Recovery Manager complete.

我正在尝试将其还原到新创建的数据库。脚本:

connect auxiliary / 
run{ 
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
allocate auxiliary channel aux4 device type disk;
SET NEWNAME FOR DATABASE TO 'D:\Databases\DODEVT\%b'; 
DUPLICATE TARGET DATABASE TO DODEVT
backup location '"D:\Databases\Backups\02.RMAN_BKP"' NOREDO
logfile
   group 1 ('D:\Databases\DODEVT\redo01.log') size 50M reuse,
   group 2 ('D:\Databases\DODEVT\redo02.log') size 50M reuse,
   group 3 ('D:\Databases\DODEVT\redo03.log') size 50M reuse;
}
exit;

我收到一个错误:

connected to auxiliary database: DODEVT2 (not mounted)

allocated channel: aux1
channel aux1: SID=63 device type=DISK

allocated channel: aux2
channel aux2: SID=129 device type=DISK

allocated channel: aux3
channel aux3: SID=193 device type=DISK

allocated channel: aux4
channel aux4: SID=6 device type=DISK

executing command: SET NEWNAME

Starting Duplicate Db at 18-SEP-18
released channel: aux1
released channel: aux2
released channel: aux3
released channel: aux4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/18/2018 17:11:47
RMAN-05501: aborting duplication of target database
RMAN-05579: CONTROLFILE backup not found in "D:\Databases\Backups\02.RMAN_BKP"

Recovery Manager complete.
db dublicated

控制文件似乎包含在我的备份中,但 RMAN 说它不存在。告诉我我错过了什么?

oracle
  • 1 1 个回答
  • 10 Views

1 个回答

  • Voted
  1. Best Answer
    Viktorov
    2020-09-18T23:13:57Z2020-09-18T23:13:57Z

    错误是我的生成脚本在路径中添加了双引号,而 RMAN 而不是错误的路径告诉我,这条路径根本没有控制文件。

    它是:

    backup location '"D:\Databases\Backups\02.RMAN_BKP"' NOREDO
    

    应该:

    backup location 'D:\Databases\Backups\02.RMAN_BKP' NOREDO
    
    • 0

相关问题

Sidebar

Stats

  • 问题 10021
  • Answers 30001
  • 最佳答案 8000
  • 用户 6900
  • 常问
  • 回答
  • Marko Smith

    是否可以在 C++ 中继承类 <---> 结构?

    • 2 个回答
  • Marko Smith

    这种神经网络架构适合文本分类吗?

    • 1 个回答
  • Marko Smith

    为什么分配的工作方式不同?

    • 3 个回答
  • Marko Smith

    控制台中的光标坐标

    • 1 个回答
  • Marko Smith

    如何在 C++ 中删除类的实例?

    • 4 个回答
  • Marko Smith

    点是否属于线段的问题

    • 2 个回答
  • Marko Smith

    json结构错误

    • 1 个回答
  • Marko Smith

    ServiceWorker 中的“获取”事件

    • 1 个回答
  • Marko Smith

    c ++控制台应用程序exe文件[重复]

    • 1 个回答
  • Marko Smith

    按多列从sql表中选择

    • 1 个回答
  • Martin Hope
    Alexandr_TT 圣诞树动画 2020-12-23 00:38:08 +0000 UTC
  • Martin Hope
    Suvitruf - Andrei Apanasik 什么是空? 2020-08-21 01:48:09 +0000 UTC
  • Martin Hope
    Air 究竟是什么标识了网站访问者? 2020-11-03 15:49:20 +0000 UTC
  • Martin Hope
    Qwertiy 号码显示 9223372036854775807 2020-07-11 18:16:49 +0000 UTC
  • Martin Hope
    user216109 如何为黑客设下陷阱,或充分击退攻击? 2020-05-10 02:22:52 +0000 UTC
  • Martin Hope
    Qwertiy 并变成3个无穷大 2020-11-06 07:15:57 +0000 UTC
  • Martin Hope
    koks_rs 什么是样板代码? 2020-10-27 15:43:19 +0000 UTC
  • Martin Hope
    Sirop4ik 向 git 提交发布的正确方法是什么? 2020-10-05 00:02:00 +0000 UTC
  • Martin Hope
    faoxis 为什么在这么多示例中函数都称为 foo? 2020-08-15 04:42:49 +0000 UTC
  • Martin Hope
    Pavel Mayorov 如何从事件或回调函数中返回值?或者至少等他们完成。 2020-08-11 16:49:28 +0000 UTC

热门标签

javascript python java php c# c++ html android jquery mysql

Explore

  • 主页
  • 问题
    • 热门问题
    • 最新问题
  • 标签
  • 帮助

Footer

RError.com

关于我们

  • 关于我们
  • 联系我们

Legal Stuff

  • Privacy Policy

帮助

© 2023 RError.com All Rights Reserve   沪ICP备12040472号-5