ORACLE RAC集群 RMAN自动备份controlfile失败之ORA-00245&ORA-27037

本文涉及的产品
云原生数据仓库AnalyticDB MySQL版,8核32GB 100GB 1个月
简介:     近期oracle数据库巡检中,广州汕头一RAC集群有告警日志显示RMAN自动备份控制文件失败,原因是控制文件自动备份打开并且备份目录在本地,涉及的备份目录只在节点2上有,而在节点1上没有,导致控制文件自动备份失败!     操作系统:RHEL6.
    近期oracle数据库巡检中,广州汕头一RAC集群有告警日志显示RMAN自动备份控制文件失败,原因是控制文件自动备份打开并且备份目录在本地,涉及的备份目录只在节点2上有,而在节点1上没有,导致控制文件自动备份失败!
    操作系统:RHEL6.7
    数据库版本:11.2.0.4
    告警日志信息:
    节点1:
Fri Jan 06 20:04:06 2017
Control file backup creation failed:
  failure to open backup target file /u01/app/oracle/product/11.2.0/dbs/snapcf_orcl2.f.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ckpt_35202.trc:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
[oracle@rac01 trace]$ more  /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ckpt_35202.trc
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ckpt_35202.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0
System name:    Linux
Node name:      rac01
Release:        4.1.12-37.4.1.el6uek.x86_64
Version:        #2 SMP Tue May 17 07:23:38 PDT 2016
Machine:        x86_64
Instance name: orcl1
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 35202, image: oracle@rac01 (CKPT)
*** 2016-09-21 22:04:41.855
*** SESSION ID:(153.1) 2016-09-21 22:04:41.855
*** CLIENT ID:() 2016-09-21 22:04:41.855
*** SERVICE NAME:(SYS$BACKGROUND) 2016-09-21 22:04:41.855
*** MODULE NAME:() 2016-09-21 22:04:41.855
*** ACTION NAME:() 2016-09-21 22:04:41.855
Redo thread 2 internally enabled
Control file enqueue hold time tracking dump at time: 5304

    节点2:
[oracle@rac02 trace]$ 
Fri Jan 06 20:04:06 2017
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_63100.trc:
ORA-00245: control file backup failed; target is likely on a local file system
[oracle@rac02 trace]$ more  /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_63100.trc
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_63100.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0
System name:    Linux
Node name:      rac02
Release:        4.1.12-37.4.1.el6uek.x86_64
Version:        #2 SMP Tue May 17 07:23:38 PDT 2016
Machine:        x86_64
Instance name: orcl2
Redo thread mounted by this instance: 2
Oracle process number: 67
Unix process pid: 63100, image: oracle@rac02 (TNS V1-V3)
*** 2017-01-06 20:04:06.406
*** SESSION ID:(288.7239) 2017-01-06 20:04:06.406
*** CLIENT ID:() 2017-01-06 20:04:06.406
*** SERVICE NAME:(SYS$USERS) 2017-01-06 20:04:06.406
*** MODULE NAME:(backup archivelog) 2017-01-06 20:04:06.406
*** ACTION NAME:(0000096 STARTED111) 2017-01-06 20:04:06.406
Starting control autobackup
ORA-00245: control file backup failed; target is likely on a local file system
Got error: 245
Autobackup failed with following error
ORA-00245: control file backup failed; target is likely on a local file system
    查看集群控制文件位置(集群控制文件应该在共享存储,如果不在共享存储可能备份控制文件会失败)
[oracle@rac02 trace]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 9 14:10:24 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select * from v$controlfile;
STATUS   NAME                                                                              IS_ BLOCK_SIZE FILE_SIZE_BLKS
-------      --------------------------------------------------------------------------------       --- ---------- --------------
          +DATA01/orcl/controlfile/current.260.923176917                          NO       16384           3384
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@rac02 trace]$
    在1节点尝试备份控制文件
[oracle@rac01 trace]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 9 14:14:57 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1450957652)
RMAN> backup current controlfile;
Starting backup at 2017-01-09 14:15:12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=462 instance=orcl1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2017-01-09 14:15:14
channel ORA_DISK_1: finished piece 1 at 2017-01-09 14:15:15
piece handle=/u01/app/oracle/product/11.2.0/dbs/i5rpjijh_1_1 tag=TAG20170109T141513 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-01-09 14:15:15
Starting Control File and SPFILE Autobackup at 2017-01-09 14:15:15
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 01/09/2017 14:15:16
ORA-19504: failed to create file "/u01/backup/data/c-1450957652-20170109-01 "
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
    查看rman备份设置(看到的备份设置是备份集群控制文件到本地)
[oracle@rac02 trace]$ rman target /
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 7 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 ' /u01 /backup/data/%F';
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/11.2.0/db_1/dbs/snapcf_orcl.f'; # default
RMAN> 
    查看节点1的备份目录是否存在(果然,节点2存放的备份,备份目录一定存在,而节点1上没有创建备份目录):
[oracle@rac01 ~]$ cd /u01/backup/data
-bash: cd: /u01/backup/data: No such file or directory
[oracle@rac01 ~]$
    节点1上创建备份目录并赋予权限:
[root@rac01 u01]# mkdir -p backup/data
[root@rac01 u01]# ls -l
total 36
drwxr-xr-x. 6 root   oinstall  4096 Sep 21 20:00 app
drwxr-xr-x  3 root   root      4096 Jan  9 14:18 backup
drwxrwxr-x  7 oracle oinstall  4096 Sep 21 22:00 database
drwxrwxrwx  2 oracle oinstall  4096 Sep 22 02:52 dump
drwxrwxr-x  7 oracle oinstall  4096 Aug 27  2013 grid
drwxrwxr-x. 2 oracle oinstall 16384 Sep 21 18:53 lost+found
[root@rac01 u01]# chown -R oracle:oinstall backup
[root@rac01 u01]# chmod -R 777 backup
[root@rac01 u01]# ls -l
total 36
drwxr-xr-x. 6 root   oinstall  4096 Sep 21 20:00 app
drwxrwxrwx  3 oracle oinstall  4096 Jan  9 14:18 backup
drwxrwxr-x  7 oracle oinstall  4096 Sep 21 22:00 database
drwxrwxrwx  2 oracle oinstall  4096 Sep 22 02:52 dump
drwxrwxr-x  7 oracle oinstall  4096 Aug 27  2013 grid
drwxrwxr-x. 2 oracle oinstall 16384 Sep 21 18:53 lost+found
[root@rac01 u01]#
    在1节点重新尝试备份控制文件(成功了):
[oracle@rac01 trace]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 9 14:22:50 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1450957652)
RMAN>  backup current controlfile;
Starting backup at 2017-01-09 14:19:43
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2017-01-09 14:19:44
channel ORA_DISK_1: finished piece 1 at 2017-01-09 14:19:45
piece handle=/u01/app/oracle/product/11.2.0/dbs/i7rpjirv_1_1 tag=TAG20170109T141943 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-01-09 14:19:45
Starting Control File and SPFILE Autobackup at 2017-01-09 14:19:45
piece handle= /u01/backup/data/c-1450957652-20170109-02 comment=NONE
Finished Control File and SPFILE Autobackup at 2017-01-09 14:19:46

RMAN> list backup of controlfile;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1501    Full    52.95M     DISK        00:00:01     2017-01-01 20:01:15
        BP Key: 1501   Status: AVAILABLE  Compressed: NO  Tag: TAG20170101T200114
        Piece Name: /u01/backup/data/c-1450957652-20170101-00
  Control File Included: Ckp SCN: 143516927    Ckp time: 2017-01-01 20:01:14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1506    Full    52.95M     DISK        00:00:01     2017-01-02 20:01:11
        BP Key: 1506   Status: AVAILABLE  Compressed: NO  Tag: TAG20170102T200110
        Piece Name: /u01/backup/data/c-1450957652-20170102-00
  Control File Included: Ckp SCN: 144147774    Ckp time: 2017-01-02 20:01:10


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1555    Full    52.95M     DISK        00:00:00     2017-01-03 20:20:26
        BP Key: 1555   Status: AVAILABLE  Compressed: NO  Tag: TAG20170103T202026
        Piece Name: /u01/backup/data/c-1450957652-20170103-00
  Control File Included: Ckp SCN: 155236810    Ckp time: 2017-01-03 20:20:26


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1566    Full    52.95M     DISK        00:00:01     2017-01-05 20:03:16
        BP Key: 1566   Status: AVAILABLE  Compressed: NO  Tag: TAG20170105T200315
        Piece Name: /u01/backup/data/c-1450957652-20170105-00
  Control File Included: Ckp SCN: 157603651    Ckp time: 2017-01-05 20:03:15


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1586    Full    52.95M     DISK        00:00:01     2017-01-07 01:29:12
        BP Key: 1586   Status: AVAILABLE  Compressed: NO  Tag: TAG20170107T012911
        Piece Name: /u01/backup/data/c-1450957652-20170107-00
  Control File Included: Ckp SCN: 161699766    Ckp time: 2017-01-07 01:29:11


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1591    Full    52.95M     DISK        00:00:01     2017-01-07 20:01:11
        BP Key: 1591   Status: AVAILABLE  Compressed: NO  Tag: TAG20170107T200110
        Piece Name: /u01/backup/data/c-1450957652-20170107-01
  Control File Included: Ckp SCN: 162284897    Ckp time: 2017-01-07 20:01:10


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1596    Full    52.95M     DISK        00:00:01     2017-01-08 20:01:21
        BP Key: 1596   Status: AVAILABLE  Compressed: NO  Tag: TAG20170108T200120
        Piece Name: /u01/backup/data/c-1450957652-20170108-00
  Control File Included: Ckp SCN: 162881404    Ckp time: 2017-01-08 20:01:20


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1597    Full    52.92M     DISK        00:00:01     2017-01-09 10:52:12
        BP Key: 1597   Status: AVAILABLE  Compressed: NO  Tag: TAG20170109T105211
        Piece Name: /u01/app/oracle/product/11.2.0/dbs/i3rpj6mr_1_1
  Control File Included: Ckp SCN: 163348183    Ckp time: 2017-01-09 10:52:11


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1598    Full    52.95M     DISK        00:00:00     2017-01-09 10:52:13
        BP Key: 1598   Status: AVAILABLE  Compressed: NO  Tag: TAG20170109T105213
        Piece Name: /u01/backup/data/c-1450957652-20170109-00
  Control File Included: Ckp SCN: 163348190    Ckp time: 2017-01-09 10:52:13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1599    Full    52.92M     DISK        00:00:01     2017-01-09 14:15:14
        BP Key: 1599   Status: AVAILABLE  Compressed: NO  Tag: TAG20170109T141513
        Piece Name: /u01/app/oracle/product/11.2.0/dbs/i5rpjijh_1_1
  Control File Included: Ckp SCN: 163446650    Ckp time: 2017-01-09 14:15:13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1600    Full    52.92M     DISK        00:00:01     2017-01-09 14:19:44
        BP Key: 1600   Status: AVAILABLE  Compressed: NO  Tag: TAG20170109T141943
        Piece Name: /u01/app/oracle/product/11.2.0/dbs/i7rpjirv_1_1
  Control File Included: Ckp SCN: 163447041    Ckp time: 2017-01-09 14:19:43


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
1601    Full    52.95M     DISK        00:00:00     2017-01-09 14:19:45
        BP Key: 1601   Status: AVAILABLE  Compressed: NO  Tag: TAG20170109T141945
        Piece Name: /u01/backup/data/c-1450957652-20170109-02
  Control File Included: Ckp SCN: 163447048    Ckp time: 2017-01-09 14:19:45
RMAN> quit

Recovery Manager complete.
[oracle@rac01 trace]$ 






相关实践学习
数据库实验室挑战任务-初级任务
本场景介绍如何开通属于你的免费云数据库,在RDS-MySQL中完成对学生成绩的详情查询,执行指定类型SQL。
阿里云云原生数据仓库AnalyticDB MySQL版 使用教程
云原生数据仓库AnalyticDB MySQL版是一种支持高并发低延时查询的新一代云原生数据仓库,高度兼容MySQL协议以及SQL:92、SQL:99、SQL:2003标准,可以对海量数据进行即时的多维分析透视和业务探索,快速构建企业云上数据仓库。 了解产品 https://www.aliyun.com/product/ApsaraDB/ads
目录
相关文章
|
1天前
|
Oracle 关系型数据库 数据库
|
5天前
|
存储 监控 Oracle
关系型数据库Oracle备份策略建议
【7月更文挑战第21天】
15 6
|
5天前
|
存储 Oracle 关系型数据库
|
5天前
|
运维 Oracle 关系型数据库
关系型数据库Oracle自动化备份
【7月更文挑战第21天】
15 3
|
6天前
|
存储 SQL Oracle
关系型数据库Oracle归档日志备份
【7月更文挑战第19天】
26 5
|
4天前
|
Oracle 关系型数据库 数据库连接
|
6天前
|
SQL Oracle 关系型数据库
关系型数据库Oracle备份工具
【7月更文挑战第19天】
23 4
|
5天前
|
存储 Oracle 安全
关系型数据库Oracle备份频率
【7月更文挑战第20天】
15 2
|
5天前
|
存储 Oracle 关系型数据库
关系型数据库Oracle备份策略
【7月更文挑战第20天】
15 2
|
6天前
|
存储 Oracle 关系型数据库
关系型数据库Oracle差异备份
【7月更文挑战第19天】
20 3