重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 343|回复: 0

[备份恢复] 爱数备份软件备份报ORA-00245问题

[复制链接]
发表于 2024-5-16 11:12:39 | 显示全部楼层 |阅读模式
本帖最后由 jiawang 于 2024-5-16 13:56 编辑

问题现象:
在使用 AnyBackup 管理控制台发起 Oracle RAC 数据库备份后,在任务历史记录 > 执行输出中显示如下错误信息:
ora-00245:control file backup failed; in Oracle RAC, target might not be on shared storage.
orotrol file backup failed; in Oracle RAC, target is likely on a local file system .
64208664578e09c3ff.png

查看控制文件快照位置节点1:
[oracle@xd1dbadm01 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 16 10:41:01 2024
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: YDHLGL (DBID=879094270)

RMAN> show snapshot controlfile name;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.12.0.0/dbhome_1/dbs/snapcf_ydhlgl1.f'; # default

节点2:
[oracle@xd1dbadm02 dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 16 10:47:38 2024
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: YDHLGL (DBID=879094270)

RMAN> show snapshot controlfile name;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO  '/u01/app/oracle/product/19.12.0.0/dbhome_1/dbs/snapcf_ydhlgl2.f'; # default


RAC修改snapshot controlfile 参数
在其中一节点下进行参数修改CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';

具体语句:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
new RMAN configuration parameters are successfully stored

RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';

节点2确认参数信息:
[oracle@xd1dbadm02 dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 16 10:47:38 2024
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: YDHLGL (DBID=879094270)

RMAN> show snapshot controlfile name;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';


字典表确认以及测试
select * from V$RMAN_CONFIGURATION


   CONF# NAME                           VALUE                                        CON_ID
---------- ------------------------------ ---------------------------------------- ----------
         1 BACKUP OPTIMIZATION            OFF                                               0
         2 SNAPSHOT CONTROLFILE NAME      TO '+RECO/YDHLGL/snapcf_ydhlgl.f'                 0

在 AnyBackup 控制台重新发起备份任务进行测试。












回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-6-25 18:06 , Processed in 0.111817 second(s), 24 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表