Oracle RMAN Channel Allocation

You can manually allocate RMAN channels by using the ALLOCATE CHANNEL command. This approach helps optimize backup operations and resource allocation. Specify the Veeam backup repository universal unique identifier (UUID) in the channel parameters to direct backup operations to the intended backup repository.

Important

Keep in mind that the ALLOCATE CHANNEL command must be issued only within a RUN block for a specific backup operation.

To manually allocate RMAN channels, do the following:

  1. Open the RUN block.
  2. Use the ALLOCATE CHANNEL command and specify the following parameters:
  1. Specify the channel ID. For example: ch1.
  2. Specify the SBT_TAPE option for the DEVICE TYPE parameter.
  3. Specify PARMS to define other parameters for the sbt_tape channel.
  4. Specify which media library must be used for this sbt_tape channel.
  • [For Linux and Unix] Set the path to the libOracleRMANPlugin.so file as the SBT_LIBRARY.
  • [For Microsoft Windows] Set the path to %PROGRAMFILES%\Veeam\VeeamPluginforOracleRMAN\OracleRMANPlugin.dll.
  1. Specify the Veeam backup repository UUID in the argument for the FORMAT parameter. You can find the required backup repository UUID in the rman_config.txt file or in log files.
  • [For Linux and Unix] If you have exported Veeam Plug-in configuration files, run the following command to see the contents of the configuration file.

cat /tmp/rman_config.txt

Alternatively, you can find the repository UUID in log files:

grep "received repos" /tmp/veeam_plugin_logs/oracle/OracleRMANConfigTool.log | tail

  • [For Microsoft Windows] If you have exported Veeam Plug-in configuration files, find the channel allocation definition in the configuration file.

Alternatively, you can find the repository UUID in log files. Go to the %\ProgramData\Veeam\Backup\RmanPluginLogs\SERV_NAME directory and search for "received repos id" in the OracleRMANConfigToolLib.log file.

  1. Use the BACKUP DATABASE command to create a database backup.
  2. [Optional] Use the RELEASE CHANNEL command. By default, RMAN automatically releases all channels when the RUN command terminates.
  3. Close the RUN block.

To learn more about channel allocation, see Oracle documentation.

Examples

Oracle RMAN Channel Allocation Example 1. Allocating Single Channel for Backup Operations

In this example, the RUN block contains the following commands:

  • ALLOCATE CHANNEL: this command allocates channel ch1 to the Veeam backup repository with UUID d8338780-1aec-4c36-b17c-e1ea3ea2ca93.
  • BACKUP DATABASE: this command backs up the specified database.
  • RELEASE CHANNEL: this command releases the allocated channel ch1 to optimize resources.

RUN {

    ALLOCATE CHANNEL ch1 DEVICE TYPE SBT_TAPE

      PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' FORMAT 'd8338780-1aec-4c36-b17c-e1ea3ea2ca93/RMAN_%I_%d_%T_%U.vab';

    BACKUP DATABASE;

    RELEASE CHANNEL ch1;

}

EXIT;

Oracle RMAN Channel Allocation Example 2. Allocating Multiple Channels for Backup Operations

In this example, the RUN block contains the following commands:

  • ALLOCATE CHANNEL: this command allocates channels ch1 and ch2 simultaneously to the Veeam backup repository with UUID d8338780-1aec-4c36-b17c-e1ea3ea2ca93.
  • BACKUP DATABASE: this command backs up the specified database.
  • RELEASE CHANNEL: this command releases the allocated channels ch1 and ch2 to optimize resources.

RUN {

    ALLOCATE CHANNEL ch1 DEVICE TYPE SBT_TAPE

      PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' FORMAT 'd8338780-1aec-4c36-b17c-e1ea3ea2ca93/RMAN_%I_%d_%T_%U.vab';

    ALLOCATE CHANNEL ch2 DEVICE TYPE SBT_TAPE

      PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' FORMAT 'd8338780-1aec-4c36-b17c-e1ea3ea2ca93/RMAN_%I_%d_%T_%U.vab';

    BACKUP DATABASE;

    RELEASE CHANNEL ch1;

    RELEASE CHANNEL ch2;

}

EXIT;

Oracle RMAN Channel Allocation Example 3. Allocating Single Channel and Using Multiple Repositories for Backup Operations

In this example, the RUN block contains the following commands:

  • ALLOCATE CHANNEL: this command allocates channel ch1 to two Veeam backup repositories with UUIDs d8338780-1aec-4c36-b17c-e1ea3ea2ca93 and 4f85d62e-bd3c-46da-9cdd-53873faf4214 simultaneously.
  • BACKUP DATABASE: this command backs up the specified database.
  • RELEASE CHANNEL: this command releases the allocated channel ch1 to optimize resources.

RUN {

     ALLOCATE CHANNEL ch1 DEVICE TYPE SBT_TAPE

      PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' FORMAT 'd8338780-1aec-4c36-b17c-e1ea3ea2ca93/RMAN_%I_%d_%T_%U.vab','4f85d62e-bd3c-46da-9cdd-53873faf4214/RMAN_%I_%d_%T_%U.vab';

    BACKUP DATABASE;

    RELEASE CHANNEL ch1;

}

EXIT;

Oracle RMAN Channel Allocation Example 4. Allocating Single Channel for Backup Operations in Windows Environment

In this example for Windows environments, the RUN block contains the following commands:

  • ALLOCATE CHANNEL: this command allocates channel VeeamAgentChannel1 to the Veeam backup repository with UUID d8338780-1aec-4c36-b17c-e1ea3ea2ca93.
  • BACKUP DATABASE: this command backs up the specified database.
  • RELEASE CHANNEL: this command releases the allocated channel VeeamAgentChannel1 to optimize resources.

RUN {

   ALLOCATE CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE

     PARMS 'SBT_LIBRARY=C:\PROGRA~1\Veeam\VEEAMP~2\ORACLE~2.DLL' FORMAT 'd8338780-1aec-4c36-b17c-e1ea3ea2ca93/RMAN_%I_%d_%T_%U.vab';

   BACKUP DATABASE;

   RELEASE CHANNEL VeeamAgentChannel1;

}

EXIT;

Page updated 6/21/2024

Page content applies to build 12.1.2.172