`
itspace
  • 浏览: 960673 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论

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

 
阅读更多
仅记录:
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



分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics