Abmr: test the automatic block Recovery feature

Abmr: test the automatic block Recovery feature

Reference Original:
Abmr: how to test automatic block recover feature (Doc ID 1266059.1)

Applicable:
Oracle Server-Enterprise Edition-version: 11.2.0.1.0 and later [release: 11.2 and later]
Information in this document applies to any platform.

Objectives:
This article first creates a bad block in datafile and then triggers the abmr feature.
As a pre-requirement for testing, you need to configure the master and slave databases of the DG and synchronize them normally.

Solution:
1. confirm that the block in the table contains data.
You can use the following query statement to translate rowid into file # And block #

Select rowid, dbms_rowid.rowid_block_number (rowid) blockno, dbms_rowid.rowid_relative_fno (rowid) fno
From Test. Test
Where rownum< 100
/

2. Using the block from the datafile identified file # using dd utility at OS level.
What is the above sentence? No cloud.
Dd If =/dev/Zero of =/oradata/orcl/users. dbf count = 1 seek = 164 BS = 8192 Conv = notrunc

3. Check whether the block is damaged.
DBV file =/oradata/orcl/users. DBF blocksize = 8192

4. Flush buffer cache on the master database to force data to be read again from the disk to the memory.
5. query the table again. No error is displayed and the queried data is valid.
Select * from Test. Test
Where dbms_rowid.rowid_block_number (rowid) = 164
And dbms_rowid.rowid_relative_fno (rowid) = 9
/