While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block
corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.
Which RMAN command do you use to perform BMR and repair the corrupt block?
A.
RECOVER FILE=1201 BLOCK=1968;
B.
RECOVER CORRUPTION LIST;
C.
RECOVER DATAFILE 1201 BLOCK 1968;
D.
RECOVER BLOCK CORRUPTION LIST;
E.
None of the above
To recover all blocks logged in V$DATABASE_BLOCK_CORRUPTION:
Start SQL*Plus and connect to the target database.
Query V$DATABASE_BLOCK_CORRUPTION to determine whether corrupt blocks exist. For example, execute the following statement:
SQL> SELECT * FROM V$DATABASE_BLOCK_CORRUPTION;
Start RMAN and connect to the target database.
Recover all blocks marked corrupt in V$DATABASE_BLOCK_CORRUPTION.
The following command repairs all physically corrupted blocks recorded in the view:
RMAN> RECOVER CORRUPTION LIST;
After the blocks are recovered, the database removes them from V$DATABASE_BLOCK_CORRUPTION.
To recover specific data blocks:
Obtain the data file numbers and block numbers of the corrupted blocks.
The easiest way to locate trace files and the alert log is to connect SQL*Plus to the target database and execute the following query:
SELECT NAME, VALUE
FROM V$DIAG_INFO;
Start RMAN and connect to the target database, which must be mounted or open.
Run the SHOW ALL command to confirm that the appropriate channels are preconfigured.
Run the RECOVER … BLOCK command at the RMAN prompt, specifying the file and block numbers for the corrupted blocks.
The following example recovers two blocks.
RECOVER
DATAFILE 8 BLOCK 13
DATAFILE 2 BLOCK 19;
Greetings here, just turned conscious of your website through Search engine, and discovered that it’s genuinely helpful. I will like should you maintain this post.
http://www.waternet-berlin.org