E RMAN Media Management Parameters

Database Backup Storage Selectors and RMAN Media Management Parameters

You can configure device and media family restrictions in both database backup storage selectors, which are created with the mkssel command, and the OB_DEVICE and OB_MEDIA_FAMILY RMAN media management parameters. Table E-1 explains the criteria used by Oracle Secure Backup when choosing the media family and device for an RMAN backup job.

OB_DEVICE[_n]

Use the OB_DEVICE[_n] parameter to define which tape drives can be used for backups.

Restrictions and Usage Notes

Before specifying OB_DEVICE[_n] in an RMAN job, note the following:

• This parameter does not affect restore jobs.

• Channels can only be restricted to tape drives, not tape libraries.

• Table E-1 explains the criteria used by Oracle Secure Backup when choosing the media family and device for an RMAN backup job.

Syntax

OB_DEVICE::=

OB_DEVICE[_n][=]drive_name

Semantics

_n

Specifies the copy number of duplexed backups. For duplexed backups, OB_DEVICE_1 is for the first copy, OB_DEVICE_2 is for the second copy, and so on.

drive_name

Specifies the name of the tape drive to which the backup should be restricted.

Examples

Example E-1 uses the SEND command to specify a tape drive. Note that no equal sign is inserted between the parameter OB_DEVICE and the names of the tape drives.

RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
  SEND 'OB_DEVICE tape2';
  BACKUP TABLESPACE users;
}

Example E-2 makes the same backup as Example E-1, but uses PARMS to set the Oracle Secure Backup media family parameter. Note that an equal sign is inserted between the parameter OB_DEVICE and the value my_full_backups.

RUN
{
   ALLOCATE CHANNEL c1 DEVICE TYPE sbt
     PARMS 'ENV=(OB_DEVICE=tape2)';   
   BACKUP TABLESPACE users;
}

OB_MEDIA_FAMILY[_n]

Use the OB_MEDIA_FAMILY[_n] parameter to define which media can be used for backup jobs.

Restrictions and Usage Notes

Before specifying OB_MEDIA_FAMILY[_n] in an RMAN job, note the following:

• This parameter does not affect restore jobs.

• You can only specify a content-managed media family. By default RMAN uses the RMAN-DEFAULT media family.

• Table E-1 explains the criteria used by Oracle Secure Backup when choosing the media family and device for an RMAN backup job.

Syntax

OB_MEDIA_FAMILY::=

OB_MEDIA_FAMILY[_n][=]media_family_name

Semantics

_n

Specifies the copy number of duplexed backups. For duplexed backups, OB_MEDIA_FAMILY_1 is for the first copy, OB_MEDIA_FAMILY_2 is for the second one, and so on.

media_family_name

Specifies the name of the media family.

Examples

Example E-3 uses the SEND command to specify the my_full_backups media family in an RMAN database backup. Note that there is no equal sign between the parameter OB_MEDIA_FAMILY and the value datafile_mf.

SEND 'OB_MEDIA_FAMILY datafile_mf';
BACKUP TABLESPACE users;

Example E-4 makes the same backup as Example E-3, but uses PARMS to set the Oracle Secure Backup media family parameter. Note that there is an equal sign between the parameter OB_MEDIA_FAMILY and the value datafile_mf.

CONFIGURE CHANNEL DEVICE TYPE sbt PARMS  
  'ENV=(OB_MEDIA_FAMILY=datafile_mf)';
BACKUP TABLESPACE users;

OB_RESOURCE_WAIT_TIME

Use the OB_RESOURCE_WAIT_TIME parameter to specify the duration for which a backup or restore job should wait for the required resources to become available.

Restrictions and Usage Notes

Note that you can specify RMAN resource wait times in the following locations, each of which overrides the preceding specifications in the list:

1. The rmanresourcewaittime policy

2. The waittime attribute in a database backup storage selector that matches an RMAN backup job

3. The RMAN channel configuration parameter OB_RESOURCE_WAIT_TIME

Syntax

OB_RESOURCE_WAIT_TIME::=

OB_RESOURCE_WAIT_TIME=duration

Semantics

duration

Specifies how long Oracle Secure Backup should wait for the tape resources to become available. For valid values, refer to the description of the duration placeholder in "duration".

Examples

Example E-5 uses the SEND command to specify that the restore job should wait no longer than 10 minutes for tape resources to become available. Note that there is no equal sign between the parameter OB_RESOURCE_WAIT_TIME and the value.

RUN
{
  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
  SEND 'OB_RESOURCE_WAIT_TIME 1minute';
  RESTORE ARCHIVELOG ALL;
}

Example E-6 uses the ENV parameter to specify the wait time on a configured channel. Note that there is an equal sign between the parameter OB_RESOURCE_WAIT_TIME and the value.

CONFIGURE CHANNEL DEVICE TYPE sbt PARMS
  'ENV=(OB_RESOURCE_WAIT_TIME=1minute)';
RESTORE ARCHIVELOG ALL;