Scribd
Upload
11 views1 page

Corruption

The document describes a corrupted block being detected in a datafile. Details are provided about the corrupted block such as the file number, block number, and tablespace. The corruption was detected on a standby database during automatic block media recovery.

Uploaded by

vikash Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
11 views1 page

Corruption

The document describes a corrupted block being detected in a datafile. Details are provided about the corrupted block such as the file number, block number, and tablespace. The corruption was detected on a standby database during automatic block media recovery.

Uploaded by

vikash Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

select * from v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO CON_ID


---------- ---------- ---------- ------------------ --------- ----------
32 1407988 1 0 CORRUPT 0

set lines 300


col FILE_NAME for a70
col TABLESPACE_NAME for a20
SELECT FILE_ID,RELATIVE_FNO,FILE_NAME,TABLESPACE_NAME FROM DBA_DATA_FILES WHERE
FILE_ID=32;

FILE_ID RELATIVE_FNO FILE_NAME


TABLESPACE_NAME
---------- ------------
----------------------------------------------------------------------
--------------------
32 32 +DATA/UXID01P/DATAFILE/sysaux.952.1028297425
SYSAUX

col OWNER for a30


col SEGMENT_TYPE for a30
col SEGMENT_NAME for a30
SELECT owner, segment_name, segment_type FROM dba_extents WHERE RELATIVE_FNO =32
AND Block_id BETWEEN 1407988 AND 1407988 + blocks - 1;

OWNER SEGMENT_NAME SEGMENT_TYPE


------------------------------ ------------------------------
------------------------------
STDBYPERF STATS$FILESTATXS TABLE

Wed Mar 16 22:01:51 2022


Errors in file
/u01/app/oracle/diag/rdbms/uxid01p/uxid01p4/trace/uxid01p4_bmr0_183517.trc:
ORA-17630: Mismatch in the remote file protocol version client 2 server 3
Automatic block media recovery failed for (file# 32, block# 1407988)
[No standby available]
Wed Mar 16 22:01:51 2022

You might also like