Hi,
I sed backup validate command to find physical corruption into my database as follows.
backup validate check logical database;
After his command, I queried v$database_block_corruption.
12:04:47 SQL> select * from v$database_block_corruption;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
1 11477 2 228760588 LOGICAL
1 11514 1 228760329 LOGICAL
12:05:09 SQL>
How can I find if this is physical corruption of logical corruption?
I also used dbv command to check my system datafile (File# 1). And output is as foolows
D:\>dbv file=D:\ORACLE\ORADATA\OPERA\SYSTEM01.DBf
DBVERIFY: Release 10.2.0.4.0 - Production on Mon Nov 18 11:56:23 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = D:\ORACLE\ORADATA\OPERA\SYSTEM01.DBf
DBV-00200: Block, DBA 4205781, already marked corrupt
DBV-00200: Block, DBA 4205782, already marked corrupt
DBV-00200: Block, DBA 4205818, already marked corrupt
DBVERIFY - Verification complete
Total Pages Examined : 168960
Total Pages Processed (Data) : 127180
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 25248
Total Pages Failing (Index): 0
Total Pages Processed (Other): 2440
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 14092
Total Pages Marked Corrupt : 3
Total Pages Influx : 0
Highest block SCN : 245793757 (0.245793757)
Since dbv always checks for physical corruption, but how can I make sure by using RMAn that whether this is physical corruption of only logical corruption? Thanks
Alert log says something as follows
Sat Sep 14 00:22:50 2013
Errors in file d:\oracle\admin\opera\bdump\opera_p008_3916.trc:
ORA-01578: ORACLE data block corrupted (file # 1, block # 11478)
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OPERA\SYSTEM01.DBF'
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\OPERA\SYSTEM01.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 5121
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [1], [11478], [6101], [], [], [], []
SAQ