ITPub博客

首页 > 数据库 > Oracle > Rman报错ORA-00234: ORA-00202处理

Rman报错ORA-00234: ORA-00202处理

原创 Oracle 作者:yingyifeng306 时间:2022-04-15 13:27:42 0 删除 编辑

[oracle@node1 ~]$ rman target /

 

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Oct 9 17:39:08 2021

 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: ORCL (DBID=1536981340)

 

RMAN> run{

2> allocate channel c1 type disk;

3> allocate channel c2 type disk;

4> backup as compressed backupset  incremental from scn 14387254313131 database format '/u01/app/bak/st_%U' tag '14387254313131';

5> release channel c1;

6> release channel c2;

7> }

 

using target database control file instead of recovery catalog

allocated channel: c1

channel c1: SID=157 instance=orcl1 device type=DISK

 

allocated channel: c2

channel c2: SID=298 instance=orcl1 device type=DISK

 

Starting backup at 09-OCT-21

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00004 name=+DATA/orcl/datafile/users.258.1077900183

input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.260.1077900183

input datafile file number=00005 name=+DATA/orcl/datafile/example.264.1077901049

input datafile file number=00007 name=+DATA/orcl/datafile/undotbs2.262.1077900899

channel c1: starting piece 1 at 09-OCT-21

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00006 name=+DATA/orcl/datafile/users.261.1077900183

input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.1077900183

input datafile file number=00001 name=+DATA/orcl/datafile/system.263.1077900923

channel c2: starting piece 1 at 09-OCT-21

channel c2: finished piece 1 at 09-OCT-21

piece handle=/u01/app/bak/st_410b7172_1_1 tag=14387254313131 comment=NONE

channel c2: backup set complete, elapsed time: 00:08:55

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

RMAN-03009: failure of backup command on c2 channel at 10/09/2021 17:48:46

ORA-00234: error in identifying or opening snapshot or copy control file

ORA-00202: control file: '+DATA'

ORA-17503: ksfdopn:2 Failed to open file +DATA

ORA-15045: ASM file name '+DATA' is not in reference form

continuing other job steps, job failed will not be re-run

channel c1: finished piece 1 at 09-OCT-21

piece handle=/u01/app/bak/st_400b7172_1_1 tag=14387254313131 comment=NONE

channel c1: backup set complete, elapsed time: 00:09:25

released channel: c1

released channel: c2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

 

RMAN-03009: failure of backup command on c2 channel at 10/09/2021 17:48:46

ORA-00234: error in identifying or opening snapshot or copy control file

ORA-00202: control file: '+DATA'

ORA-17503: ksfdopn:2 Failed to open file +DATA

ORA-15045: ASM file name '+DATA' is not in reference form

 

 

解决方案

根据MOS文档, RMAN CONFIGURE SNAPSHOT CONTROLFILE to ASM fails ORA-00234 ORA-00202 ORA-17503 ORA-15045 ( 文档 ID 1564738.1)

 

RMAN> configure snapshot controlfile name clear;

 

using target database control file instead of recovery catalog

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA';

RMAN configuration parameters are successfully reset to default value

 

RMAN> configure snapshot controlfile name to '+FRA/snapcf_prod.f';

 

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/snapcf_prod.f';

new RMAN configuration parameters are successfully stored


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/23732248/viewspace-2887295/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
ITpub论坛高可用版主,擅长研究Oracle 内部原理、新特性、高可用和性能调优等,多年来一直保持着对新事务旺盛的求知欲。热切关注 Oracle 和其它相关技术

注册时间:2011-10-12

  • 博文量
    291
  • 访问量
    1593086