有套3节点的11204集群环境,在db2上配置了rman备份,今天例行检查时发现db1和db3上不定期有报错,报错如下:
Control file backup creation failed:
failure to open backup target file /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl2.f.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ckpt_20126.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
查看rman备份的log时偶尔有报错如下
Starting Control File and SPFILE Autobackup at 08-AUG-25
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on d1 channel at 08/08/2025 01:25:18
ORA-00245: control file backup failed; target is likely on a local file system
Recovery Manager complete.
rman配置已把SNAPSHOT CONTROLFILE配置成共享路径了
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
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 '/backup/orcl/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/ORCL/CONTROLFILE/snapcf_orcl.f';
每天都备份,报错是偶发情况,暂还不明白咋回事,把CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/ORCL/CONTROLFILE/snapcf_orcl.f';重新又执行一次,持续观察