RMAN Commands , 6 of 59

allocOperandList

Syntax

Text description of the illustration allocOperandList.gif

Purpose

A subclause specifying control options on a channel, which is a connection between RMAN and a database instance. Specify this clause on the following commands:

Keywords and Parameters

Syntax Element	Description
`PARMS` `=` `'``channel_parms``'`	Specifies parameters for the device to allocate. Do not use this port-specific string if you have specified `DEVICE` `TYPE` `DISK`. If you use `PARMS` in conjunction with `DEVICE` `TYPE sbt`, then you can specify the following environment variables within a quoted string. The maximum length of the quoted string containing `channel_parms` is 1000 bytes. For example, you can specify: PARMS="BLKSIZE=16384,ENV=(NSR_SERVER=tape_server, NSR_CLIENT=oracleclnt,NSR_GROUP=oracle_tapes)" See Also: Oracle9i Recovery Manager User's Guide to learn how Oracle links to media management libraries
`'ENV=(``var1``=``val1``,` `var2``=``val2`,`...)'`	Specifies one or more environment variables required by the media management vendor in the Oracle server session corresponding to this RMAN client. Because RMAN is a client program, the `ENV` parameter can be used to set server session specific variables that perform backup and restore operations on behalf of the RMAN client. For example: PARMS="ENV=(NSR_SERVER=srv1)"
`'BLKSIZE=``integer``'`	Sets the level of granularity for I/O on this channel. The value should be a multiple of the default device block factor (in the Solaris Operating Environment, the value is 16 K). For example: PARMS="BLKSIZE=16384"
`'SBT_LIBRARY=` `lib_name``'`	Specifies which media library should be used on this `sbt` channel. The default library is operating system specific (for example, `libobk.so` in the Solaris Operating Environment and `ORASBT.DLL` on Windows NT). For example: PARMS="SBT_LIBRARY=/oracle/lib/mmv.so"
`CONNECT` `=` connectStringSpec	Specifies a connect string to the database instance where RMAN should conduct the backup or restore operations. Use this parameter to spread the work of backup or restore operations across different instances in an Oracle Real Application Clusters configuration. If you do not specify this parameter, and if you did not specify the `AUXILIARY` option, then RMAN conducts all operations on the target database instance specified by the command-line parameter or the instance connected to when you issued the `CONNECT` command. Typically, you should not use the `CONNECT` parameter in conjunction with the `AUXILIARY` option. See Also: "connectStringSpec" and "cmdLine"
`FORMAT` `=` `'``format_string``'`	Specifies the format to use for the names of backup pieces that are created on this channel. If you do not specify a format, RMAN uses `%U` by default, which guarantees a unique identifier. Because the channels correspond to server sessions on the target database, the `FORMAT` string must use the conventions of the target host, not the client host. For example, if the RMAN client runs on a Windows machine and the target database runs on a UNIX machine, then the `FORMAT` string must adhere to the naming conventions of a UNIX file system or raw device. You can specify up to four `FORMAT` strings. RMAN uses the second, third, and fourth values only when `BACKUP` `COPIES`, `SET` `BACKUP` `COPIES`, or `CONFIGURE` `...` `BACKUP` `COPIES` is in effect. When choosing which format to use for each backup piece, RMAN uses the first format value for copy 1, the second format value for copy 2, and so forth. If the number of format values exceeds the number of copies, then the extra formats are not used. If the number of format values is less than the number of copies, then RMAN reuses the format values, starting with the first one. This parameter is useful if you allocate multiple disk channels and want each channel to write to a different directory. If you specify the `FORMAT` parameter in the `BACKUP` command, then it overrides the `FORMAT` parameter specified in `CONFIGURE CHANNEL` or `ALLOCATE CHANNEL`. See Also: "BACKUP" for available `FORMAT` parameters
`MAXPIECESIZE` `=` `integer`	Specifies the maximum size of each backup piece created on this channel. Specify the size in bytes, kilobytes (`K`), megabytes (`M`), or gigabtyes (`G`). The default setting is in bytes and is rounded down into kilobtyes. For example, if you set `MAXPIECESIZE` to 5000, RMAN sets the maximum piece size at 4 kilobytes, which is the lower kilobyte boundary of 5000 bytes.
`RATE` `=` `integer`	Sets the maximum number of bytes (default), kilobtyes (`K`), megabytes (`M`), or gigabtyes (`G`) that RMAN reads on this channel. This parameter sets an upper limit for bytes read so that RMAN does not consume too much disk bandwidth and degrade performance. Note that decimals are not permitted in the `integer` value.
`MAXOPENFILES` `=` `integer`	Controls the maximum number of input files that a `BACKUP` command can have open at any given time (the default is `8`). Use this parameter to prevent "Too many open files" error messages when backing up a large number of files into a single backup set.
`SEND` `'``command``'`	Sends a vendor-specific command string to all allocated channels. See Also: Your media manager documentation to see whether this feature is supported

Examples

Configuring an Automatic Channel: Example

This example configures a persistent disk channel:

CONFIGURE CHANNEL DEVICE TYPE DISK RATE = 1500K FORMAT = '?/oradata/bkup_%U';

Configuring a Channel for a Backup: Example

This example manually allocates an sbt channel and then runs a whole database backup:

RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE sbt MAXOPENFILES 20 RATE 2M MAXPIECESIZE 800M;
  BACKUP DATABASE;
}

Allocating a Channel for a Backup: Example

This example configures a default media management library, then makes a database backup by using this library. Then, the example backs up the database again using a different library, then finally makes a third backup using the default library:

CONFIGURE DEFAULT DEVICE TYPE TO sbt;
CONFIGURE CHANNEL DEVICE TYPE sbt PARMS="SBT_LIBRARY=?/lib/mm_lib1.so";
BACKUP DATABASE;
RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS="SBT_LIBRARY=?/lib/mm_lib2.so";
  BACKUP DATABASE;
}
BACKUP ARCHIVELOG ALL;