1、背景
对客户主生产业务系统进行巡检，在对备份日志检查的时候发现在全库备份日志之后出现一个ORA-00245的报错发生，具体报错如下：
Starting Control File and SPFILE Autobackup at 2023-03-20 01:35:07
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on c1 channel at 03/20/2023 01:35:08
ORA-00245: control file backup failed; target is likely on a local file system
RMAN>
RMAN>
Recovery Manager complete.
报错内容为控制文件备份失败，备份目的地可能在一个本地文件系统，截图如下：
2、分析
客户的生产环境是一套rac 11g环境，控制文件快照备份设置到可单节点本地导致其他实例无法写入快照文件，故此报错发生，查看Rman参数设置如下：
[oracle@xiaozc:/home/xiaozc]$rman target /
Recovery Manager: Release 11.2.0.4.0 – Production on Mon Mar 20 10:13:39 2023
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: xiaozc (DBID=1378664591)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name XIAOZC are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/home/xiaozc/%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11g/dbhome_1/dbs/snapcf_xiaozc1.f’; # default
可以看到，设置的控制文件快照备份路径为节点1本地。
3、修改参数
将控制文件快照备份的位置更改到共享存储ASM磁盘位置，如下：
RMAN> configure snapshot controlfile name to ‘+ARCH/xiaozc/archivelog/snapcf_wxyyhis1.f’;
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+ARCH/xiaozc/archivelog/snapcf_wxyyhis1.f’;
new RMAN configuration parameters are successfully stored
4、查看新配置
在两个节点上看到位置都更改到了共享存储位置，如图：
至此，ora-00245报错处理完成。
服务器托管，北京服务器托管，服务器租用 http://www.fwqtg.net
机房租用，北京机房租用，IDC机房托管， http://www.e1idc.net
