Oracle X9M ORA-15001 ORA-15018问题处理

数据库版本：Oracle Database 19.7

操作系统：Red Hat Enterpise Linux Server release 7.9（Maipo）

问题描述：数据库日志报 ORA-15001: diskgroup “DATA” does not exist or is not mounted和 ORA-15018: diskgroup cannot be created

问题原因： RMAN配置中 SNAPSHOT CONTROLFILE NAME设置的+DATA磁盘组不存在

解决方案： 重新进行RMAN的 SNAPSHOT CONTROLFILE NAME设置

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+DATAC1/snapcf_cdbcrm.f’;

分析过程：

1、检查数据库日志alert_cdbcrm1.log

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

...

DATA磁盘组不存在，磁盘组创建失败。

2、检查trace日志cdbcrm_m002-1977.trc

Version 19.7.0.0.0
Build label:    RDBMS_19.7.0.0.0DBRU_LINUX.X64_200403
ORACLE_HOME:    /u01/app/oracle/product/19.7.0.0/dbhome_1
System name: Linux
Node name: :bj9dbadm01.sh.com
Release: 4.14.35-2047.514.5.1.2.el7uek.x86_64
Version: #2 SMP Thu Jul 28 15:33:31 PDT 2022
Machine: x86_64
Storage: Exadata
Instance name: jxacctdb1
Redo thread mounted by this instance: 1
Oracle process number: 148
Unix process pid: 197778, image: :bj9dbadm01.sh.comm (M002)

...

*** 2022-12-02T11:44:15.546198+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:44:15.546228+08:00

*** ACTION NAME:(Intensive AutoTask Dispatcher) 2022-12-02T11:44:15.546232+08:00

*********** START A RUN OF [Intensive AutoTask Dispatcher] *************

*********** END A RUN *************

*** 2022-12-02T11:45:15.770130+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:45:15.770161+08:00

*** ACTION NAME:(KDILM background CLeaNup) 2022-12-02T11:45:15.770165+08:00 

*********** START A RUN OF [KDILM background CLeaNup] *************

*********** END A RUN *************

*** 2022-12-02T11:46:15.930394+08:00

*********** START A RUN OF [KDILM background CLeaNup] *************

*********** END A RUN *************

*** 2022-12-02T11:47:16.089940+08:00

*********** START A RUN OF [KDILM background CLeaNup] *************

*********** END A RUN *************

*** 2022-12-02T11:49:16.408540+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:49:16.408571+08:00

*** ACTION NAME:(Autobackup Control File) 2022-12-02T11:49:16.408575+08:00 

*********** START A RUN OF [Autobackup Control File] *************

2022-12-02 11:49:16.530 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.530 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.531 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.532 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.532 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.532 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.533 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.533 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.533 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.534 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.534 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.534 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.534 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.535 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.535 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.535 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.536 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.536 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.536 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.537 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.537 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.538 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.538 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.538 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.539 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.539 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.539 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.539 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.540 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.540 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.540 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.541 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.541 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.541 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.542 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.542 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.542 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.543 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

2022-12-02 11:49:16.543 :kfncTraceReturn(): call failed; [kfncGroupUse] flags=0x0

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mou

2022-12-02 11:49:16.543*:KRB:krbm.c@5636:krbmdabCbk(): ********************  WARNING **************************

The errors during server control file autobackup are not

fatal, as it is attempted after sucessful completion of

the command. However, it is recomended to take an RMAN

control file backup as soon as possible because the

autobackup failed with the following error:

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA"

********************  END OF WARNING *******************

<error barrier> at 0x7ffe276bc0a0 placed krbm.c@5998

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15018: diskgroup cannot be created

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA

*********** END A RUN *************
*** 2022-12-02T11:51:16.793893+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:51:16.793924+08:00

*** ACTION NAME:(KDILM background CLeaNup) 2022-12-02T11:51:16.793928+08:00 

*********** START A RUN OF [KDILM background CLeaNup] *************

*********** END A RUN *************

*** 2022-12-02T11:52:16.980931+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:52:16.980961+08:00

*** ACTION NAME:(Intensive AutoTask Dispatcher) 2022-12-02T11:52:16.980966+08:00 

*********** START A RUN OF [Intensive AutoTask Dispatcher] *************

*********** END A RUN *************

*** 2022-12-02T11:53:17.242807+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:53:17.242837+08:00

*** ACTION NAME:(Automatic Report Flush) 2022-12-02T11:53:17.242841+08:00

 

*********** START A RUN OF [Automatic Report Flush] *************

*********** END A RUN *************



*** 2022-12-02T11:54:17.563335+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:54:17.563362+08:00

*** ACTION NAME:(Intensive AutoTask Dispatcher) 2022-12-02T11:54:17.563366+08:00

 

*********** START A RUN OF [Intensive AutoTask Dispatcher] *************

*********** END A RUN *************

*********** START A RUN OF [KDILM background CLeaNup] *************



*** 2022-12-02T11:55:17.754230+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:55:17.754246+08:00

*** ACTION NAME:(KDILM background CLeaNup) 2022-12-02T11:55:17.754250+08:00

 

*********** END A RUN *************



*** 2022-12-02T11:56:17.913948+08:00

*** MODULE NAME:(MMON_SLAVE) 2022-12-02T11:56:17.913978+08:00

*** ACTION NAME:(KDILM background EXEcution) 2022-12-02T11:56:17.913983+08:00

...

从trace可以看到，数据库控制文件自动备份时kfncTraceReturn(): call failed，ORA-15001，ORA-15018。

3、检查ASM实例参数

+ASM2.__asm_max_connected_clients=8
+ASM1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
+ASM2.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
*.asm_diskgroups='RECOC1'#Manual Mount
*.asm_diskstring='o/*/DATAC1_*','o/*/RECOC1_*','/dev/exadata_quorum/*'
*.asm_power_limit=4
*.audit_sys_operations=TRUE
*.audit_syslog_level='LOCAL0.INFO'
+ASM1.cluster_interconnects='192.168.30.1:192.168.30.2'
+ASM2.cluster_interconnects='192.168.30.3:192.168.30.4'
*.large_pool_size=12M
*.memory_target=0
*.pga_aggregate_target=419430400
*.processes=1024
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=3221225472
*.use_large_pages='TRUE'

ASM实例中没有+DATA的磁盘组。

4、检查RMAN配置

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name CRMCDB 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 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE 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 '+DATA/snapcf_crmcdb.f';

SNAPSHOT CONTROLFILE NAME设置在+DATA磁盘组下，该磁盘组不存在。

小结：rman配置SNAPSHOT CONTROLFILE NAME时设置的ASM磁盘组不存在，控制文件自动配置时找不到该磁盘组，数据库日志报ORA-15001

ORA-15018。生产环境设置任何参数和进行所以配置时，都应该要仔细核对和复核，变更前要在测试环境进行严格测试，准备详细的变更方案。

-the end-