作者：bytehouse Oracle ACE、PostgreSQL ACE
10+年数据库架构与运维实战经验
公众号：bytehouse
墨天轮专栏：bytehouse
CSDN：Young DBA
1.错误描述
打开数据库
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 122477
Session ID: 993 Serial number: 3
SQL>
告警日志：
[oracle@wnjj-02 ~]$ tail -f /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/alert_wnjj2.log
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database wnjj and diskgroup resource ora.DATA.dg is established
Sat Jul 04 10:38:11 2026
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=92.163.96.48)(PORT=1521))' SCOPE=MEMORY SID='wnjj2';
Successful mount of redo thread 2, with mount id 1125368722
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Sat Jul 04 10:39:09 2026
Decreasing number of real time LMS from 8 to 0
Sat Jul 04 10:43:15 2026
alter database open
This instance was first to open
Beginning crash recovery of 2 threads
parallel recovery started with 32 processes
Started redo scan
Completed redo scan
read 42542 KB redo, 5798 data blocks need recovery
Started redo application at
Thread 1: logseq 6364450, block 18229
Thread 2: logseq 7156344, block 2, scn 111696614428
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6364450 Reading mem 0
Mem# 0: +DATA/wnjj/onlinelog/group_2.262.1138912889
Recovery of Online Redo Log: Thread 2 Group 4 Seq 7156344 Reading mem 0
Mem# 0: +DATA/wnjj/onlinelog/group_4.266.1138913085
Recovery of Online Redo Log: Thread 1 Group 1 Seq 6364451 Reading mem 0
Mem# 0: +DATA/wnjj/onlinelog/group_1.261.1138912887
Sat Jul 04 10:43:22 2026
Hex dump of (file 36, block 516367) in trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbwb_122373.trc
Corrupt block relative dba: 0x0907e10f (file 36, block 516367)
Bad header found during preparing block for write
Data in bad block:
type: 56 format: 7 rdba: 0x5f4b5341
last change scn: 0x001a.01a31ace seq: 0x1 flg: 0x30
spare1: 0x7 spare2: 0x54 spare3: 0x3639
consistency value in tail: 0x1ace3801
check value in block header: 0x0
block checksum disabled
Errors in file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbwb_122373.trc (incident=405103):
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/wnjj/wnjj2/incident/incdir_405103/wnjj2_dbwb_122373_i405103.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Completed redo application of 13.75MB
Errors in file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbwb_122373.trc:
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []
DBWb (ospid: 122373): terminating the instance due to error 471
Sat Jul 04 10:43:23 2026
opiodr aborting process unknown ospid (52712) as a result of ORA-1092
Sat Jul 04 10:43:23 2026
ORA-1092 : opitsk aborting process
Sat Jul 04 10:43:23 2026
System state dump requested by (instance=2, osid=122373 (DBWB)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_diag_122299_20260704104323.trc
Dumping diagnostic data in directory=[cdmp_20260704104323], requested by (instance=2, osid=122373 (DBWB)), summary=[abnormal instance termination].
Instance terminated by DBWb, pid = 122373
Sat Jul 04 10:43:35 2026
Adjusting the default value of parameter parallel_max_servers
from 3600 to 1970 due to the value of parameter processes (2000)
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = UNLIMITED
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total System Global Area size is 151 GB. For optimal performance,
prior to the next instance restart:
1. Increase the number of unused large pages by
at least 77313 (page size 2048 KB, total size 151 GB) system wide to
get 100% of the System Global Area allocated with large pages
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 192
Number of processor cores in the system is 96
Number of processor sockets in the system is 4
Private Interface 'ens5f1:1' configured from GPnP for use as a private interconnect.
[name='ens5f1:1', type=1, ip=169.254.126.213, mac=9c-c2-c4-4a-c5-52, net=169.254.0.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Private Interface 'ens5f0:1' configured from GPnP for use as a private interconnect.
[name='ens5f0:1', type=1, ip=169.254.236.26, mac=9c-c2-c4-4a-c5-51, net=169.254.128.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Public Interface 'team0' configured from GPnP for use as a public interface.
[name='team0', type=1, ip=92.163.96.46, mac=9c-c2-c4-2b-2a-c2, net=92.163.96.0/24, mask=255.255.255.0, use=public/1]
Public Interface 'team0:1' configured from GPnP for use as a public interface.
[name='team0:1', type=1, ip=92.163.96.48, mac=9c-c2-c4-2b-2a-c2, net=92.163.96.0/24, mask=255.255.255.0, use=public/1]
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: wnjj-02
Release: 5.4.17-2011.6.2.el7uek.x86_64
Version: #2 SMP Thu Sep 3 14:09:14 PDT 2020
Machine: x86_64
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initwnjj2.ora
System parameters with non-default values:
processes = 2000
spfile = "+DATA/wnjj/spfilewnjj.ora"
sga_target = 151G
control_files = "+DATA/wnjj/controlfile/current.260.1138912885"
db_block_size = 8192
compatible = "11.2.0.4.0"
cluster_database = TRUE
db_create_file_dest = "+DATA"
thread = 2
undo_tablespace = "UNDOTBS2"
instance_number = 2
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=wnjjXDB)"
remote_listener = "wnjj:1521"
audit_file_dest = "/u01/app/oracle/admin/wnjj/adump"
audit_trail = "DB"
db_name = "wnjj"
open_cursors = 1000
pga_aggregate_target = 51492M
diagnostic_dest = "/u01/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
169.254.126.213
169.254.236.26
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sat Jul 04 10:43:44 2026
PMON started with pid=2, OS id=52789
Sat Jul 04 10:43:44 2026
PSP0 started with pid=3, OS id=52791
Sat Jul 04 10:43:45 2026
VKTM started with pid=4, OS id=52794
VKTM running at (100ms) precision
Sat Jul 04 10:43:45 2026
GEN0 started with pid=5, OS id=52798
Sat Jul 04 10:43:45 2026
DIAG started with pid=6, OS id=52800
Sat Jul 04 10:43:45 2026
DBRM started with pid=7, OS id=52802
Sat Jul 04 10:43:45 2026
PING started with pid=8, OS id=52804
Sat Jul 04 10:43:45 2026
ACMS started with pid=9, OS id=52806
Sat Jul 04 10:43:45 2026
DIA0 started with pid=10, OS id=52808
Sat Jul 04 10:43:45 2026
LMON started with pid=11, OS id=52810
Sat Jul 04 10:43:45 2026
LMD0 started with pid=12, OS id=52812
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [184320 - 245760]
Sat Jul 04 10:43:45 2026
LMS0 started with pid=13, OS id=52814
Sat Jul 04 10:43:45 2026
LMS1 started with pid=14, OS id=52818
Sat Jul 04 10:43:45 2026
LMS2 started with pid=15, OS id=52822
Sat Jul 04 10:43:45 2026
LMS3 started with pid=16, OS id=52826
Sat Jul 04 10:43:45 2026
LMS4 started with pid=17, OS id=52830
Sat Jul 04 10:43:45 2026
LMS5 started with pid=18, OS id=52834
Sat Jul 04 10:43:45 2026
LMS6 started with pid=19, OS id=52838
Sat Jul 04 10:43:45 2026
LMS7 started with pid=20, OS id=52842
Sat Jul 04 10:43:45 2026
RMS0 started with pid=21, OS id=52846
Sat Jul 04 10:43:45 2026
LMHB started with pid=22, OS id=52848
Sat Jul 04 10:43:45 2026
MMAN started with pid=23, OS id=52850
Sat Jul 04 10:43:45 2026
DBW0 started with pid=24, OS id=52852
Sat Jul 04 10:43:45 2026
DBW1 started with pid=25, OS id=52854
Sat Jul 04 10:43:45 2026
DBW2 started with pid=26, OS id=52856
Sat Jul 04 10:43:45 2026
DBW3 started with pid=27, OS id=52858
Sat Jul 04 10:43:45 2026
DBW4 started with pid=28, OS id=52860
Sat Jul 04 10:43:45 2026
DBW5 started with pid=29, OS id=52862
Sat Jul 04 10:43:45 2026
DBW6 started with pid=30, OS id=52864
Sat Jul 04 10:43:45 2026
DBW7 started with pid=31, OS id=52866
Sat Jul 04 10:43:45 2026
DBW8 started with pid=32, OS id=52868
Sat Jul 04 10:43:45 2026
DBW9 started with pid=33, OS id=52870
Sat Jul 04 10:43:45 2026
DBWa started with pid=34, OS id=52872
Sat Jul 04 10:43:45 2026
DBWb started with pid=35, OS id=52874
Sat Jul 04 10:43:45 2026
DBWc started with pid=36, OS id=52876
Sat Jul 04 10:43:45 2026
DBWd started with pid=37, OS id=52878
Sat Jul 04 10:43:45 2026
DBWe started with pid=38, OS id=52880
Sat Jul 04 10:43:45 2026
DBWf started with pid=39, OS id=52882
Sat Jul 04 10:43:45 2026
DBWg started with pid=40, OS id=52884
Sat Jul 04 10:43:45 2026
DBWh started with pid=41, OS id=52886
Sat Jul 04 10:43:45 2026
DBWi started with pid=42, OS id=52888
Sat Jul 04 10:43:45 2026
DBWj started with pid=43, OS id=52890
Sat Jul 04 10:43:45 2026
DBWk started with pid=44, OS id=52892
Sat Jul 04 10:43:45 2026
DBWl started with pid=45, OS id=52894
Sat Jul 04 10:43:45 2026
DBWm started with pid=46, OS id=52896
Sat Jul 04 10:43:45 2026
DBWn started with pid=47, OS id=52898
Sat Jul 04 10:43:45 2026
LGWR started with pid=48, OS id=52900
Sat Jul 04 10:43:45 2026
CKPT started with pid=49, OS id=52902
Sat Jul 04 10:43:45 2026
SMON started with pid=50, OS id=52904
Sat Jul 04 10:43:45 2026
RECO started with pid=51, OS id=52906
Sat Jul 04 10:43:45 2026
RBAL started with pid=52, OS id=52908
Sat Jul 04 10:43:45 2026
ASMB started with pid=53, OS id=52910
Sat Jul 04 10:43:45 2026
MMON started with pid=54, OS id=52912
Sat Jul 04 10:43:45 2026
MMNL started with pid=55, OS id=52916
Sat Jul 04 10:43:45 2026
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
NOTE: initiating MARK startup
starting up 1 shared server(s) ...
Starting background process MARK
Sat Jul 04 10:43:45 2026
MARK started with pid=57, OS id=52920
NOTE: MARK has subscribed
lmon registered with NM - instance number 2 (internal mem no 1)
Reconfiguration started (old inc 0, new inc 2)
List of instances:
2 (myinst: 2)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Sat Jul 04 10:43:48 2026
Sweep [inc][405103]: completed
Sweep [inc2][405103]: completed
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 4: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 6: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 5: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 7: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Sat Jul 04 10:43:49 2026
LCK0 started with pid=60, OS id=52935
Starting background process RSMN
Sat Jul 04 10:43:49 2026
RSMN started with pid=61, OS id=52937
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle
Sat Jul 04 10:43:50 2026
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=92.163.96.48)(PORT=1521))' SCOPE=MEMORY SID='wnjj2';
ALTER DATABASE MOUNT /* db agent *//* {0:53:15} */
This instance was first to mount
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database wnjj and diskgroup resource ora.DATA.dg is established
Successful mount of redo thread 2, with mount id 1125364454
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT /* db agent *//* {0:53:15} */
ALTER DATABASE OPEN /* db agent *//* {0:53:15} */
This instance was first to open
Beginning crash recovery of 2 threads
parallel recovery started with 32 processes
Started redo scan
Sat Jul 04 10:44:00 2026
Completed redo scan
read 42542 KB redo, 5798 data blocks need recovery
Started redo application at
Thread 1: logseq 6364450, block 18229
Thread 2: logseq 7156344, block 2, scn 111696614428
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6364450 Reading mem 0
Mem# 0: +DATA/wnjj/onlinelog/group_2.262.1138912889
Recovery of Online Redo Log: Thread 2 Group 4 Seq 7156344 Reading mem 0
Mem# 0: +DATA/wnjj/onlinelog/group_4.266.1138913085
Recovery of Online Redo Log: Thread 1 Group 1 Seq 6364451 Reading mem 0
Mem# 0: +DATA/wnjj/onlinelog/group_1.261.1138912887
Sat Jul 04 10:44:02 2026
Hex dump of (file 36, block 516367) in trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbwb_52874.trc
Corrupt block relative dba: 0x0907e10f (file 36, block 516367)
Bad header found during preparing block for write
Data in bad block:
type: 56 format: 7 rdba: 0x5f4b5341
last change scn: 0x001a.01a31ace seq: 0x1 flg: 0x30
spare1: 0x7 spare2: 0x54 spare3: 0x3639
consistency value in tail: 0x1ace3801
check value in block header: 0x0
block checksum disabled
Errors in file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbwb_52874.trc (incident=421103):
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/wnjj/wnjj2/incident/incdir_421103/wnjj2_dbwb_52874_i421103.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Completed redo application of 13.75MB
Sat Jul 04 10:44:03 2026
Dumping diagnostic data in directory=[cdmp_20260704104403], requested by (instance=2, osid=52874 (DBWB)), summary=[incident=421103].
Errors in file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbwb_52874.trc:
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []
DBWb (ospid: 52874): terminating the instance due to error 471
Sat Jul 04 10:44:03 2026
opiodr aborting process unknown ospid (55724) as a result of ORA-1092
Sat Jul 04 10:44:03 2026
opiodr aborting process unknown ospid (55726) as a result of ORA-1092
Sat Jul 04 10:44:03 2026
ORA-1092 : opitsk aborting process
Sat Jul 04 10:44:03 2026
ORA-1092 : opitsk aborting process
System state dump requested by (instance=2, osid=52874 (DBWB)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_diag_52800_20260704104403.trc
Dumping diagnostic data in directory=[cdmp_20260704104403], requested by (instance=2, osid=52874 (DBWB)), summary=[abnormal instance termination].
Instance terminated by DBWb, pid = 52874
2.故障定位
1. 关键报错摘要
Corrupt block relative dba: 0x0907e10f (file 36, block 516367)
Bad header found during preparing block for write
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1]
DBWb terminating the instance due to error 471
Instance terminated by DBWb
故障本质
- 数据块物理损坏：文件36，块516367头部校验异常（坏块），DBWn写缓冲区时检测到非法块头；
- 内部错误
kcbzpbuf_1是Oracle缓冲区校验失败，触发致命错误471，DBW进程直接终止实例； - 现象循环：启动→mount→open→崩溃→自动重启，无限循环。
2. 环境信息
- 版本：Oracle 11.2.0.4 RAC，2节点，当前wnjj2实例
- 存储：ASM磁盘组DATA
- SGA：151G，db_block_size=8k
- 坏块位置：
file#36 block#516367
3.处理方案
步骤1：先关闭自动重启，防止无限循环
# 1. 关闭该实例CRS自动启动
srvctl stop instance -d wnjj -i wnjj2
srvctl modify instance -d wnjj -i wnjj2 -s disable
# 2. 仅单实例mount，不open
sqlplus / as sysdba
startup mount;
步骤2：定位file#36对应的数据文件
SQL> SELECT FILE#, NAME FROM V$DATAFILE WHERE FILE#=36;
FILE# NAME
--------------------------------------------------------------------------------
36 +DATA/wnjj/datafile/rm_data.298.1138994805
SQL>
输出会返回ASM上的数据文件路径，记下来。
步骤3：校验坏块类型（物理坏块/逻辑坏块）
方式1：RMAN校验全库（推荐）
[oracle@wnjj-02 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Jul 4 10:49:24 2026
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: WNJJ (DBID=1026516212, not open)
RMAN> VALIDATE CHECK LOGICAL DATABASE;
Starting validate at 2026-07-04 10:49:28
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1089 instance=wnjj2 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00006 name=+DATA/wnjj/datafile/rm_data.268.1138994405
input datafile file number=00022 name=+DATA/wnjj/datafile/rm_data.284.1138994749
input datafile file number=00026 name=+DATA/wnjj/datafile/rm_data.288.1138994765
input datafile file number=00030 name=+DATA/wnjj/datafile/rm_data.292.1138994781
input datafile file number=00034 name=+DATA/wnjj/datafile/rm_data.296.1138994797
input datafile file number=00038 name=+DATA/wnjj/datafile/rm_data.300.1138994813
input datafile file number=00042 name=+DATA/wnjj/datafile/rm_data.304.1138994829
input datafile file number=00046 name=+DATA/wnjj/datafile/rm_data.308.1138994845
input datafile file number=00050 name=+DATA/wnjj/datafile/rm_data.312.1138994861
input datafile file number=00054 name=+DATA/wnjj/datafile/rm_data.316.1138994877
input datafile file number=00058 name=+DATA/wnjj/datafile/rm_data.320.1138994895
input datafile file number=00062 name=+DATA/wnjj/datafile/rm_data.324.1138994911
input datafile file number=00066 name=+DATA/wnjj/datafile/rm_data.328.1138994925
input datafile file number=00070 name=+DATA/wnjj/datafile/rm_data.332.1138994943
input datafile file number=00074 name=+DATA/wnjj/datafile/rm_data.336.1138994959
input datafile file number=00080 name=+DATA/wnjj/datafile/rm_data.342.1138994983
input datafile file number=00084 name=+DATA/wnjj/datafile/rm_data.346.1138994999
input datafile file number=00094 name=+DATA/wnjj/datafile/rm_data.356.1141811523
input datafile file number=00098 name=+DATA/wnjj/datafile/sysaux.360.1141894091
input datafile file number=00103 name=+DATA/wnjj/datafile/rm_data.365.1141979111
input datafile file number=00107 name=+DATA/wnjj/datafile/rm_data.369.1141979519
input datafile file number=00111 name=+DATA/wnjj/datafile/rm_data.373.1141980107
input datafile file number=00115 name=+DATA/wnjj/datafile/rm_data.377.1141980417
input datafile file number=00122 name=+DATA/wnjj/datafile/rm_data.384.1141981813
input datafile file number=00126 name=+DATA/wnjj/datafile/rm_data.388.1141982221
input datafile file number=00130 name=+DATA/wnjj/datafile/rm_data.392.1141982817
input datafile file number=00134 name=+DATA/wnjj/datafile/rm_data.396.1141983337
input datafile file number=00138 name=+DATA/wnjj/datafile/rm_data.400.1144509483
input datafile file number=00142 name=+DATA/wnjj/datafile/rm_data.404.1144509983
input datafile file number=00146 name=+DATA/wnjj/datafile/rm_data.408.1144510267
input datafile file number=00150 name=+DATA/wnjj/datafile/rm_data.412.1144510545
input datafile file number=00154 name=+DATA/wnjj/datafile/rm_data.416.1144511121
input datafile file number=00158 name=+DATA/wnjj/datafile/rm_data.420.1144511823
input datafile file number=00162 name=+DATA/wnjj/datafile/rm_data.424.1144512337
input datafile file number=00170 name=+DATA/wnjj/datafile/rm_index.432.1179477401
input datafile file number=00176 name=+DATA/wnjj/datafile/system.437.1224950655
input datafile file number=00180 name=+DATA/wnjj/datafile/rm_data.441.1233909267
input datafile file number=00184 name=+DATA/wnjj/datafile/rm_data.445.1236416805
input datafile file number=00188 name=+DATA/wnjj/datafile/rm_data.449.1236515237
input datafile file number=00192 name=+DATA/wnjj/datafile/rm_data.453.1236515995
input datafile file number=00196 name=+DATA/wnjj/datafile/rm_data.457.1236516665
input datafile file number=00200 name=+DATA/wnjj/datafile/rm_data.461.1236517563
input datafile file number=00118 name=+DATA/wnjj/datafile/rm_data.380.1141980635
input datafile file number=00005 name=+DATA/wnjj/datafile/undotbs2.264.1138913031
input datafile file number=00015 name=+DATA/wnjj/datafile/rm_index.277.1138994603
input datafile file number=00078 name=+DATA/wnjj/datafile/rm_img.340.1138994975
input datafile file number=00002 name=+DATA/wnjj/datafile/sysaux.257.1138912785
input datafile file number=00010 name=+DATA/wnjj/datafile/frm_data.272.1138994423
input datafile file number=00004 name=+DATA/wnjj/datafile/users.259.1138912785
input datafile file number=00019 name=+DATA/wnjj/datafile/frm_index.281.1138994619
^[[Dchannel ORA_DISK_1: validation complete, elapsed time: 01:36:35
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 16765 326420 111696630825
File Name: +DATA/wnjj/datafile/sysaux.257.1138912785
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 160319
Index 0 109659
Other 0 39657
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 9 36960 111696651376
File Name: +DATA/wnjj/datafile/users.259.1138912785
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3902
Index 0 32224
Other 0 825
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 1 3075200 111696651379
File Name: +DATA/wnjj/datafile/undotbs2.264.1138913031
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 3075199
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 7887 3932160 111696630397
File Name: +DATA/wnjj/datafile/rm_data.268.1138994405
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 298628
Index 0 24151
Other 0 3601494
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 1656 76800 111696630953
File Name: +DATA/wnjj/datafile/frm_data.272.1138994423
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 47352
Index 0 26026
Other 0 1766
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15 OK 0 3833 2214400 111696631230
File Name: +DATA/wnjj/datafile/rm_index.277.1138994603
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 2188847
Other 0 21720
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19 OK 0 215 12800 111696619678
File Name: +DATA/wnjj/datafile/frm_index.281.1138994619
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 12357
Other 0 228
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
22 OK 0 129 3932160 111696628683
File Name: +DATA/wnjj/datafile/rm_data.284.1138994749
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 330584
Index 0 33388
Other 0 3568059
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
26 OK 0 158 3932160 111696630917
File Name: +DATA/wnjj/datafile/rm_data.288.1138994765
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 357290
Index 0 25406
Other 0 3549306
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
30 OK 0 8 3932160 111696630942
File Name: +DATA/wnjj/datafile/rm_data.292.1138994781
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 322858
Index 0 22512
Other 0 3586782
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
34 OK 0 53 3932160 111696628063
File Name: +DATA/wnjj/datafile/rm_data.296.1138994797
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 329118
Index 0 17423
Other 0 3585566
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
38 OK 0 223 3932160 111696630680
File Name: +DATA/wnjj/datafile/rm_data.300.1138994813
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 322231
Index 0 17401
Other 0 3592305
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
42 OK 0 210 3932160 111696630676
File Name: +DATA/wnjj/datafile/rm_data.304.1138994829
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 338670
Index 0 24161
Other 0 3569119
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
46 OK 0 1144 3932160 111696628713
File Name: +DATA/wnjj/datafile/rm_data.308.1138994845
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 297726
Index 0 26334
Other 0 3606956
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
50 OK 0 3851 3932160 111696628579
File Name: +DATA/wnjj/datafile/rm_data.312.1138994861
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 335662
Index 0 27846
Other 0 3564801
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
54 OK 0 1046 3932160 111696630780
File Name: +DATA/wnjj/datafile/rm_data.316.1138994877
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 335370
Index 0 27802
Other 0 3567942
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
58 OK 0 27 3932160 111696630950
File Name: +DATA/wnjj/datafile/rm_data.320.1138994895
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 323443
Index 0 28542
Other 0 3580148
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
62 OK 0 325 3932160 111696630967
File Name: +DATA/wnjj/datafile/rm_data.324.1138994911
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 314828
Index 0 20288
Other 0 3596719
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
66 FAILED 0 1263 3932160 111696631186
File Name: +DATA/wnjj/datafile/rm_data.328.1138994925
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 2 299336
Index 0 19420
Other 0 3612141
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
70 FAILED 0 408 3932160 111696630600
File Name: +DATA/wnjj/datafile/rm_data.332.1138994943
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 1 315979
Index 0 22988
Other 0 3592785
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
74 FAILED 0 73 3932160 111696631241
File Name: +DATA/wnjj/datafile/rm_data.336.1138994959
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 1 298888
Index 0 17354
Other 0 3615845
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
78 OK 0 43959 1090560 111672761093
File Name: +DATA/wnjj/datafile/rm_img.340.1138994975
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 209
Index 0 839
Other 0 1045553
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
80 OK 0 177 3932160 111696554456
File Name: +DATA/wnjj/datafile/rm_data.342.1138994983
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 264060
Index 0 15750
Other 0 3652173
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
84 OK 0 5 3932160 111696578629
File Name: +DATA/wnjj/datafile/rm_data.346.1138994999
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 256187
Index 0 16085
Other 0 3659883
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
94 OK 0 1 3932160 111696630911
File Name: +DATA/wnjj/datafile/rm_data.356.1141811523
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 172331
Index 0 2544
Other 0 3757284
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
98 OK 0 1 3932160 111696630825
File Name: +DATA/wnjj/datafile/sysaux.360.1141894091
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2829732
Index 0 1089568
Other 0 12859
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
103 OK 0 1 3932160 111696425830
File Name: +DATA/wnjj/datafile/rm_data.365.1141979111
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 177822
Index 0 3690
Other 0 3750647
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
107 OK 0 1 3932160 111696397354
File Name: +DATA/wnjj/datafile/rm_data.369.1141979519
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 181276
Index 0 3690
Other 0 3747193
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
111 OK 0 1 3932160 111696369357
File Name: +DATA/wnjj/datafile/rm_data.373.1141980107
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 173076
Index 0 2670
Other 0 3756413
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
115 OK 0 1 3932160 111696628193
File Name: +DATA/wnjj/datafile/rm_data.377.1141980417
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 187019
Index 0 12000
Other 0 3733140
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
118 OK 0 1 3840000 111696322220
File Name: +DATA/wnjj/datafile/rm_data.380.1141980635
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 177316
Index 0 5078
Other 0 3657605
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
122 OK 0 1 3932160 111696613494
File Name: +DATA/wnjj/datafile/rm_data.384.1141981813
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 165392
Index 0 5106
Other 0 3761661
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
126 OK 0 1 3932160 111696619138
File Name: +DATA/wnjj/datafile/rm_data.388.1141982221
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 210451
Index 0 21085
Other 0 3700623
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
130 OK 0 1 3932160 111696630841
File Name: +DATA/wnjj/datafile/rm_data.392.1141982817
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 190655
Index 0 22896
Other 0 3718608
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
134 OK 0 1 3932160 111696623395
File Name: +DATA/wnjj/datafile/rm_data.396.1141983337
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 203202
Index 0 19386
Other 0 3709571
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
138 OK 0 1 3932160 111696627119
File Name: +DATA/wnjj/datafile/rm_data.400.1144509483
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 211952
Index 0 12660
Other 0 3707547
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
142 OK 0 1 3932160 111696627909
File Name: +DATA/wnjj/datafile/rm_data.404.1144509983
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 208504
Index 0 24240
Other 0 3699415
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
146 OK 0 1 3932160 111696605475
File Name: +DATA/wnjj/datafile/rm_data.408.1144510267
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 189420
Index 0 16675
Other 0 3726064
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
150 OK 0 1 3932160 111696628144
File Name: +DATA/wnjj/datafile/rm_data.412.1144510545
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 237885
Index 0 15973
Other 0 3678301
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
154 OK 0 1 3932160 111696631230
File Name: +DATA/wnjj/datafile/rm_data.416.1144511121
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 217149
Index 0 16395
Other 0 3698615
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
158 OK 0 1 3932160 111696627685
File Name: +DATA/wnjj/datafile/rm_data.420.1144511823
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 268036
Index 0 9350
Other 0 3654773
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
162 FAILED 0 1 3932160 111696630482
File Name: +DATA/wnjj/datafile/rm_data.424.1144512337
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 242112
Index 1 7210
Other 0 3682837
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
170 FAILED 0 365 3932160 111696651378
File Name: +DATA/wnjj/datafile/rm_index.432.1179477401
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 1 3921561
Other 0 10234
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
176 OK 0 2588877 3932160 111696630951
File Name: +DATA/wnjj/datafile/system.437.1224950655
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1343146
Index 0 10
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
180 OK 0 1 3932160 111696651376
File Name: +DATA/wnjj/datafile/rm_data.441.1233909267
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 36616
Index 0 2922
Other 0 3892621
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
184 OK 0 5761 3932160 111696630412
File Name: +DATA/wnjj/datafile/rm_data.445.1236416805
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1650
Index 0 8562
Other 0 3916187
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
188 OK 0 2031009 3932160 111695936830
File Name: +DATA/wnjj/datafile/rm_data.449.1236515237
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1524
Index 0 472
Other 0 1899155
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
192 OK 0 2285185 3932160 111696241552
File Name: +DATA/wnjj/datafile/rm_data.453.1236515995
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1637657
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
196 OK 0 2342529 3932160 111695873262
File Name: +DATA/wnjj/datafile/rm_data.457.1236516665
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1580313
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
200 OK 0 2375553 3932160 111696492187
File Name: +DATA/wnjj/datafile/rm_data.461.1236517563
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 756
Index 0 8562
Other 0 1547289
validate found one or more corrupt blocks
See trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_ora_75085.trc for details
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00013 name=+DATA/wnjj/datafile/rm_data.275.1138994595
input datafile file number=00023 name=+DATA/wnjj/datafile/rm_data.285.1138994753
input datafile file number=00027 name=+DATA/wnjj/datafile/rm_data.289.1138994769
input datafile file number=00031 name=+DATA/wnjj/datafile/rm_data.293.1138994785
input datafile file number=00035 name=+DATA/wnjj/datafile/rm_data.297.1138994801
input datafile file number=00039 name=+DATA/wnjj/datafile/rm_data.301.1138994817
input datafile file number=00043 name=+DATA/wnjj/datafile/rm_data.305.1138994833
input datafile file number=00047 name=+DATA/wnjj/datafile/rm_data.309.1138994849
input datafile file number=00051 name=+DATA/wnjj/datafile/rm_data.313.1138994867
input datafile file number=00055 name=+DATA/wnjj/datafile/rm_data.317.1138994881
input datafile file number=00059 name=+DATA/wnjj/datafile/rm_data.321.1138994899
input datafile file number=00063 name=+DATA/wnjj/datafile/rm_data.325.1138994915
input datafile file number=00067 name=+DATA/wnjj/datafile/rm_data.329.1138994929
input datafile file number=00071 name=+DATA/wnjj/datafile/rm_data.333.1138994947
input datafile file number=00075 name=+DATA/wnjj/datafile/rm_data.337.1138994963
input datafile file number=00081 name=+DATA/wnjj/datafile/rm_data.343.1138994987
input datafile file number=00085 name=+DATA/wnjj/datafile/rm_data.347.1138995003
input datafile file number=00095 name=+DATA/wnjj/datafile/rm_data.357.1141811603
input datafile file number=00099 name=+DATA/wnjj/datafile/system.361.1141894243
input datafile file number=00104 name=+DATA/wnjj/datafile/rm_data.366.1141979213
input datafile file number=00108 name=+DATA/wnjj/datafile/rm_data.370.1141979691
input datafile file number=00112 name=+DATA/wnjj/datafile/rm_data.374.1141980179
input datafile file number=00116 name=+DATA/wnjj/datafile/rm_data.378.1141980487
input datafile file number=00123 name=+DATA/wnjj/datafile/rm_data.385.1141981993
input datafile file number=00127 name=+DATA/wnjj/datafile/rm_data.389.1141982455
input datafile file number=00131 name=+DATA/wnjj/datafile/rm_data.393.1141982899
input datafile file number=00135 name=+DATA/wnjj/datafile/rm_data.397.1144509087
input datafile file number=00139 name=+DATA/wnjj/datafile/rm_data.401.1144509573
input datafile file number=00143 name=+DATA/wnjj/datafile/rm_data.405.1144510047
input datafile file number=00147 name=+DATA/wnjj/datafile/rm_data.409.1144510335
input datafile file number=00151 name=+DATA/wnjj/datafile/rm_data.413.1144510727
input datafile file number=00155 name=+DATA/wnjj/datafile/rm_data.417.1144511195
input datafile file number=00159 name=+DATA/wnjj/datafile/rm_data.421.1144511893
input datafile file number=00163 name=+DATA/wnjj/datafile/rm_data.425.1144512439
input datafile file number=00173 name=+DATA/wnjj/datafile/rm_data.434.1222590545
input datafile file number=00177 name=+DATA/wnjj/datafile/rm_index.438.1229964017
input datafile file number=00181 name=+DATA/wnjj/datafile/rm_data.442.1236416375
input datafile file number=00185 name=+DATA/wnjj/datafile/rm_data.446.1236416965
input datafile file number=00189 name=+DATA/wnjj/datafile/rm_data.450.1236515417
input datafile file number=00193 name=+DATA/wnjj/datafile/rm_data.454.1236516127
input datafile file number=00197 name=+DATA/wnjj/datafile/rm_data.458.1236516793
input datafile file number=00090 name=+DATA/wnjj/datafile/rm_data.352.1141670853
input datafile file number=00093 name=+DATA/wnjj/datafile/rm_data.355.1141671515
input datafile file number=00119 name=+DATA/wnjj/datafile/rm_data.381.1141980717
input datafile file number=00014 name=+DATA/wnjj/datafile/rm_img.276.1138994599
input datafile file number=00089 name=+DATA/wnjj/datafile/rm_img.351.1138995019
input datafile file number=00167 name=+DATA/wnjj/datafile/frm_index.429.1169193991
input datafile file number=00001 name=+DATA/wnjj/datafile/system.256.1138912785
input datafile file number=00166 name=+DATA/wnjj/datafile/users.428.1165821413
input datafile file number=00172 name=+DATA/wnjj/datafile/users.433.1222590361
input datafile file number=00018 name=+DATA/wnjj/datafile/gis_rm_data.280.1138994615
channel ORA_DISK_1: validation complete, elapsed time: 01:35:35
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 14282 147203 111696651376
File Name: +DATA/wnjj/datafile/system.256.1138912785
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 110868
Index 0 18610
Other 0 3440
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13 OK 0 1 3932160 111696605714
File Name: +DATA/wnjj/datafile/rm_data.275.1138994595
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 328268
Index 0 30765
Other 0 3573126
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14 OK 0 33039 1134080 111690504723
File Name: +DATA/wnjj/datafile/rm_img.276.1138994599
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 252
Index 0 994
Other 0 1099795
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18 OK 0 12673 12800 1200670
File Name: +DATA/wnjj/datafile/gis_rm_data.280.1138994615
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
23 OK 0 117 3932160 111696625352
File Name: +DATA/wnjj/datafile/rm_data.285.1138994753
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 358877
Index 0 31806
Other 0 3541360
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
27 OK 0 9 3932160 111696627032
File Name: +DATA/wnjj/datafile/rm_data.289.1138994769
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 326977
Index 0 30205
Other 0 3574969
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
31 OK 0 279 3932160 111696631292
File Name: +DATA/wnjj/datafile/rm_data.293.1138994785
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 301119
Index 0 16957
Other 0 3613805
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
35 OK 0 851 3932160 111696627210
File Name: +DATA/wnjj/datafile/rm_data.297.1138994801
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 334452
Index 0 17144
Other 0 3579713
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
39 OK 0 119 3932160 111696629625
File Name: +DATA/wnjj/datafile/rm_data.301.1138994817
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 322391
Index 0 15468
Other 0 3594182
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
43 OK 0 171 3932160 111696624932
File Name: +DATA/wnjj/datafile/rm_data.305.1138994833
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 335061
Index 0 26282
Other 0 3570646
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
47 OK 0 655 3932160 111696629592
File Name: +DATA/wnjj/datafile/rm_data.309.1138994849
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 336191
Index 0 27136
Other 0 3568178
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
51 OK 0 108 3932160 111696628724
File Name: +DATA/wnjj/datafile/rm_data.313.1138994867
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 333581
Index 0 27416
Other 0 3571055
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
55 OK 0 7 3932160 111696630767
File Name: +DATA/wnjj/datafile/rm_data.317.1138994881
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 343022
Index 0 27855
Other 0 3561276
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
59 OK 0 67 3932160 111696629512
File Name: +DATA/wnjj/datafile/rm_data.321.1138994899
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 321964
Index 0 26688
Other 0 3583441
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
63 OK 0 1133 3932160 111696631220
File Name: +DATA/wnjj/datafile/rm_data.325.1138994915
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 306433
Index 0 19914
Other 0 3604680
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
67 FAILED 0 2224 3932160 111696631058
File Name: +DATA/wnjj/datafile/rm_data.329.1138994929
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 1 322409
Index 0 17686
Other 0 3589841
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
71 OK 0 1 3932160 111696614998
File Name: +DATA/wnjj/datafile/rm_data.333.1138994947
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 276755
Index 0 23582
Other 0 3631822
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
75 OK 0 1 3932160 111696623572
File Name: +DATA/wnjj/datafile/rm_data.337.1138994963
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 292772
Index 0 16853
Other 0 3622534
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
81 OK 0 1 3932160 111696552236
File Name: +DATA/wnjj/datafile/rm_data.343.1138994987
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 249766
Index 0 16644
Other 0 3665749
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
85 OK 0 127 3932160 111696628604
File Name: +DATA/wnjj/datafile/rm_data.347.1138995003
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 248288
Index 0 16865
Other 0 3666880
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
89 OK 0 30703 1126400 111365024445
File Name: +DATA/wnjj/datafile/rm_img.351.1138995019
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 126
Index 0 772
Other 0 1094799
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
90 OK 0 1 3840000 111696508062
File Name: +DATA/wnjj/datafile/rm_data.352.1141670853
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 165576
Index 0 3312
Other 0 3671111
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
93 OK 0 1 3840000 111696479055
File Name: +DATA/wnjj/datafile/rm_data.355.1141671515
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 161848
Index 0 2419
Other 0 3675732
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
95 OK 0 1 3932160 111696476317
File Name: +DATA/wnjj/datafile/rm_data.357.1141811603
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 159497
Index 0 2418
Other 0 3770244
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
99 OK 0 8514 3932160 111684245748
File Name: +DATA/wnjj/datafile/system.361.1141894243
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3923062
Index 0 456
Other 0 128
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
104 OK 0 1 3932160 111696564801
File Name: +DATA/wnjj/datafile/rm_data.366.1141979213
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 189458
Index 0 3690
Other 0 3739011
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
108 OK 0 1 3932160 111696608304
File Name: +DATA/wnjj/datafile/rm_data.370.1141979691
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 178321
Index 0 3690
Other 0 3750148
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
112 OK 0 1 3932160 111696364480
File Name: +DATA/wnjj/datafile/rm_data.374.1141980179
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 168091
Index 0 3942
Other 0 3760126
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
116 OK 0 1 3932160 111696336999
File Name: +DATA/wnjj/datafile/rm_data.378.1141980487
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 184969
Index 0 12126
Other 0 3735064
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
119 OK 0 1 3840000 111696627224
File Name: +DATA/wnjj/datafile/rm_data.381.1141980717
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 165313
Index 0 12579
Other 0 3662107
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
123 OK 0 1 3932160 111696623235
File Name: +DATA/wnjj/datafile/rm_data.385.1141981993
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 191013
Index 0 13065
Other 0 3728081
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
127 OK 0 1 3932160 111696612540
File Name: +DATA/wnjj/datafile/rm_data.389.1141982455
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 196591
Index 0 20058
Other 0 3715510
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
131 OK 0 1 3932160 111696630536
File Name: +DATA/wnjj/datafile/rm_data.393.1141982899
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 207813
Index 0 20220
Other 0 3704126
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
135 OK 0 1 3932160 111696625549
File Name: +DATA/wnjj/datafile/rm_data.397.1144509087
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 196609
Index 0 19372
Other 0 3716178
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
139 OK 0 1 3932160 111696627674
File Name: +DATA/wnjj/datafile/rm_data.401.1144509573
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 204858
Index 0 21518
Other 0 3705783
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
143 OK 0 1 3932160 111696624140
File Name: +DATA/wnjj/datafile/rm_data.405.1144510047
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 223601
Index 0 26600
Other 0 3681958
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
147 OK 0 1 3932160 111696615425
File Name: +DATA/wnjj/datafile/rm_data.409.1144510335
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 182750
Index 0 17523
Other 0 3731886
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
151 OK 0 1 3932160 111696627219
File Name: +DATA/wnjj/datafile/rm_data.413.1144510727
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 216897
Index 0 24221
Other 0 3691041
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
155 OK 0 1 3932160 111696631326
File Name: +DATA/wnjj/datafile/rm_data.417.1144511195
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 218866
Index 0 15331
Other 0 3697962
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
159 OK 0 1 3932160 111696563876
File Name: +DATA/wnjj/datafile/rm_data.421.1144511893
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 229907
Index 0 8388
Other 0 3693864
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
163 OK 0 1 3932160 111696629864
File Name: +DATA/wnjj/datafile/rm_data.425.1144512439
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 241478
Index 0 7610
Other 0 3683071
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
166 OK 0 260 131072 111696651378
File Name: +DATA/wnjj/datafile/users.428.1165821413
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 25910
Index 0 103821
Other 0 1081
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
167 OK 0 387329 393216 111696573180
File Name: +DATA/wnjj/datafile/frm_index.429.1169193991
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 5722
Other 0 165
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
172 OK 0 23432 131072 111696630412
File Name: +DATA/wnjj/datafile/users.433.1222590361
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1162
Index 0 27592
Other 0 78886
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
173 OK 0 1 3932160 111696488746
File Name: +DATA/wnjj/datafile/rm_data.434.1222590545
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 64027
Index 0 2954
Other 0 3865178
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
177 OK 0 1384737 3932160 111696631292
File Name: +DATA/wnjj/datafile/rm_index.438.1229964017
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 2542549
Other 0 4874
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
181 OK 0 4721 3932160 111695745537
File Name: +DATA/wnjj/datafile/rm_data.442.1236416375
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 34404
Index 0 252
Other 0 3892783
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
185 OK 0 5761 3932160 111696040971
File Name: +DATA/wnjj/datafile/rm_data.446.1236416965
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2546
Index 0 8562
Other 0 3915291
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
189 OK 0 2188871 3932160 111695929119
File Name: +DATA/wnjj/datafile/rm_data.450.1236515417
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 631
Index 0 504
Other 0 1742154
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
193 OK 0 2309761 3932160 111695899322
File Name: +DATA/wnjj/datafile/rm_data.454.1236516127
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1613081
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
197 OK 0 2350849 3932160 111696315220
File Name: +DATA/wnjj/datafile/rm_data.458.1236516793
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1571993
validate found one or more corrupt blocks
See trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_ora_75085.trc for details
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00020 name=+DATA/wnjj/datafile/rm_data.282.1138994741
input datafile file number=00024 name=+DATA/wnjj/datafile/rm_data.286.1138994755
input datafile file number=00028 name=+DATA/wnjj/datafile/rm_data.290.1138994773
input datafile file number=00032 name=+DATA/wnjj/datafile/rm_data.294.1138994789
input datafile file number=00036 name=+DATA/wnjj/datafile/rm_data.298.1138994805
input datafile file number=00040 name=+DATA/wnjj/datafile/rm_data.302.1138994821
input datafile file number=00044 name=+DATA/wnjj/datafile/rm_data.306.1138994837
input datafile file number=00048 name=+DATA/wnjj/datafile/rm_data.310.1138994853
input datafile file number=00052 name=+DATA/wnjj/datafile/rm_data.314.1138994869
input datafile file number=00056 name=+DATA/wnjj/datafile/rm_data.318.1138994887
input datafile file number=00060 name=+DATA/wnjj/datafile/rm_data.322.1138994903
input datafile file number=00064 name=+DATA/wnjj/datafile/rm_data.326.1138994919
input datafile file number=00068 name=+DATA/wnjj/datafile/rm_data.330.1138994933
input datafile file number=00072 name=+DATA/wnjj/datafile/rm_data.334.1138994951
input datafile file number=00076 name=+DATA/wnjj/datafile/rm_data.338.1138994967
input datafile file number=00082 name=+DATA/wnjj/datafile/rm_data.344.1138994991
input datafile file number=00086 name=+DATA/wnjj/datafile/rm_data.348.1138995007
input datafile file number=00096 name=+DATA/wnjj/datafile/rm_data.358.1141893241
input datafile file number=00100 name=+DATA/wnjj/datafile/frm_data.362.1141894393
input datafile file number=00105 name=+DATA/wnjj/datafile/rm_data.367.1141979341
input datafile file number=00109 name=+DATA/wnjj/datafile/rm_data.371.1141979907
input datafile file number=00113 name=+DATA/wnjj/datafile/rm_data.375.1141980247
input datafile file number=00120 name=+DATA/wnjj/datafile/rm_data.382.1141981647
input datafile file number=00124 name=+DATA/wnjj/datafile/rm_data.386.1141982071
input datafile file number=00128 name=+DATA/wnjj/datafile/rm_data.390.1141982557
input datafile file number=00132 name=+DATA/wnjj/datafile/rm_data.394.1141983019
input datafile file number=00136 name=+DATA/wnjj/datafile/rm_data.398.1144509209
input datafile file number=00140 name=+DATA/wnjj/datafile/rm_data.402.1144509695
input datafile file number=00144 name=+DATA/wnjj/datafile/rm_data.406.1144510127
input datafile file number=00148 name=+DATA/wnjj/datafile/rm_data.410.1144510403
input datafile file number=00152 name=+DATA/wnjj/datafile/rm_data.414.1144510845
input datafile file number=00156 name=+DATA/wnjj/datafile/rm_data.418.1144511283
input datafile file number=00160 name=+DATA/wnjj/datafile/rm_data.422.1144511967
input datafile file number=00164 name=+DATA/wnjj/datafile/rm_data.426.1144512897
input datafile file number=00174 name=+DATA/wnjj/datafile/rm_data.435.1222590883
input datafile file number=00178 name=+DATA/wnjj/datafile/rm_data.439.1231078673
input datafile file number=00182 name=+DATA/wnjj/datafile/rm_data.443.1236416555
input datafile file number=00186 name=+DATA/wnjj/datafile/rm_data.447.1236417347
input datafile file number=00190 name=+DATA/wnjj/datafile/rm_data.451.1236515559
input datafile file number=00194 name=+DATA/wnjj/datafile/rm_data.455.1236516249
input datafile file number=00198 name=+DATA/wnjj/datafile/rm_data.459.1236517145
input datafile file number=00091 name=+DATA/wnjj/datafile/rm_data.353.1141670995
input datafile file number=00101 name=+DATA/wnjj/datafile/rm_data.363.1141978913
input datafile file number=00171 name=+DATA/wnjj/datafile/sysaux05.dbf
input datafile file number=00088 name=+DATA/wnjj/datafile/rm_img.350.1138995015
input datafile file number=00007 name=+DATA/wnjj/datafile/rm_img.269.1138994409
input datafile file number=00169 name=+DATA/wnjj/datafile/frm_index.431.1169194083
input datafile file number=00012 name=+DATA/wnjj/datafile/frm_index.274.1138994431
input datafile file number=00016 name=+DATA/wnjj/datafile/rm_stat.278.1138994607
channel ORA_DISK_1: validation complete, elapsed time: 01:39:16
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 40846 1126400 111672783107
File Name: +DATA/wnjj/datafile/rm_img.269.1138994409
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 134
Index 0 971
Other 0 1084449
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12 OK 0 776 17920 111696630118
File Name: +DATA/wnjj/datafile/frm_index.274.1138994431
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 16833
Other 0 311
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16 OK 0 11175 12800 97465676086
File Name: +DATA/wnjj/datafile/rm_stat.278.1138994607
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 959
Index 0 427
Other 0 239
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
20 OK 0 53 3932160 111696625554
File Name: +DATA/wnjj/datafile/rm_data.282.1138994741
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 343313
Index 0 24888
Other 0 3563906
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
24 OK 0 252 3932160 111696631205
File Name: +DATA/wnjj/datafile/rm_data.286.1138994755
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 354933
Index 0 31498
Other 0 3545477
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
28 OK 0 121 3932160 111696629645
File Name: +DATA/wnjj/datafile/rm_data.290.1138994773
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 318806
Index 0 22594
Other 0 3590639
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
32 OK 0 61 3932160 111696630942
File Name: +DATA/wnjj/datafile/rm_data.294.1138994789
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 323239
Index 0 16683
Other 0 3592177
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
36 OK 0 83 3932160 111696614408
File Name: +DATA/wnjj/datafile/rm_data.298.1138994805
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 308609
Index 0 18091
Other 0 3605377
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
40 OK 0 265 3932160 111696627760
File Name: +DATA/wnjj/datafile/rm_data.302.1138994821
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 305000
Index 0 17652
Other 0 3609243
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
44 OK 0 190 3932160 111696631326
File Name: +DATA/wnjj/datafile/rm_data.306.1138994837
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 305452
Index 0 26148
Other 0 3600370
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
48 OK 0 49 3932160 111696631177
File Name: +DATA/wnjj/datafile/rm_data.310.1138994853
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 334538
Index 0 27513
Other 0 3570060
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
52 OK 0 112 3932160 111696630569
File Name: +DATA/wnjj/datafile/rm_data.314.1138994869
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 334933
Index 0 27452
Other 0 3569663
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
56 OK 0 7 3932160 111696627334
File Name: +DATA/wnjj/datafile/rm_data.318.1138994887
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 321544
Index 0 27758
Other 0 3582851
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
60 OK 0 124 3932160 111696630576
File Name: +DATA/wnjj/datafile/rm_data.322.1138994903
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 328955
Index 0 19745
Other 0 3583336
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
64 OK 0 519 3932160 111696630526
File Name: +DATA/wnjj/datafile/rm_data.326.1138994919
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 322171
Index 0 19559
Other 0 3589911
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
68 FAILED 0 3275 3932160 111696631340
File Name: +DATA/wnjj/datafile/rm_data.330.1138994933
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 2 306877
Index 0 17541
Other 0 3604467
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
72 OK 0 513 3932160 111696613018
File Name: +DATA/wnjj/datafile/rm_data.334.1138994951
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 308747
Index 0 26152
Other 0 3596748
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
76 OK 0 205 3932160 111696616485
File Name: +DATA/wnjj/datafile/rm_data.338.1138994967
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 269581
Index 0 15001
Other 0 3647373
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
82 OK 0 19 3932160 111696577981
File Name: +DATA/wnjj/datafile/rm_data.344.1138994991
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 262330
Index 0 17215
Other 0 3652596
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
86 OK 0 1 3932160 111696580241
File Name: +DATA/wnjj/datafile/rm_data.348.1138995007
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 254298
Index 0 17611
Other 0 3660250
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
88 OK 0 40459 1131520 111690504722
File Name: +DATA/wnjj/datafile/rm_img.350.1138995015
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 190
Index 0 866
Other 0 1090005
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
91 OK 0 1 3840000 111696615875
File Name: +DATA/wnjj/datafile/rm_data.353.1141670995
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 177193
Index 0 2391
Other 0 3660415
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
96 OK 0 1 3932160 111696607821
File Name: +DATA/wnjj/datafile/rm_data.358.1141893241
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 185246
Index 0 2418
Other 0 3744495
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
100 OK 0 1294081 3932160 111696628727
File Name: +DATA/wnjj/datafile/frm_data.362.1141894393
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2364682
Index 0 268967
Other 0 4430
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
101 OK 0 1 3840000 111696630911
File Name: +DATA/wnjj/datafile/rm_data.363.1141978913
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 174753
Index 0 12000
Other 0 3653246
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
105 OK 0 1 3932160 111696412447
File Name: +DATA/wnjj/datafile/rm_data.367.1141979341
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 179489
Index 0 3690
Other 0 3748980
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
109 OK 0 1 3932160 111696604556
File Name: +DATA/wnjj/datafile/rm_data.371.1141979907
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 185678
Index 0 3690
Other 0 3742791
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
113 OK 0 1 3932160 111696627032
File Name: +DATA/wnjj/datafile/rm_data.375.1141980247
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 176782
Index 0 3690
Other 0 3751687
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
120 OK 0 1 3932160 111696616192
File Name: +DATA/wnjj/datafile/rm_data.382.1141981647
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 177831
Index 0 13459
Other 0 3740869
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
124 OK 0 1 3932160 111696576356
File Name: +DATA/wnjj/datafile/rm_data.386.1141982071
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 200581
Index 0 21335
Other 0 3710243
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
128 OK 0 1 3932160 111696628194
File Name: +DATA/wnjj/datafile/rm_data.390.1141982557
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 179573
Index 0 12507
Other 0 3740079
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
132 OK 0 433 3932160 111696622009
File Name: +DATA/wnjj/datafile/rm_data.394.1141983019
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 200657
Index 0 28062
Other 0 3703008
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
136 OK 0 1 3932160 111696628086
File Name: +DATA/wnjj/datafile/rm_data.398.1144509209
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 199284
Index 0 19222
Other 0 3713653
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
140 OK 0 1 3932160 111696627118
File Name: +DATA/wnjj/datafile/rm_data.402.1144509695
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 206724
Index 0 12835
Other 0 3712600
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
144 OK 0 1 3932160 111696621550
File Name: +DATA/wnjj/datafile/rm_data.406.1144510127
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 209541
Index 0 17022
Other 0 3705596
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
148 OK 0 1 3932160 111696625188
File Name: +DATA/wnjj/datafile/rm_data.410.1144510403
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 215685
Index 0 16201
Other 0 3700273
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
152 OK 0 1 3932160 111696627375
File Name: +DATA/wnjj/datafile/rm_data.414.1144510845
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 210661
Index 0 9036
Other 0 3712462
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
156 OK 0 1 3932160 111696631054
File Name: +DATA/wnjj/datafile/rm_data.418.1144511283
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 220549
Index 0 15606
Other 0 3696004
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
160 OK 0 1 3932160 111696619559
File Name: +DATA/wnjj/datafile/rm_data.422.1144511967
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 239912
Index 0 8552
Other 0 3683695
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
164 OK 0 1 3932160 111696628637
File Name: +DATA/wnjj/datafile/rm_data.426.1144512897
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 247515
Index 0 7295
Other 0 3677349
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
169 OK 0 781313 786432 111696145484
File Name: +DATA/wnjj/datafile/frm_index.431.1169194083
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 4954
Other 0 165
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
171 OK 0 1330423 3840000 111696539980
File Name: +DATA/wnjj/datafile/sysaux05.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2029204
Index 0 476441
Other 0 3932
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
174 OK 0 1 3932160 111696628305
File Name: +DATA/wnjj/datafile/rm_data.435.1222590883
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 56221
Index 0 3110
Other 0 3872828
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
178 OK 0 49 3932160 111696292232
File Name: +DATA/wnjj/datafile/rm_data.439.1231078673
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 37177
Index 0 2106
Other 0 3892828
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
182 OK 0 4737 3932160 111696631298
File Name: +DATA/wnjj/datafile/rm_data.443.1236416555
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1650
Index 0 252
Other 0 3925521
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
186 OK 0 5761 3932160 111695951135
File Name: +DATA/wnjj/datafile/rm_data.447.1236417347
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 10474
Index 0 8562
Other 0 3907363
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
190 OK 0 2197683 3932160 111695927850
File Name: +DATA/wnjj/datafile/rm_data.451.1236515559
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 504
Other 0 1733343
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
194 OK 0 2317953 3932160 111695903691
File Name: +DATA/wnjj/datafile/rm_data.455.1236516249
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1604889
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
198 OK 0 2367233 3932160 111696315220
File Name: +DATA/wnjj/datafile/rm_data.459.1236517145
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8562
Other 0 1555735
validate found one or more corrupt blocks
See trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_ora_75085.trc for details
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00021 name=+DATA/wnjj/datafile/rm_data.283.1138994743
input datafile file number=00025 name=+DATA/wnjj/datafile/rm_data.287.1138994761
input datafile file number=00029 name=+DATA/wnjj/datafile/rm_data.291.1138994777
input datafile file number=00033 name=+DATA/wnjj/datafile/rm_data.295.1138994793
input datafile file number=00037 name=+DATA/wnjj/datafile/rm_data.299.1138994809
input datafile file number=00041 name=+DATA/wnjj/datafile/rm_data.303.1138994825
input datafile file number=00045 name=+DATA/wnjj/datafile/rm_data.307.1138994841
input datafile file number=00049 name=+DATA/wnjj/datafile/rm_data.311.1138994857
input datafile file number=00053 name=+DATA/wnjj/datafile/rm_data.315.1138994873
input datafile file number=00057 name=+DATA/wnjj/datafile/rm_data.319.1138994891
input datafile file number=00061 name=+DATA/wnjj/datafile/rm_data.323.1138994907
input datafile file number=00065 name=+DATA/wnjj/datafile/rm_data.327.1138994923
input datafile file number=00069 name=+DATA/wnjj/datafile/rm_data.331.1138994937
input datafile file number=00073 name=+DATA/wnjj/datafile/rm_data.335.1138994955
input datafile file number=00077 name=+DATA/wnjj/datafile/rm_data.339.1138994971
input datafile file number=00083 name=+DATA/wnjj/datafile/rm_data.345.1138994995
input datafile file number=00087 name=+DATA/wnjj/datafile/rm_data.349.1138995011
input datafile file number=00097 name=+DATA/wnjj/datafile/rm_data.359.1141893837
input datafile file number=00102 name=+DATA/wnjj/datafile/rm_data.364.1141979023
input datafile file number=00106 name=+DATA/wnjj/datafile/rm_data.368.1141979447
input datafile file number=00110 name=+DATA/wnjj/datafile/rm_data.372.1141979999
input datafile file number=00114 name=+DATA/wnjj/datafile/rm_data.376.1141980349
input datafile file number=00121 name=+DATA/wnjj/datafile/rm_data.383.1141981745
input datafile file number=00125 name=+DATA/wnjj/datafile/rm_data.387.1141982145
input datafile file number=00129 name=+DATA/wnjj/datafile/rm_data.391.1141982731
input datafile file number=00133 name=+DATA/wnjj/datafile/rm_index.395.1141983185
input datafile file number=00137 name=+DATA/wnjj/datafile/rm_data.399.1144509275
input datafile file number=00141 name=+DATA/wnjj/datafile/rm_data.403.1144509869
input datafile file number=00145 name=+DATA/wnjj/datafile/rm_data.407.1144510197
input datafile file number=00149 name=+DATA/wnjj/datafile/rm_data.411.1144510473
input datafile file number=00153 name=+DATA/wnjj/datafile/rm_data.415.1144511007
input datafile file number=00157 name=+DATA/wnjj/datafile/rm_data.419.1144511727
input datafile file number=00161 name=+DATA/wnjj/datafile/rm_data.423.1144512039
input datafile file number=00165 name=+DATA/wnjj/datafile/rm_data.427.1144513073
input datafile file number=00175 name=+DATA/wnjj/datafile/rm_index.436.1224950321
input datafile file number=00179 name=+DATA/wnjj/datafile/sysaux.440.1231078911
input datafile file number=00183 name=+DATA/wnjj/datafile/rm_data.444.1236416683
input datafile file number=00187 name=+DATA/wnjj/datafile/rm_data.448.1236515153
input datafile file number=00191 name=+DATA/wnjj/datafile/rm_data.452.1236515819
input datafile file number=00195 name=+DATA/wnjj/datafile/rm_data.456.1236516481
input datafile file number=00199 name=+DATA/wnjj/datafile/rm_data.460.1236517269
input datafile file number=00092 name=+DATA/wnjj/datafile/rm_data.354.1141671485
input datafile file number=00117 name=+DATA/wnjj/datafile/rm_data.379.1141980563
input datafile file number=00003 name=+DATA/wnjj/datafile/undotbs1.258.1138912785
input datafile file number=00008 name=+DATA/wnjj/datafile/rm_index.270.1138994413
input datafile file number=00079 name=+DATA/wnjj/datafile/rm_img.341.1138994979
input datafile file number=00168 name=+DATA/wnjj/datafile/frm_index.430.1169194053
input datafile file number=00017 name=+DATA/wnjj/datafile/frm_data.279.1138994611
input datafile file number=00009 name=+DATA/wnjj/datafile/rm_stat.271.1138994419
input datafile file number=00011 name=+DATA/wnjj/datafile/gis_rm_data.273.1138994427
channel ORA_DISK_1: validation complete, elapsed time: 01:37:35
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 FAILED 0 1 3085440 111696631326
File Name: +DATA/wnjj/datafile/undotbs1.258.1138912785
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 2 3085439
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 4507 2224640 111696631294
File Name: +DATA/wnjj/datafile/rm_index.270.1138994413
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 2195275
Other 0 24858
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 10083 12800 103513605799
File Name: +DATA/wnjj/datafile/rm_stat.271.1138994419
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1077
Index 0 1289
Other 0 351
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 12673 12800 1197745
File Name: +DATA/wnjj/datafile/gis_rm_data.273.1138994427
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17 OK 0 810 74240 111696630953
File Name: +DATA/wnjj/datafile/frm_data.279.1138994611
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 45379
Index 0 26752
Other 0 1299
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
21 OK 0 9 3932160 111696614879
File Name: +DATA/wnjj/datafile/rm_data.283.1138994743
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 335938
Index 0 32826
Other 0 3563387
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
25 OK 0 29 3932160 111696631283
File Name: +DATA/wnjj/datafile/rm_data.287.1138994761
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 331863
Index 0 32084
Other 0 3568184
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
29 OK 0 190 3932160 111696631213
File Name: +DATA/wnjj/datafile/rm_data.291.1138994777
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 329760
Index 0 23233
Other 0 3578977
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
33 OK 0 169 3932160 111696629512
File Name: +DATA/wnjj/datafile/rm_data.295.1138994793
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 316765
Index 0 16574
Other 0 3598652
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
37 OK 0 29 3932160 111696630902
File Name: +DATA/wnjj/datafile/rm_data.299.1138994809
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 315868
Index 0 18012
Other 0 3598251
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
41 OK 0 151 3932160 111696631236
File Name: +DATA/wnjj/datafile/rm_data.303.1138994825
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 326922
Index 0 18330
Other 0 3586757
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
45 OK 0 144 3932160 111696630875
File Name: +DATA/wnjj/datafile/rm_data.307.1138994841
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 318075
Index 0 26892
Other 0 3587049
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
49 OK 0 150 3932160 111696629438
File Name: +DATA/wnjj/datafile/rm_data.311.1138994857
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 329352
Index 0 20948
Other 0 3581710
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
53 OK 0 266 3932160 111696630569
File Name: +DATA/wnjj/datafile/rm_data.315.1138994873
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 316854
Index 0 21160
Other 0 3593880
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
57 OK 0 158 3932160 111696631164
File Name: +DATA/wnjj/datafile/rm_data.319.1138994891
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 336912
Index 0 26620
Other 0 3568470
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
61 OK 0 590 3932160 111696630566
File Name: +DATA/wnjj/datafile/rm_data.323.1138994907
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 304593
Index 0 20374
Other 0 3606603
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
65 OK 0 2105 3932160 111696631241
File Name: +DATA/wnjj/datafile/rm_data.327.1138994923
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 315825
Index 0 20389
Other 0 3593841
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
69 FAILED 0 76 3932160 111696631233
File Name: +DATA/wnjj/datafile/rm_data.331.1138994937
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 1 309979
Index 0 16391
Other 0 3605714
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
73 OK 0 43 3932160 111696631241
File Name: +DATA/wnjj/datafile/rm_data.335.1138994955
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 299186
Index 0 25932
Other 0 3606999
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
77 OK 0 1 3932160 111696627292
File Name: +DATA/wnjj/datafile/rm_data.339.1138994971
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 252455
Index 0 16233
Other 0 3663471
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
79 OK 0 32124 1111040 111690504723
File Name: +DATA/wnjj/datafile/rm_img.341.1138994979
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 284
Index 0 850
Other 0 1077782
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
83 OK 0 1 3932160 111696566987
File Name: +DATA/wnjj/datafile/rm_data.345.1138994995
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 247229
Index 0 16225
Other 0 3668705
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
87 OK 0 34 3932160 111696583153
File Name: +DATA/wnjj/datafile/rm_data.349.1138995011
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 250060
Index 0 17224
Other 0 3664842
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
92 OK 0 1 3840000 111696626997
File Name: +DATA/wnjj/datafile/rm_data.354.1141671485
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 187360
Index 0 4368
Other 0 3648271
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
97 OK 0 1 3932160 111696627032
File Name: +DATA/wnjj/datafile/rm_data.359.1141893837
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 181670
Index 0 11874
Other 0 3738615
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
102 OK 0 1 3932160 111696618617
File Name: +DATA/wnjj/datafile/rm_data.364.1141979023
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 160817
Index 0 2670
Other 0 3768672
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
106 OK 0 1 3932160 111696403294
File Name: +DATA/wnjj/datafile/rm_data.368.1141979447
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 188946
Index 0 3816
Other 0 3739397
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
110 OK 0 1 3932160 111696618856
File Name: +DATA/wnjj/datafile/rm_data.372.1141979999
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 185160
Index 0 2670
Other 0 3744329
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
114 OK 0 1 3932160 111696553117
File Name: +DATA/wnjj/datafile/rm_data.376.1141980349
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 174483
Index 0 4106
Other 0 3753570
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
117 OK 0 1 3840000 111696330971
File Name: +DATA/wnjj/datafile/rm_data.379.1141980563
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 174926
Index 0 12126
Other 0 3652947
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
121 OK 0 1 3932160 111696630911
File Name: +DATA/wnjj/datafile/rm_data.383.1141981745
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 183179
Index 0 13330
Other 0 3735650
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
125 OK 0 1 3932160 111696624938
File Name: +DATA/wnjj/datafile/rm_data.387.1141982145
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 206046
Index 0 21032
Other 0 3705081
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
129 OK 0 1 3932160 111696630911
File Name: +DATA/wnjj/datafile/rm_data.391.1141982731
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 191723
Index 0 20093
Other 0 3720343
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
133 FAILED 0 161 3932160 111696630949
File Name: +DATA/wnjj/datafile/rm_index.395.1141983185
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 1 3921227
Other 0 10772
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
137 OK 0 1 3932160 111696548703
File Name: +DATA/wnjj/datafile/rm_data.399.1144509275
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 199695
Index 0 20440
Other 0 3712024
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
141 OK 0 1 3932160 111696626897
File Name: +DATA/wnjj/datafile/rm_data.403.1144509869
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 210865
Index 0 23178
Other 0 3698116
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
145 OK 0 1 3932160 111696605752
File Name: +DATA/wnjj/datafile/rm_data.407.1144510197
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 204106
Index 0 26056
Other 0 3701997
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
149 OK 0 1 3932160 111696630952
File Name: +DATA/wnjj/datafile/rm_data.411.1144510473
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 222598
Index 0 16732
Other 0 3692829
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
153 OK 0 1 3932160 111696623339
File Name: +DATA/wnjj/datafile/rm_data.415.1144511007
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 212526
Index 0 16321
Other 0 3703312
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
157 OK 0 1 3932160 111696626854
File Name: +DATA/wnjj/datafile/rm_data.419.1144511727
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 221667
Index 0 9438
Other 0 3701054
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
161 OK 0 1 3932160 111696626619
File Name: +DATA/wnjj/datafile/rm_data.423.1144512039
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 229590
Index 0 7658
Other 0 3694911
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
165 OK 0 1 3932160 111696613530
File Name: +DATA/wnjj/datafile/rm_data.427.1144513073
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 227627
Index 0 7436
Other 0 3697096
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
168 OK 0 388097 393216 111696234691
File Name: +DATA/wnjj/datafile/frm_index.430.1169194053
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 4954
Other 0 165
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
175 OK 0 924433 3932160 111696630841
File Name: +DATA/wnjj/datafile/rm_index.436.1224950321
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 3002014
Other 0 5713
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
179 OK 0 3670921 3932160 111696622967
File Name: +DATA/wnjj/datafile/sysaux.440.1231078911
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 204617
Index 0 56112
Other 0 510
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
183 OK 0 6521 3932160 111695962800
File Name: +DATA/wnjj/datafile/rm_data.444.1236416683
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 7676
Other 0 3917333
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
187 OK 0 1980929 3932160 111695951272
File Name: +DATA/wnjj/datafile/rm_data.448.1236515153
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 1524
Index 0 378
Other 0 1949329
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
191 OK 0 2260609 3932160 111695921107
File Name: +DATA/wnjj/datafile/rm_data.452.1236515819
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1662233
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
195 OK 0 2334337 3932160 111695900103
File Name: +DATA/wnjj/datafile/rm_data.456.1236516481
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8688
Other 0 1588505
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
199 OK 0 2367233 3932160 111696311980
File Name: +DATA/wnjj/datafile/rm_data.460.1236517269
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 630
Index 0 8562
Other 0 1555735
validate found one or more corrupt blocks
See trace file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_ora_75085.trc for details
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 3384
Finished validate at 2026-07-04 17:18:43
RMAN>
Sat Jul 04 11:06:27 2026
Error backing up file 74, block 7072: logical corruption
Sat Jul 04 11:06:56 2026
Error backing up file 66, block 123135: logical corruption
Sat Jul 04 11:07:28 2026
Error backing up file 66, block 244624: logical corruption
Error backing up file 70, block 257639: logical corruption
Sat Jul 04 11:57:17 2026
Error backing up file 162, block 514: logical corruption
Sat Jul 04 11:59:40 2026
Error backing up file 170, block 547187: logical corruption
Sat Jul 04 12:44:02 2026
Error backing up file 67, block 272587: logical corruption
Sat Jul 04 14:19:40 2026
Error backing up file 68, block 262044: logical corruption
Error backing up file 68, block 262089: logical corruption
Sat Jul 04 15:25:44 2026
Reconfiguration started (old inc 2, new inc 4)
List of instances:
1 2 (myinst: 2)
Global Resource Directory frozen
Communication channels reestablished
Sat Jul 04 15:25:44 2026
* domain 0 valid = 0 according to instance 1
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sat Jul 04 15:25:44 2026
Sat Jul 04 15:25:44 2026
LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Sat Jul 04 15:25:44 2026
LMS 6: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 5: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Sat Jul 04 15:25:44 2026
Sat Jul 04 15:25:44 2026
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Sat Jul 04 15:25:44 2026
LMS 7: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Sat Jul 04 15:25:44 2026
Sat Jul 04 15:25:44 2026
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 4: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Sat Jul 04 16:00:18 2026
Error backing up file 69, block 258056: logical corruption
Sat Jul 04 16:33:42 2026
Error backing up file 133, block 134210: logical corruption
Sat Jul 04 17:07:03 2026
Error backing up file 3, block 19744: logical corruption
Sat Jul 04 17:07:40 2026
Error backing up file 3, block 165586: logical corruption
Sat Jul 04 19:22:33 2026
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbw0_56145.trc:
ORA-15055: unable to connect to ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-15055: unable to connect to ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
NOTE: deferred map free for map id 4613
Sat Jul 04 19:22:38 2026
Non critical error ORA-48180 caught while writing to trace file "/u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_m000_174699.trc"
Error message: Linux-x86_64 Error: 28: No space left on device
Additional information: 1
Writing to the above trace file is disabled for now on...
Sat Jul 04 19:22:43 2026
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Non critical error ORA-48113 caught while writing to trace file "/u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbw0_56145.trc"
Error message:
Writing to the above trace file is disabled for now on...
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/wnjj/wnjj2/trace/wnjj2_dbw0_56145.trc:
ORA-15055: unable to connect to ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-15055: unable to connect to ASM instance
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional informatio
校验完成后查询坏块视图：
SQL> SELECT FILE#,BLOCK#,CORRUPTION_TYPE FROM V$DATABASE_BLOCK_CORRUPTION;
FILE# BLOCK# CORRUPTIO
---------- ---------- -------------------------------------------------------------------
3 19744 CORRUPT
3 165586 CORRUPT
66 123135 CORRUPT
66 244624 CORRUPT
67 272587 CORRUPT
68 262044 CORRUPT
68 262089 CORRUPT
69 258056 CORRUPT
70 257639 CORRUPT
74 7072 CORRUPT
133 134210 CORRUPT
162 514 CORRUPT
170 547187 CORRUPT
13 rows selected.
SQL>
字段说明：
- CORRUPTION_TYPE：PHYSICAL（介质损坏）/LOGICAL（逻辑损坏）
- FILE#、BLOCK# 与日志完全对应36/516367
方式2：单独校验损坏文件
RMAN> VALIDATE CHECK LOGICAL DATAFILE 36;
校验完查看坏块记录：
SELECT FILE#,BLOCK#,CORRUPTION_TYPE FROM V$DATABASE_BLOCK_CORRUPTION;
4.修复方案
场景A：有完整有效备份（最优）
恢复损坏块（块级恢复，无需重建整文件）
RMAN> BLOCKRECOVER DATAFILE 36 BLOCK 516367;
恢复完成后校验：
RMAN> VALIDATE DATAFILE 36 BLOCK 516367;
无报错即可open数据库：
ALTER DATABASE OPEN;
场景B：无备份，仅逻辑坏块（CORRUPTION_TYPE=LOGICAL）
校验损坏文件
RMAN> VALIDATE CHECK LOGICAL DATABASE;
告警日志
Sat Jul 04 10:49:34 2026
Decreasing number of real time LMS from 8 to 0
Sat Jul 04 11:06:27 2026
Error backing up file 74, block 7072: logical corruption
Sat Jul 04 11:06:56 2026
Error backing up file 66, block 123135: logical corruption
Sat Jul 04 11:07:28 2026
Error backing up file 66, block 244624: logical corruption
Error backing up file 70, block 257639: logical corruption
坏块视图查询结果
SELECT FILE#,BLOCK#,CORRUPTION_TYPE FROM V$DATABASE_BLOCK_CORRUPTION;
RMAN 在线校验仅内存标记坏块，未写入 SGA 持久损坏视图；仅介质恢复 / 实例崩溃才会落地该视图
PHYSICAL：物理坏块（磁盘 / ASM 硬件介质损坏，无法用 10231 事件彻底屏蔽写报错）LOGICAL：逻辑坏块（数据内部错乱，可临时用 10231 跳过访问）
数据库能open
1、定位坏块归属对象（仅 OPEN 可用）
-- 查坏块归属对象
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE
FROM DBA_EXTENTS
WHERE FILE_ID=74 AND 7072 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS-1;
当前数据库只到 MOUNT 阶段，DBA_EXTENTS 是数据字典视图，必须数据库 OPEN 才能访问；mount 状态只能查固定视图（V$ 开头）。
SELECT
OWNER, SEGMENT_NAME, SEGMENT_TYPE
FROM V$EXTENT_MAP
WHERE FILE_ID = 74
AND 7072 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
V$EXTENT_MAP 并非纯固定视图，底层依赖数据字典段映射信息，数据库 MOUNT 状态下无法访问，该方案不可行，直接废弃。
2、损坏对象修复规则
- 若损坏段为表：
- expdp/exp 导出该表可正常读取的数据；
- 执行
DROP TABLE 用户名.表名 PURGE;清空回收站，重建表结构后导入数据（坏块区间数据永久丢失）。
- 若损坏段为索引：直接删除重建索引
DROP INDEX 用户名.索引名;
CREATE INDEX 索引名 ON 用户名.表名(字段);
数据库不能open
紧急修复前置操作（当前mount状态可执行）
现在千万不要执行 alter database open，一打开DBW检测到坏块会直接crash实例，无限循环重启、暴涨trace日志撑满磁盘。
只能先尝试跳过坏块强行打开（存在数据丢失风险，业务会报错）：
警告：10231 事件仅屏蔽读坏块报错；若坏块为内存脏块，DBWR 刷写磁盘时会校验块头，单纯 10231 大概率挡不住实例崩溃，仅作临时应急尝试；若启动后依旧 crash，无备份只能隔离损坏文件。
-- 开启跳过坏块事件
### 方式1：使用 SPFILE（生产主流，重启库生效）
ALTER SYSTEM SET event='10231 trace name context forever,level 10' SCOPE=SPFILE;
### 方式2：仅当前会话临时生效（无需重启，仅当前会话）
ALTER SESSION SET events '10231 trace name context forever,level 10';
-- 尝试打开库
ALTER DATABASE OPEN;
验证会话事件：
SELECT value FROM v$session_events WHERE sid=USERENV('SID');
数据库正常打开、业务修复完成后关闭屏蔽事件：
## 1. 删除spfile持久配置
ALTER SYSTEM RESET event SCOPE=SPFILE SID='*';
## 2. 关闭当前会话临时事件
ALTER SESSION SET events '10231 trace name context off';
情况1：成功OPEN
- 查询损坏对象（此时DBA_EXTENTS可用）
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE
FROM DBA_EXTENTS
WHERE FILE_ID=36 AND 516367 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS-1;
- 处理对象
-
如果是索引：直接删除重建
DROP INDEX 用户名.索引名; CREATE INDEX ... ; -
如果是表：
- expdp/exp导出该表能正常读取的数据
DROP TABLE 用户名.表名 PURGE;- 重建表结构，导入备份数据（坏块区间数据永久丢失）
- 修复完成关闭事件
ALTER SYSTEM SET event='10231 trace name context off';
情况 2：执行 OPEN 后 DBWR 持续崩溃
崩溃根因：坏块存在脏缓冲区，DBWR 后台进程需要落地脏块，10231 仅拦截读操作，不拦截写入校验逻辑。
无备份处理前置步骤：
方案 1：双重兜底（屏蔽坏块读 + 离线损坏文件，优先执行）
适配本次故障损坏文件：66、70、74
startup mount;
-- 屏蔽坏块读取报错
ALTER SYSTEM SET event='10231 trace name context forever,level 10';
-- 离线全部存在逻辑坏块的数据文件
ALTER DATABASE DATAFILE 66 OFFLINE;
ALTER DATABASE DATAFILE 70 OFFLINE;
ALTER DATABASE DATAFILE 74 OFFLINE;
-- 尝试打开数据库
ALTER DATABASE OPEN;
打开后影响：
- 访问 file66/70/74 内任意表、索引会报
ORA-00376: file XX cannot be read at this time； - 仅可导出其余完好数据文件业务数据，66/70/74 文件内全部数据丢失，后续需重建对应数据文件。
方案 2：离线文件后启动依旧崩溃（恢复强制访问文件，破坏性操作）
崩溃原因：66/70/74 包含 Undo 回滚段、未提交事务脏块，崩溃恢复流程强制读取文件，单纯 offline 无法阻断恢复扫描。
操作步骤：
- 确认无任何有效备份，接受 66/70/74 三份文件全部数据永久丢失；
- MOUNT 状态备份控制文件留存故障现场；
- 修改控制文件脚本，删除三份损坏文件定义，重建控制文件后 DROP 数据文件，打开数据库重置日志。
场景C：物理坏块（磁盘/ASM硬件损坏，无备份）
- 先检查底层存储：
- ASM磁盘健康：
asmcmd lsdsk -k、v$asm_disk_stat - 服务器硬盘、RAID、存储链路是否报错（硬件层面坏块）
- ASM磁盘健康：
- 若硬件故障：更换磁盘后重建对应数据文件；
- 硬件无异常：该块数据永久丢失，只能删除对应段重建，存在数据丢失风险。
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
