数据库异地恢复，最后在做recover时报错如下：

Starting recover at 24-NOV-23

starting media recovery

Oracle Error: 

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup 

ORA-01110: data file 1: '/oradata/datafile/eip/eip/data_D-EIP_TS-SYSTEM_F'

released channel: c1

released channel: c2

released channel: c3

released channel: c4

released channel: c5

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

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

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

RMAN-03002: failure of recover command at 11/24/2023 14:55:37

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 2 with sequence 115269 and starting SCN of 10381700116231 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 114753 and starting SCN of 10381700116468 found to restore

这个问题貌似比较普遍

解决过程如下：

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select min(FHSCN) "LOW FILEHDR SCN"

, max(FHSCN) "MAX FILEHDR SCN"

, max(FHAFS) "Min PITR ABSSCN"

from X$KCVFH ;  2    3    4  

LOW FILEHDR SCN  MAX FILEHDR SCN  Min PITR ABSSCN

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

10381699725922 10381699725930   10381700097196

-- Example output explained:

--

-- "LOW FILEHDR SCN" - this is the SCN at which recovery process starts

-- "MAX FILEHDR SCN" - this is the SCN we must recover to to get all datafiles consistent

--

-- IF "Min PITR ABSSCN" != 0 AND > "MAX FILEHDR SCN"

-- THEN "Min PITR ABSSCN" is the SCN we must recover to to get all datafiles consistent

[oracle@eipdbhost01 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Nov 24 14:58:57 2023

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

connected to target database: EIP (DBID=4071130498, not open)

RMAN> recover database until scn 10381700097196;

Starting recover at 24-NOV-23

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1700 device type=DISK

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=114748

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=115264

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=114749

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=115265

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=114750

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=115266

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=114751

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=115267

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=114752

channel ORA_DISK_1: restoring archived log

archived log thread=2 sequence=115268

channel ORA_DISK_1: reading from backup piece /oradata/rman_eip/eip_arch_20231101_0m2ad2mo.bkp

channel ORA_DISK_1: piece handle=/oradata/rman_eip/eip_arch_20231101_0m2ad2mo.bkp tag=TAG20231101T142235

channel ORA_DISK_1: restored backup piece 1

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

archived log file name=/oradata/eip/arch/2_115264_1047655684.dbf thread=2 sequence=115264

archived log file name=/oradata/eip/arch/1_114748_1047655684.dbf thread=1 sequence=114748

archived log file name=/oradata/eip/arch/1_114749_1047655684.dbf thread=1 sequence=114749

archived log file name=/oradata/eip/arch/2_115265_1047655684.dbf thread=2 sequence=115265

archived log file name=/oradata/eip/arch/1_114750_1047655684.dbf thread=1 sequence=114750

archived log file name=/oradata/eip/arch/2_115266_1047655684.dbf thread=2 sequence=115266

archived log file name=/oradata/eip/arch/1_114751_1047655684.dbf thread=1 sequence=114751

archived log file name=/oradata/eip/arch/2_115267_1047655684.dbf thread=2 sequence=115267

archived log file name=/oradata/eip/arch/1_114752_1047655684.dbf thread=1 sequence=114752

archived log file name=/oradata/eip/arch/2_115268_1047655684.dbf thread=2 sequence=115268

media recovery complete, elapsed time: 00:00:33

Finished recover at 24-NOV-23

参考MOS文档(Doc ID 1528788.1)