问题现象：
在使用 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
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2024-5-16 11:12:39
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对