7 x 24 在线支持！
Oracle physical corruption Completely zero block found during kcvxfh v8 Corrupt block relative dba: 0x02800001
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.
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 v8
Copyright © 2013, 2019, parnassusdata.com. 版权所有。 dbrecover.com
沪公网安备 31010802001377号