Sat Nov 25 17:03:39 2023
ALTER DATABASE RECOVER database
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 40 slaves
Sat Nov 25 17:03:40 2023
Recovery of Online Redo Log: Thread 1 Group 7 Seq 27220 Reading mem 0
Mem # 0: /u01/app/oracle/oradata/redo07.log
Sat Nov 25 17:03:41 2023
Hex dump of ( file 3, block 7) in trace file /u01/app/oracle/diag/rdbms/his/his/trace/his_pr0l_52669 .trc
Corrupt block relative dba: 0x00c00007 ( file 3, block 7)
Bad header found during media recovery
Data in bad block:
type : 124 format : 7 rdba: 0x1698b845
last change scn: 0x4fa1.3eaa638f seq : 0x6 flg: 0x24
spare1: 0x26 spare2: 0x42 spare3: 0x0
consistency value in tail : 0xa39e1e01
check value in block header: 0x2ca4
computed block checksum: 0x3b25
Reading datafile '/u01/app/oracle/oradata/undotbs01.dbf' for corruption at rdba: 0x00c00007 ( file 3, block 7)
Reread ( file 3, block 7) found same corrupt data (no logical check)
Sat Nov 25 17:03:41 2023
Hex dump of ( file 46, block 3) in trace file /u01/app/oracle/diag/rdbms/his/his/trace/his_pr0w_52691 .trc
Corrupt block relative dba: 0x0b800003 ( file 46, block 3)
Bad header found during media recovery
Data in bad block:
type : 7 format : 7 rdba: 0x77922022
last change scn: 0xdff3.c40df5b6 seq : 0x6f flg: 0xe5
spare1: 0xcd spare2: 0x6d spare3: 0x83d7
consistency value in tail : 0x63c63d2c
check value in block header: 0xf662
computed block checksum: 0xec49
Data in bad block:
type : 135 format : 4 rdba: 0x45ad2864
last change scn: 0x9d7e.34949c73 seq : 0x32 flg: 0x3e
spare1: 0x89 spare2: 0x0 spare3: 0x9f9f
consistency value in tail : 0xa5807800
check value in block header: 0xb2c9
computed block checksum: 0x3aea
Reread ( file 5, block 11259) found same corrupt data (no logical check)
type : 214 format : 1 rdba: 0x0228dbe9
Bad header found during media recovery
last change scn: 0xed57.ca4f7559 seq : 0x9b flg: 0x4a
Data in bad block:
spare1: 0x97 spare2: 0x77 spare3: 0x2bab
type : 33 format : 6 rdba: 0x018d584a
consistency value in tail : 0x359f90d6
last change scn: 0xaeb8.2fa361eb seq : 0x60 flg: 0x92
check value in block header: 0x6b26
spare1: 0xea spare2: 0xe spare3: 0xb405 block checksum disabled
Reread ( file 3, block 4) found same corrupt data (no logical check)
Corrupt block relative dba: 0x0b800e61 ( file 46, block 3681)
Bad header found during media recovery
Data in bad block:
type : 131 format : 6 rdba: 0xc7edd0fc
last change scn: 0xd319.d0e54941 seq : 0x6f flg: 0x6d
spare1: 0xe7 spare2: 0x82 spare3: 0x439f
consistency value in tail : 0x18dc47b6
check value in block header: 0xe9c8
computed block checksum: 0x204d
Reread ( file 46, block 3681) found same corrupt data (no logical check)
Hex dump of ( file 1, block 2017) in trace file /u01/app/oracle/diag/rdbms/his/his/trace/his_pr10_52699 .trc
Corrupt block relative dba: 0x004007e1 ( file 1, block 2017)
Bad header found during media recovery
Data in bad block:
type : 159 format : 2 rdba: 0x52c5b2b0
last change scn: 0x2ed8.e0bc5af9 seq : 0x62 flg: 0xe9
spare1: 0x81 spare2: 0x1e spare3: 0xda98
consistency value in tail : 0xc5753dd3
check value in block header: 0x2bba
block checksum disabled
Reading datafile '/u01/app/oracle/oradata/system01.dbf' for corruption at rdba: 0x004007e1 ( file 1, block 2017)
Reread ( file 1, block 2017) found same corrupt data (no logical check)
Media Recovery failed with error 742
Errors in file /u01/app/oracle/diag/rdbms/his/his/trace/his_pr00_52622 .trc:
ORA-00283: recovery session canceled due to errors
ORA-00742: Log read detects lost write in thread %d sequence %d服务器托管网 block %d
ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/redo07.log'
ORA-10877 signalled during: ALTER DATABASE RECOVER database ...
|