主库闪回，备份alert日志显示

最新推荐文章于 2025-08-19 14:03:46 发布

最新推荐文章于 2025-08-19 14:03:46 发布 · 169 阅读

文章标签：

#数据库

ORACLE管理专栏收录该内容

275 篇文章

订阅专栏

本文记录了一次Oracle数据库的闪回恢复操作过程，包括不完整恢复的应用、媒体恢复完成情况、redo日志文件处理及数据库打开重置日志等关键步骤。在恢复过程中检测到数据字典与控制文件不一致等问题，并进行了相应的调整。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

仅记录：
Incomplete Recovery applied until change 9744654282788
Flashback Media Recovery Complete
Completed: flashback database to scn 9744654282785
Thu Jun 18 19:13:16 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[7]: Assigned to RFS process 16416
RFS[7]: Identified database type as 'physical standby'
RFS[7]: New Archival REDO Branch: 689886752 Current: 679664461
RFS[7]: No standby redo logfiles created
RFS[7]: Archived Log: '/Tbackup/archivelog/mctest/1_1_689886752.dbf'
RFS[7]: New Archival REDO Branch(resetlogs_id): 689886752 Prior: 679664461
RFS[7]: Archival Activation ID: 0x2c88fd7d Current: 0x2c85130d
RFS[7]: Effect of primary database OPEN RESETLOGS
New incarnation branch detected in ArchiveLog, filename /Tbackup/archivelog/mctest/1_1_689886752.dbf
Inspection of file changed rdi from 1 to 2
Setting recovery target incarnation to 2
Thu Jun 18 19:13:16 2009
RFS[7]: Incarnation entry added for Branch(resetlogs_id): 689886752 (mctest)
Thu Jun 18 19:13:16 2009
Setting recovery target incarnation to 2
Thu Jun 18 19:13:18 2009
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[8]: Assigned to RFS process 16582
RFS[8]: Identified database type as 'physical standby'

alter database open RESETLOGS
ARCH: Logfile 1 is wrong incarnation (0:1049208:06/19/2009 12:40:02 vs 0:446075:06/16/2009 17:12:13)
ARCH: Logfile 2 is wrong incarnation (0:1049208:06/19/2009 12:40:02 vs 0:446075:06/16/2009 17:12:13)
ARCH: Logfile 3 is wrong incarnation (0:1049208:06/19/2009 12:40:02 vs 0:446075:06/16/2009 17:12:13)
RESETLOGS after complete recovery through change 1055358
Resetting resetlogs activation ID 1987903337 (0x767cff69)
Fri Jun 19 15:56:51 2009
Setting recovery target incarnation to 2

Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Tablespace 'USERS' #4 found in data dictionary,
but not in the controlfile. Adding to controlfile.
File #4 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00004' in the controlfile.
This file can no longer be recovered so it must be dropped.
Dictionary check complete