【博客文章2024】疑难场景处置：恢复带有多个历史化身的RAC 19c数据库时，因备份部分缺失而导致的连续出现UNNAME00000X问题的成功处置

[oracle@station11 ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 7 16:28:19 2024

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 4949276568 bytes

Fixed Size                  8906648 bytes

Variable Size            1040187392 bytes

Database Buffers         3892314112 bytes

Redo Buffers                7868416 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '+DATA/RACORCL/DATAFILE/system.283.1162980303'

[grid@station11 ~]$ asmcmd ls +FRA/RACORCL/ARCHIVELOG/2024_03_07 | sort -n -t . -k 3 

thread_2_seq_3.271.1162981899

thread_1_seq_7.275.1162984797

thread_1_seq_8.274.1162984797

thread_2_seq_4.270.1162985105

thread_2_seq_5.269.1162985107

thread_2_seq_6.268.1162985111

thread_2_seq_7.267.1162985111

thread_1_seq_9.266.1162985113

thread_2_seq_8.261.1162985113

thread_2_seq_9.262.1162985119

thread_1_seq_10.256.1162996409

thread_1_seq_9.282.1162996409

thread_2_seq_10.259.1162996409

thread_2_seq_9.260.1162996409

thread_2_seq_1.258.1162996415

thread_2_seq_2.287.1162996935

thread_2_seq_3.292.1162996939

thread_1_seq_1.293.1162996941

thread_2_seq_4.294.1162996943

thread_2_seq_5.295.1162996945

thread_2_seq_6.296.1162996945

thread_1_seq_2.298.1162996949

thread_2_seq_7.297.1162996949

thread_1_seq_2.272.1162998105

thread_1_seq_3.257.1162998107

thread_2_seq_7.263.1162998153

thread_2_seq_8.278.1162998153

thread_1_seq_4.273.1162998397

thread_1_seq_5.265.1162998399

thread_1_seq_6.299.1162998407

thread_2_seq_9.300.1162998409

*************缺失thread 1 seq 7

thread_1_seq_8.302.1162998411

thread_1_seq_9.303.1162998413

thread_2_seq_10.304.1162998419

thread_2_seq_11.305.1162998425

[oracle@station11 ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Mar 7 16:35:23 2024

Version 19.3.0.0.0

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

connected to target database: RACORCL (DBID=2908490689, not open)

RMAN> run {

2> set until sequence 7 thread 1;

3> restore database;

4> recover database;

5> }

executing command: SET until clause

Starting restore at 07-MAR-24

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1712 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=249 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=1226 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=1469 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=1592 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=1713 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=1837 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=5 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_9

channel ORA_DISK_9: SID=127 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_10

channel ORA_DISK_10: SID=250 instance=racorcl1 device type=DISK

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

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

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

RMAN-03002: failure of restore command at 03/07/2024 16:37:35

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 8 found to restore

RMAN-06023: no backup or copy of datafile 7 found to restore

RMAN-06023: no backup or copy of datafile 5 found to restore

RMAN-06023: no backup or copy of datafile 4 found to restore

RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 2 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> 

RMAN> list backup of archivelog sequence 6 thread 1;

specification does not match any backup in the repository

RMAN> reset database to incarnation 2;

database reset to incarnation 2

RMAN>  list backup of archivelog sequence 6 thread 1;

List of Backup Sets

===================

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

72      9.50K      DISK        00:00:00     07-MAR-24      

        BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0

        Piece Name: +FRA/RACORCL/BACKUPSET/2024_03_07/annnf0_1d_whole_incr0_0.277.1162981865

  List of Archived Logs in backup set 72

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    6       2077927    07-MAR-24 2078008    07-MAR-24

RMAN> restore archivelog sequence 6 thread 1;

Starting restore at 07-MAR-24

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=373 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=495 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=1347 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=1469 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=1592 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=1713 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=1836 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=5 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_9

channel ORA_DISK_9: SID=128 instance=racorcl1 device type=DISK

allocated channel: ORA_DISK_10

channel ORA_DISK_10: SID=250 instance=racorcl1 device type=DISK

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=6

channel ORA_DISK_1: reading from backup piece +FRA/RACORCL/BACKUPSET/2024_03_07/annnf0_1d_whole_incr0_0.277.1162981865

channel ORA_DISK_1: piece handle=+FRA/RACORCL/BACKUPSET/2024_03_07/annnf0_1d_whole_incr0_0.277.1162981865 tag=1D_WHOLE_INCR0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

Finished restore at 07-MAR-24

RMAN> restore archivelog scn between 2077990 and 2087612;

Starting restore at 09-MAR-24

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

using channel ORA_DISK_9

using channel ORA_DISK_10

archived log for thread 1 with sequence 6 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_1_seq_6.301.1163006471

archived log for thread 1 with sequence 7 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_1_seq_7.275.1162984797

archived log for thread 1 with sequence 8 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_1_seq_8.274.1162984797

archived log for thread 1 with sequence 9 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_1_seq_9.266.1162985113

archived log for thread 1 with sequence 10 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_1_seq_10.256.1162996409

archived log for thread 2 with sequence 3 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_3.271.1162981899

archived log for thread 2 with sequence 4 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_4.270.1162985105

archived log for thread 2 with sequence 5 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_5.269.1162985107

archived log for thread 2 with sequence 6 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_6.268.1162985111

archived log for thread 2 with sequence 7 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_7.267.1162985111

archived log for thread 2 with sequence 8 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_8.261.1162985113

archived log for thread 2 with sequence 9 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_9.262.1162985119

archived log for thread 2 with sequence 10 is already on disk as file +FRA/RACORCL/ARCHIVELOG/2024_03_07/thread_2_seq_10.259.1162996409

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=2

channel ORA_DISK_1: reading from backup piece +FRA/RACORCL/BACKUPSET/2024_03_07/annnf0_1d_whole_incr0_0.276.1162981865

channel ORA_DISK_1: piece handle=+FRA/RACORCL/BACKUPSET/2024_03_07/annnf0_1d_whole_incr0_0.276.1162981865 tag=1D_WHOLE_INCR0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

Finished restore at 09-MAR-24

RMAN> 

RMAN> reset database to incarnation 185;

database reset to incarnation 185