Rman報錯ORA-00234: ORA-00202處理

[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