oracle修改filesystem,ORA-00245:controlfilebackupfailed;targetislikelyonalocalfilesystem解决办法...

ORA-00245: control file backup failed; target is likely on a

local file system解决办法

1. 问题描述

警告日志报错如下：

Thu Feb 18 01:59:48 2016

Errors in

file/u01/PSPROD/oracle/diag/rdbms/psprod/PSPROD1/trace/PSPROD1_ora_45856.trc:

ORA-00245: control file backup failed;target is likely on a

local file system

Tue Feb 16 01:59:02 2016

Errors in

file/u01/PSPROD/oracle/diag/rdbms/psprod/PSPROD1/trace/PSPROD1_ora_88792.trc:

ORA-00245: control file backup failed;target is likely on a

local file system

2. 问题分析

本报错出现于oracle 11.2.0.1.0及以后的版本中，应用于所有平台

仅仅RAC环境会发生，非rac环境不需要考虑这个问题，因为11Gr2控制文件备份机制的改变，集群中的任何实例都要可以写入快照文件。

当然这个文件也就要对所有实例可见，所以这个快照文件要设置在共享设备上(asm磁盘组)。

我们现在看一下本机设置：

[oracle@jinhu-db01 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed May

23 09:34:57 2018

Copyright (c) 1982, 2011, Oracle and/or its

affiliates. All rights reserved.

connected to target database: ORCL (DBID=1497440586)

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 15

DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK

TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO

BACKUPSET; # default

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/11.2.0/db_1/dbs/snapcf_oracl11.f'; #

default

由上可见本机是默认的未进行修改过

因此会报245的错误

这里注意下本机报错为ORA-00245，但也可能报ora-245

所以在mos上搜索的时候最好报错内容也搜索下，否则可能找不到

3. 解决方案

修改rman备份配置，将控制文件快照定向到共享磁盘组

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO

'+RACDATA/ORCL/snapcf_orcl.f';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO

'+RACDATA/ORCL/snapcf_orcl.f';

new RMAN configuration parameters are successfully

stored

检查修改结果：

RMAN> show all;

RMAN configuration parameters for database with db_unique_name

ORCL are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15

DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK

TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO

BACKUPSET; # default

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

'+RACDATA/ORCL/snapcf_orcl.f';

注：只需要在RAC的一个节点上修改即可

!!The End!!