1.故障现象

RMAN> list copy;

specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - ------------------- ---------- ------------------- ------
129 21 A 2024-02-29 09:18:56 277415550755 2024-02-22 22:26:21 NO
Name: /oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cap__ljhst54s_.dbf

130 22 A 2024-02-29 09:19:07 277415550755 2024-02-22 22:26:21 NO
Name: /oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cap__ljht3940_.dbf

146 23 A 2024-02-29 09:20:11 277415550755 2024-02-22 22:26:21 NO
Name: /oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_erul_lldgkr6g_.dbf

147 24 A 2024-02-29 09:20:14 277415550755 2024-02-22 22:26:21 NO
Name: /oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_erul_lldh0os7_.dbf

131 25 A 2024-02-29 09:19:14 277415550755 2024-02-22 22:26:21 NO
Name: /oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_llvxn2wm_.dbf

132 26 A 2024-02-29 09:19:17 277415550755 2024-02-22 22:26:21 NO
Name: /oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_llvyqh8x_.dbf


RMAN> switch datafile 21 to copy;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 02/29/2024 09:21:16
RMAN-06571: datafile 21 does not have recoverable copy

2.解决方法：

RMAN> list incarnation;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 INTGDBC 2952396223 PARENT 1 2017-01-26 13:52:29
2 2 INTGDBC 2952396223 PARENT 1408558 2023-06-16 17:44:34
3 3 INTGDBC 2952396223 ORPHAN 267735594047 2023-11-23 09:24:52
4 4 INTGDBC 2952396223 ORPHAN 268906131762 2023-12-07 09:42:03
5 5 INTGDBC 2952396223 ORPHAN 274317377147 2024-01-04 09:41:32
6 6 INTGDBC 2952396223 ORPHAN 275537830194 2024-01-18 08:48:13
7 7 INTGDBC 2952396223 ORPHAN 275751959579 2024-01-22 09:33:01
8 8 INTGDBC 2952396223 CURRENT 277366595391 2024-02-22 08:52:51



RMAN> reset database to incarnation 2;

using target database control file instead of recovery catalog
database reset to incarnation 2





switch datafile 21 to copy;
switch datafile 22 to copy;
switch datafile 23 to copy;
switch datafile 24 to copy;
switch datafile 25 to copy;
switch datafile 26 to copy;
switch datafile 27 to copy;
switch datafile 28 to copy;
switch datafile 29 to copy;
switch datafile 30 to copy;
switch datafile 31 to copy;
switch datafile 32 to copy;
switch datafile 33 to copy;
switch datafile 34 to copy;
switch datafile 35 to copy;
switch datafile 36 to copy;
switch datafile 37 to copy;
switch datafile 38 to copy;
switch datafile 39 to copy;
switch datafile 40 to copy;
switch datafile 41 to copy;
switch datafile 42 to copy;
switch datafile 43 to copy;
switch datafile 44 to copy;
switch datafile 45 to copy;
switch datafile 46 to copy;
switch datafile 47 to copy;
switch datafile 48 to copy;
switch datafile 49 to copy;
switch datafile 50 to copy;
switch datafile 51 to copy;
switch datafile 52 to copy;
switch datafile 53 to copy;
switch datafile 54 to copy;
switch datafile 55 to copy;




RMAN>
datafile 24 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_erul_lldh0os7_.dbf"

RMAN>
datafile 25 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_llvxn2wm_.dbf"

RMAN>
datafile 26 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_llvyqh8x_.dbf"

RMAN>
datafile 27 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_llvzwm6x_.dbf"

RMAN>
datafile 28 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_llw0skhg_.dbf"

RMAN>
datafile 29 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_cclp_lm2h9y7q_.dbf"

RMAN>
datafile 30 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_aml__lmg63qwf_.dbf"

RMAN>
datafile 31 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_ycco_lmsyo042_.dbf"

RMAN>
datafile 32 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_ycco_ln0osf49_.dbf"

RMAN>
datafile 33 switched to datafile copy "/oradata/intgdbc_std2/INTGDBC_STD2/datafile/o1_mf_tbs_erul_ln379kgz_.dbf"