ORA-01547 ORA-01152 ORA-01110 RMAN-06025

数据库异地恢复，最后在做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)