Hex dump of (file 10, block 1) in trace file /app/Oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4911.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Tue Dec 24 15:54:18 2019
Hex dump of (file 10, block 1) in trace file /app/Oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4937.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Startup Oracle instanct faild with corrupt block .
This case resolved by using prm-dul unload database and recreate database.
https://s.dbrecover.com/dbrecover-for-oracle-latest-dist.zip
Tue Dec 24 15:06:41 2019
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Tue Dec 24 15:06:58 2019
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side pfile /app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
System parameters with non-default values:
processes = 1500
memory_target = 8G
control_files = "/app/oracle/oradata/orcl/control01.ctl"
control_files = "/app/oracle/flash_recovery_area/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/app/oracle/oradata/archive"
log_archive_dest_state_2 = "ENABLE"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl"
open_cursors = 5000
pga_aggregate_target = 0
diagnostic_dest = "/app/oracle"
Tue Dec 24 15:07:00 2019
PMON started with pid=2, OS id=49236
Tue Dec 24 15:07:00 2019
VKTM started with pid=3, OS id=49238 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Dec 24 15:07:00 2019
GEN0 started with pid=4, OS id=49242
Tue Dec 24 15:07:00 2019
DIAG started with pid=5, OS id=49244
Tue Dec 24 15:07:00 2019
DBRM started with pid=6, OS id=49246
Tue Dec 24 15:07:00 2019
PSP0 started with pid=7, OS id=49248
Tue Dec 24 15:07:00 2019
DIA0 started with pid=8, OS id=49250
Tue Dec 24 15:07:00 2019
MMAN started with pid=9, OS id=49252
Tue Dec 24 15:07:00 2019
DBW0 started with pid=10, OS id=49254
Tue Dec 24 15:07:00 2019
DBW1 started with pid=11, OS id=49256
Tue Dec 24 15:07:00 2019
LGWR started with pid=12, OS id=49258
Tue Dec 24 15:07:00 2019
CKPT started with pid=13, OS id=49260
Tue Dec 24 15:07:00 2019
SMON started with pid=14, OS id=49262
Tue Dec 24 15:07:00 2019
RECO started with pid=15, OS id=49264
Tue Dec 24 15:07:00 2019
MMON started with pid=16, OS id=49266
Tue Dec 24 15:07:00 2019
MMNL started with pid=17, OS id=49268
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Dec 24 15:07:48 2019
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Dec 24 15:07:51 2019
Stopping background process VKTM:
Tue Dec 24 15:07:54 2019
Instance shutdown complete
Tue Dec 24 15:08:00 2019
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side pfile /app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
System parameters with non-default values:
processes = 1500
memory_target = 8G
control_files = "/app/orcl_error_18122019/control01.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/app/oracle/oradata/archive"
log_archive_dest_state_2 = "ENABLE"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl"
open_cursors = 5000
pga_aggregate_target = 0
diagnostic_dest = "/app/oracle"
Tue Dec 24 15:08:02 2019
PMON started with pid=2, OS id=49382
Tue Dec 24 15:08:02 2019
VKTM started with pid=3, OS id=49384 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Dec 24 15:08:02 2019
GEN0 started with pid=4, OS id=49388
Tue Dec 24 15:08:02 2019
DIAG started with pid=5, OS id=49390
Tue Dec 24 15:08:02 2019
DBRM started with pid=6, OS id=49392
Tue Dec 24 15:08:02 2019
PSP0 started with pid=7, OS id=49394
Tue Dec 24 15:08:02 2019
DIA0 started with pid=8, OS id=49396
Tue Dec 24 15:08:02 2019
MMAN started with pid=9, OS id=49398
Tue Dec 24 15:08:02 2019
DBW0 started with pid=10, OS id=49400
Tue Dec 24 15:08:02 2019
DBW1 started with pid=11, OS id=49402
Tue Dec 24 15:08:02 2019
LGWR started with pid=12, OS id=49404
Tue Dec 24 15:08:02 2019
CKPT started with pid=13, OS id=49406
Tue Dec 24 15:08:02 2019
SMON started with pid=14, OS id=49408
Tue Dec 24 15:08:02 2019
RECO started with pid=15, OS id=49410
Tue Dec 24 15:08:02 2019
MMON started with pid=16, OS id=49412
Tue Dec 24 15:08:02 2019
MMNL started with pid=17, OS id=49414
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Dec 24 15:08:02 2019
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 304686163
Database mounted in Exclusive Mode
Lost write protection disabled
Create Relation IPS_PACKAGE_UNPACK_HISTORY
Completed: ALTER DATABASE MOUNT
Tue Dec 24 15:09:09 2019
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_49460.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/app/oracle/oradata/orcl/log01B.dbf '
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 1: '/app/oracle/oradata/orcl/log01A.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_49460.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/app/oracle/oradata/orcl/log02B.dbf '
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/app/oracle/oradata/orcl/log02A.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_49460.trc:
ORA-00313: open failed for members of log group 6 of thread 1
ORA-00312: online log 6 thread 1: '/app/oracle/oradata/orcl/log03B.dbf '
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 1: '/app/oracle/oradata/orcl/log03A.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Checker run found 19 new persistent data failures
Tue Dec 24 15:10:18 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49479.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49479.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49479.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49479.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49479.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49479.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Tue Dec 24 15:21:39 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49658.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49658.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49658.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49658.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Tue Dec 24 15:23:53 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49675.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49675.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49675.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_49675.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Tue Dec 24 15:26:26 2019
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Tue Dec 24 15:27:32 2019
License high water mark = 4
USER (ospid: 49731): terminating the instance
Instance terminated by USER, pid = 49731
Tue Dec 24 15:35:03 2019
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side pfile /app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
System parameters with non-default values:
processes = 1500
sga_target = 4G
control_files = "/app/orcl_error_18122019/control01.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/app/oracle/oradata/archive"
log_archive_dest_state_2 = "ENABLE"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl"
open_cursors = 5000
pga_aggregate_target = 4G
diagnostic_dest = "/app/oracle"
Tue Dec 24 15:35:04 2019
PMON started with pid=2, OS id=4596
Tue Dec 24 15:35:04 2019
VKTM started with pid=3, OS id=4598 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Dec 24 15:35:04 2019
GEN0 started with pid=4, OS id=4602
Tue Dec 24 15:35:04 2019
DIAG started with pid=5, OS id=4604
Tue Dec 24 15:35:04 2019
DBRM started with pid=6, OS id=4606
Tue Dec 24 15:35:04 2019
PSP0 started with pid=7, OS id=4608
Tue Dec 24 15:35:04 2019
DIA0 started with pid=8, OS id=4610
Tue Dec 24 15:35:04 2019
MMAN started with pid=9, OS id=4612
Tue Dec 24 15:35:04 2019
DBW0 started with pid=10, OS id=4614
Tue Dec 24 15:35:04 2019
DBW1 started with pid=11, OS id=4616
Tue Dec 24 15:35:04 2019
LGWR started with pid=12, OS id=4618
Tue Dec 24 15:35:04 2019
CKPT started with pid=13, OS id=4620
Tue Dec 24 15:35:04 2019
SMON started with pid=14, OS id=4622
Tue Dec 24 15:35:04 2019
RECO started with pid=15, OS id=4624
Tue Dec 24 15:35:04 2019
MMON started with pid=16, OS id=4626
Tue Dec 24 15:35:04 2019
MMNL started with pid=17, OS id=4628
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Dec 24 15:35:04 2019
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 304689832
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Dec 24 15:35:40 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4657.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4657.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4657.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4657.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Tue Dec 24 15:41:39 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Tue Dec 24 15:42:20 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Reading datafile '/app/oracle/oradata/orcl/ts_ecm02.mdb' for corruption at rdba: 0x02800001 (file 10, block 1)
Reread (file 10, block 1) found different corrupt data
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during reread
Tue Dec 24 15:43:33 2019
alter tablespace TS_ECM offline
ORA-1109 signalled during: alter tablespace TS_ECM offline...
alter database datafile 10 offline
Completed: alter database datafile 10 offline
Tue Dec 24 15:43:45 2019
alter database open
Tue Dec 24 15:43:45 2019
LGWR: STARTING ARCH PROCESSES
Tue Dec 24 15:43:45 2019
ARC0 started with pid=19, OS id=4739
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Tue Dec 24 15:43:46 2019
ARC1 started with pid=20, OS id=4741
Thread 1 opened at log sequence 24214
Current log# 5 seq# 24214 mem# 0: /app/oracle/oradata/orcl/log02A.dbf
Current log# 5 seq# 24214 mem# 1: /app/oracle/oradata/orcl/log02B.dbf
Successful open of redo thread 1
Tue Dec 24 15:43:46 2019
ARC2 started with pid=21, OS id=4743
Tue Dec 24 15:43:46 2019
ARC3 started with pid=22, OS id=4745
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Dec 24 15:43:46 2019
ARC4 started with pid=23, OS id=4747
Tue Dec 24 15:43:46 2019
ARC5 started with pid=24, OS id=4749
Tue Dec 24 15:43:46 2019
ARC6 started with pid=25, OS id=4751
Tue Dec 24 15:43:46 2019
ARC7 started with pid=26, OS id=4753
Tue Dec 24 15:43:46 2019
ARC8 started with pid=27, OS id=4755
Tue Dec 24 15:43:47 2019
ARC9 started with pid=28, OS id=4757
Tue Dec 24 15:43:47 2019
ARCa started with pid=29, OS id=4759
Tue Dec 24 15:43:47 2019
ARCb started with pid=30, OS id=4761
Tue Dec 24 15:43:47 2019
ARCc started with pid=31, OS id=4763
Tue Dec 24 15:43:47 2019
ARCd started with pid=32, OS id=4765
Tue Dec 24 15:43:47 2019
ARCe started with pid=33, OS id=4767
Tue Dec 24 15:43:47 2019
ARCf started with pid=34, OS id=4769
Tue Dec 24 15:43:47 2019
ARCg started with pid=35, OS id=4771
Tue Dec 24 15:43:47 2019
ARCh started with pid=36, OS id=4773
Tue Dec 24 15:43:47 2019
ARCi started with pid=37, OS id=4775
Tue Dec 24 15:43:47 2019
ARCj started with pid=38, OS id=4777
Tue Dec 24 15:43:47 2019
ARCk started with pid=39, OS id=4779
Tue Dec 24 15:43:47 2019
ARCl started with pid=40, OS id=4781
Tue Dec 24 15:43:47 2019
ARCm started with pid=41, OS id=4783
Tue Dec 24 15:43:47 2019
ARCn started with pid=42, OS id=4785
Tue Dec 24 15:43:47 2019
ARCo started with pid=43, OS id=4787
Tue Dec 24 15:43:47 2019
ARCp started with pid=44, OS id=4789
Tue Dec 24 15:43:47 2019
ARCq started with pid=45, OS id=4791
Tue Dec 24 15:43:47 2019
SMON: enabling cache recovery
Tue Dec 24 15:43:47 2019
ARCr started with pid=46, OS id=4793
Tue Dec 24 15:43:47 2019
ARCs started with pid=47, OS id=4795
ARC1: Archival started
Tue Dec 24 15:43:47 2019
ARCt started with pid=48, OS id=4797
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Hex dump of (file 1, block 337) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc
Corrupt block relative dba: 0x00400151 (file 1, block 337)
Bad header found during buffer read
Data in bad block:
type: 253 format: 1 rdba: 0xa8a2c43a
last change scn: 0x622d.555a446b seq: 0x4e flg: 0x3f
spare1: 0xe5 spare2: 0x30 spare3: 0x4112
consistency value in tail: 0x9d588318
check value in block header: 0xda83
computed block checksum: 0x7618
Reading datafile '/app/oracle/oradata/orcl/system01.dbf' for corruption at rdba: 0x00400151 (file 1, block 337)
Reread (file 1, block 337) found same corrupt data
Tue Dec 24 15:43:47 2019
Checker run found 2 new persistent data failures
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc (incident=24145):
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24145/orcl_ora_4727_i24145.trc
ARCt: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Hex dump of (file 0, block 670) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24145/orcl_ora_4727_i24145.trc
Corrupt block relative dba: 0x0000029e (file 0, block 670)
Bad header found during control file block read
Data in bad block:
type: 182 format: 4 rdba: 0x90f20def
last change scn: 0xdef9.0f21edef seq: 0xfe flg: 0xf2
spare1: 0x87 spare2: 0x7c spare3: 0x2a1d
consistency value in tail: 0xce7c7237
check value in block header: 0xef90
block checksum disabled
Control file block read for fixed table access has failed due to concurrent controlfile updates.
This is not a real data corruption. Please retry the query.
Errors in file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24145/orcl_ora_4727_i24145.trc:
ORA-00202: control file: '/app/orcl_error_18122019/control01.ctl'
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc (incident=24146):
ORA-00227: corrupt block detected in control file: (block 670, # blocks 1)
ORA-00202: control file: '/app/orcl_error_18122019/control01.ctl'
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_ora_4727_i24146.trc
Errors in file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24145/orcl_ora_4727_i24145.trc:
ORA-00227: corrupt block detected in control file: (block 670, # blocks 1)
ORA-00202: control file: '/app/orcl_error_18122019/control01.ctl'
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Tue Dec 24 15:43:49 2019
Sweep [inc][24146]: completed
Hex dump of (file 0, block 656) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000290 (file 0, block 656)
Bad header found during backing up controlfile
Data in bad block:
type: 108 format: 2 rdba: 0x919b7486
last change scn: 0x2ad3.504e45ae seq: 0x53 flg: 0x76
spare1: 0x3 spare2: 0x5c spare3: 0xc0c0
consistency value in tail: 0x46956773
check value in block header: 0x1390
computed block checksum: 0x67c0
Reread of blocknum=656, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=656, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=656, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=656, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=656, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Tue Dec 24 15:43:50 2019
Sweep [inc][24145]: completed
Sweep [inc2][24146]: completed
Hex dump of (file 0, block 657) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000291 (file 0, block 657)
Bad header found during backing up controlfile
Data in bad block:
type: 251 format: 6 rdba: 0xb1bbc1b0
last change scn: 0x5b24.b2c66cc1 seq: 0x2 flg: 0x59
spare1: 0x91 spare2: 0x17 spare3: 0xd96c
consistency value in tail: 0x6bde2807
check value in block header: 0x5a12
block checksum disabled
Reread of blocknum=657, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=657, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=657, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=657, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=657, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 658) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000292 (file 0, block 658)
Bad header found during backing up controlfile
Data in bad block:
type: 183 format: 2 rdba: 0xad13d5e2
last change scn: 0x6477.4058a46f seq: 0x18 flg: 0x9f
spare1: 0x32 spare2: 0x6a spare3: 0xc0d9
consistency value in tail: 0x87e423bc
check value in block header: 0x3181
computed block checksum: 0xb1e6
Reread of blocknum=658, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=658, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=658, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=658, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=658, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 659) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000293 (file 0, block 659)
Bad header found during backing up controlfile
Data in bad block:
type: 95 format: 4 rdba: 0x155b3b3d
last change scn: 0x131a.7e3d4418 seq: 0xde flg: 0xde
spare1: 0xe1 spare2: 0xe5 spare3: 0x6e85
consistency value in tail: 0x7384a381
check value in block header: 0xa5e1
computed block checksum: 0x7df4
Reread of blocknum=659, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=659, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=659, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=659, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=659, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Tue Dec 24 15:43:50 2019
Trace dumping is performing id=[cdmp_20191224154350]
Hex dump of (file 0, block 660) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000294 (file 0, block 660)
Bad header found during backing up controlfile
Data in bad block:
type: 55 format: 4 rdba: 0x308c6339
last change scn: 0x9d25.826181ee seq: 0xc3 flg: 0x84
spare1: 0x3 spare2: 0x2c spare3: 0x84e
consistency value in tail: 0xd23d83fb
check value in block header: 0xdb3
computed block checksum: 0x9293
Reread of blocknum=660, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=660, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=660, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=660, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=660, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 661) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000295 (file 0, block 661)
Bad header found during backing up controlfile
Data in bad block:
type: 172 format: 5 rdba: 0xa36f764b
last change scn: 0xdfb0.76841356 seq: 0x50 flg: 0x72
spare1: 0x5b spare2: 0xcb spare3: 0x4690
consistency value in tail: 0xabec859e
check value in block header: 0xb9c9
block checksum disabled
Reread of blocknum=661, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=661, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=661, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=661, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=661, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 662) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000296 (file 0, block 662)
Bad header found during backing up controlfile
Data in bad block:
type: 22 format: 1 rdba: 0x50ac0abd
last change scn: 0x4ee8.46f9e7d5 seq: 0x72 flg: 0x1e
spare1: 0xf3 spare2: 0x15 spare3: 0x8994
consistency value in tail: 0xe7815b5e
check value in block header: 0x3ab
computed block checksum: 0x2999
Reread of blocknum=662, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=662, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=662, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=662, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=662, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 663) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000297 (file 0, block 663)
Bad header found during backing up controlfile
Data in bad block:
type: 146 format: 2 rdba: 0x0613950a
last change scn: 0x83c0.0f701238 seq: 0x0 flg: 0x8f
spare1: 0xb8 spare2: 0x6e spare3: 0x1f43
consistency value in tail: 0x2bc9f457
check value in block header: 0x62b6
computed block checksum: 0xcdeb
Reread of blocknum=663, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=663, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=663, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=663, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=663, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 664) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000298 (file 0, block 664)
Bad header found during backing up controlfile
Data in bad block:
type: 159 format: 1 rdba: 0x1127a361
last change scn: 0x7fb8.96fcde51 seq: 0x8d flg: 0x80
spare1: 0xfa spare2: 0x5c spare3: 0xde4e
consistency value in tail: 0x3971a0af
check value in block header: 0x894
block checksum disabled
Reread of blocknum=664, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=664, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=664, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=664, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=664, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 665) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x00000299 (file 0, block 665)
Bad header found during backing up controlfile
Data in bad block:
type: 41 format: 0 rdba: 0x5f8527b7
last change scn: 0x82d7.f0e2fe00 seq: 0xbf flg: 0x09
spare1: 0x29 spare2: 0xf0 spare3: 0x27f0
consistency value in tail: 0x6eea30f4
check value in block header: 0xf1fc
block checksum disabled
Reread of blocknum=665, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=665, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=665, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=665, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=665, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 666) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x0000029a (file 0, block 666)
Bad header found during backing up controlfile
Data in bad block:
type: 171 format: 0 rdba: 0x494a5ea9
last change scn: 0x0478.0419281f seq: 0xe0 flg: 0x71
spare1: 0x4b spare2: 0x4 spare3: 0x8af5
consistency value in tail: 0x1dc7dcbd
check value in block header: 0x9d8a
block checksum disabled
Reread of blocknum=666, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=666, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=666, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=666, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=666, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 667) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x0000029b (file 0, block 667)
Bad header found during backing up controlfile
Data in bad block:
type: 255 format: 6 rdba: 0xcbf040c5
last change scn: 0x9f3b.93fbcd7f seq: 0x5 flg: 0x12
spare1: 0x29 spare2: 0x7b spare3: 0x8fc2
consistency value in tail: 0x81b797f7
check value in block header: 0x8ca3
block checksum disabled
Reread of blocknum=667, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=667, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=667, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=667, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=667, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 668) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x0000029c (file 0, block 668)
Bad header found during backing up controlfile
Data in bad block:
type: 7 format: 1 rdba: 0xc127c99b
last change scn: 0xcb87.875fc83b seq: 0xd7 flg: 0xc3
spare1: 0x7 spare2: 0xc0 spare3: 0xe07b
consistency value in tail: 0x013f3d3d
check value in block header: 0xe4a3
block checksum disabled
Reread of blocknum=668, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=668, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=668, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=668, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=668, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 669) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x0000029d (file 0, block 669)
Bad header found during backing up controlfile
Data in bad block:
type: 47 format: 6 rdba: 0xfa75a2bf
last change scn: 0x0eaf.2d79e1e6 seq: 0x2f flg: 0xac
spare1: 0xbf spare2: 0x6 spare3: 0xf70b
consistency value in tail: 0xf7c87962
check value in block header: 0x3ee3
computed block checksum: 0x2ddf
Reread of blocknum=669, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=669, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=669, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=669, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=669, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 670) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x0000029e (file 0, block 670)
Bad header found during backing up controlfile
Data in bad block:
type: 182 format: 4 rdba: 0x90f20def
last change scn: 0xdef9.0f21edef seq: 0xfe flg: 0xf2
spare1: 0x87 spare2: 0x7c spare3: 0x2a1d
consistency value in tail: 0xce7c7237
check value in block header: 0xef90
block checksum disabled
Reread of blocknum=670, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=670, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=670, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=670, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=670, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Hex dump of (file 0, block 671) in trace file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24146/orcl_m000_4804_i24146_a.trc
Corrupt block relative dba: 0x0000029f (file 0, block 671)
Bad header found during backing up controlfile
Data in bad block:
type: 151 format: 7 rdba: 0xcde18fc8
last change scn: 0xb794.3ce3c5e5 seq: 0xc3 flg: 0x7b
spare1: 0xc0 spare2: 0x9b spare3: 0xb7e2
consistency value in tail: 0x0e7f6cd5
check value in block header: 0xbbcb
block checksum disabled
Reread of blocknum=671, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=671, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=671, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=671, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Reread of blocknum=671, file=/app/orcl_error_18122019/control01.ctl. found same corrupt data
Checker run found 16 new persistent data failures
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc (incident=24147):
ORA-00353: log corruption near block 20992 change 3745688981 time 12/17/2019 12:24:45
ORA-00334: archived log: '/app/oracle/oradata/orcl/log03A.dbf'
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24147/orcl_ora_4727_i24147.trc
Errors in file /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_24145/orcl_ora_4727_i24145.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 20992 change 3745688981 time 12/17/2019 12:24:45
ORA-00334: archived log: '/app/oracle/oradata/orcl/log03A.dbf'
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Tue Dec 24 15:43:51 2019
Sweep [inc][24147]: completed
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4727.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 337)
ORA-01110: data file 1: '/app/oracle/oradata/orcl/system01.dbf'
Error 704 happened during db open, shutting down database
USER (ospid: 4727): terminating the instance due to error 704
Instance terminated by USER, pid = 4727
ORA-1092 signalled during: alter database open...
opiodr aborting process unknown ospid (4727) as a result of ORA-1092
Tue Dec 24 15:43:52 2019
ORA-1092 : opitsk aborting process
Tue Dec 24 15:46:51 2019
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side pfile /app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
System parameters with non-default values:
processes = 1500
sga_target = 4G
control_files = "/app/orcl_error_18122019/control01.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/app/oracle/oradata/archive"
log_archive_dest_state_2 = "ENABLE"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl"
open_cursors = 5000
pga_aggregate_target = 4G
diagnostic_dest = "/app/oracle"
Tue Dec 24 15:46:52 2019
PMON started with pid=2, OS id=4858
Tue Dec 24 15:46:52 2019
VKTM started with pid=3, OS id=4860 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Dec 24 15:46:52 2019
GEN0 started with pid=4, OS id=4864
Tue Dec 24 15:46:52 2019
DIAG started with pid=5, OS id=4866
Tue Dec 24 15:46:52 2019
DBRM started with pid=6, OS id=4868
Tue Dec 24 15:46:52 2019
PSP0 started with pid=7, OS id=4870
Tue Dec 24 15:46:52 2019
DIA0 started with pid=8, OS id=4872
Tue Dec 24 15:46:52 2019
MMAN started with pid=9, OS id=4874
Tue Dec 24 15:46:52 2019
DBW0 started with pid=10, OS id=4876
Tue Dec 24 15:46:52 2019
DBW1 started with pid=11, OS id=4878
Tue Dec 24 15:46:52 2019
LGWR started with pid=12, OS id=4880
Tue Dec 24 15:46:52 2019
CKPT started with pid=13, OS id=4882
Tue Dec 24 15:46:52 2019
SMON started with pid=14, OS id=4884
Tue Dec 24 15:46:52 2019
RECO started with pid=15, OS id=4886
Tue Dec 24 15:46:52 2019
MMON started with pid=16, OS id=4888
Tue Dec 24 15:46:52 2019
MMNL started with pid=17, OS id=4890
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Dec 24 15:46:52 2019
ALTER DATABASE MOUNT
Tue Dec 24 15:46:52 2019
Sweep [inc2][24147]: completed
Sweep [inc2][24145]: completed
Successful mount of redo thread 1, with mount id 304653676
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Dec 24 15:51:12 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4911.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8
Tue Dec 24 15:54:18 2019
Hex dump of (file 10, block 1) in trace file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4937.trc
Corrupt block relative dba: 0x02800001 (file 10, block 1)
Completely zero block found during kcvxfh v8DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.