爱数备份软件备份报ORA-00245问题

jiawang

问题现象：
在使用 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 .


查看控制文件快照位置节点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 控制台重新发起备份任务进行测试。