1 故障现象

在Oracle 19c中使用rman 备份DB，脚本如下：

RMAN 备份 shell 脚本
https://www.cndba.cn/dave/article/131676

http://www.cndba.cn/dave/article/131678

http://www.cndba.cn/dave/article/131678

报如下错误：http://www.cndba.cn/dave/article/131678http://www.cndba.cn/dave/article/131678

Starting Control File and SPFILE Autobackup at 2025:07:0411:03:36
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 07/04/2025 11:03:37
ORA-01264: Unable to create control file autobackup file name
ORA-19800: Unable to initialize Oracle Managed Destination
Linux-x86_64 Error: 13: Permission denied

2 解决方法

这里和2个地方的配置有关系，一个是控制文件和spfile 的自动备份，这个模式启用的：

RMAN> show all;

RMAN configuration parameters for database with db_unique_name CNDBA are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u03/app/oracle/product/19.3.0/dbhome_1/dbs/snapcf_cndba.f'; # default

而默认的存储路径是FRA目录：

SQL> select name from V$RECOVERY_FILE_DEST;

NAME
--------------------------------------------------------------------------------
/u01/archivelog

恰好我们的19c 用户没有这个权限，因此这里有两种方法：http://www.cndba.cn/dave/article/131678

1.更改FRA 路径：

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u03/archivelog' SCOPE=BOTH;
System altered.
SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST;

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
db_recovery_file_dest                string                            /u03/archivelog
db_recovery_file_dest_size           big integer                       20G
SQL>

2.修改rman的配置参数：

RMAN> SHOW CONTROLFILE AUTOBACKUP FORMAT;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/archivelog/%F';

版权声明：本文为博主原创文章，未经博主允许不得转载。