Performing block media recovery - Amazon Relational Database Service

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;
/