Performing block media recovery - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Performing block media recovery

You can recovery individual data blocks, known as block media recovery, using the Amazon RDS procedures rdsadmin.rdsadmin_rman_util.recover_datafile_block. You can use this overloaded procedure to recover either an individual data block or a range of data blocks.

This procedure uses the following common parameter for RMAN tasks:

  • p_rman_to_dbms_output

For more information, see Common parameters for RMAN procedures.

This procedure uses the following additional parameters.

Parameter name Data type Valid values Default Required Description

p_datafile

NUMBER

A valid data file ID number.

—

Yes

The data file containing the corrupt blocks. Specify the data file in either of the following ways:

  • The data file ID number, which is located in V$DATAFILE.FILE#

  • The full data file name, including the path, located in V$DATAFILE.NAME

p_block

NUMBER

A valid integer.

—

Yes

The number of an individual block to be recovered.

The following parameters are mutually exclusive:

  • p_block

  • p_from_block and p_to_block

p_from_block

NUMBER

A valid integer.

—

Yes

The first block number in a range of blocks to be recovered.

The following parameters are mutually exclusive:

  • p_block

  • p_from_block and p_to_block

p_to_block

NUMBER

A valid integer.

—

Yes

The last block number in a range of blocks to be recovered.

The following parameters are mutually exclusive:

  • p_block

  • p_from_block and p_to_block

This procedure is supported for the following Amazon RDS for Oracle DB engine versions:

  • Oracle Database 21c (21.0.0)

  • Oracle Database 19c (19.0.0)

The following example recovers block 100 in data file 5.

BEGIN
    rdsadmin.rdsadmin_rman_util.recover_datafile_block(
        p_datafile            => 5, 
        p_block               => 100,
        p_rman_to_dbms_output => TRUE);
END;
/

The following example recovers blocks 100 to 150 in data file 5.

BEGIN
    rdsadmin.rdsadmin_rman_util.recover_datafile_block(
        p_datafile            => 5, 
        p_from_block          => 100,
        p_to_block            => 150,
        p_rman_to_dbms_output => TRUE);
END;
/