Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALLOCATE CHANNEL FOR MAINTENANCE

Syntax

allocateForMaint::=

Description of allocateformaint.gif follows
Description of the illustration allocateformaint.gif

Purpose

To manually allocate a channel in preparation for issuing a CHANGE, DELETE, or CROSSCHECK command.

Note:

If you CONFIGURE at least one channel for each device type you use in your configuration, then you do not need to use ALLOCATE CHANNEL FOR MAINTENANCE at all.

Oracle recommends that you use configured channels instead of maintenance channels. Configured channels can be used for all RMAN I/O to the specified device, not just the maintenance tasks supported by maintenance channels, and they persist across RMAN sessions.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description
DEVICE TYPE = deviceSpecifier Specifies the type of storage device.

See Also: "deviceSpecifier"

Note: If you do not specify the DEVICE TYPE parameter, then you must specify the NAME parameter to identify a particular sequential I/O device. Query the V$BACKUP_DEVICE view for information about available device types and names.

allocOperandList
Specifies control options for the allocated channel.

See Also: "allocOperandList"


Examples

Deleting a Backup Set: Example  This example deletes backup sets from tape created more than a week ago:

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
DELETE NOPROMPT BACKUP OF DATABASE COMPLETED BEFORE 'SYSDATE-7';

Crosschecking Archived Logs: Example  This example crosschecks all archived logs on disk and tape. For disk, the preconfigured disk channel is used; for tape, an SBT channel is allocated manually. If the logs are not found, then RMAN marks them as EXPIRED in the repository:

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
CROSSCHECK ARCHIVELOG ALL;

Crosschecking on Multiple Nodes of an Oracle Real Application Clusters Configuration: Example In this example, you perform a crosscheck of backups on two nodes of an Oracle Real Application Clusters configuration, where each node has access to a subset of backups. It is assumed here that all backups are accessible by at least one of the two nodes used in the crosscheck. Any backups not accessible from at least one of the nodes are marked EXPIRED after the crosscheck.

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK CONNECT 'SYS/change_on_install@inst1';
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK CONNECT 'SYS/change_on_install@inst2';
CROSSCHECK BACKUP;

Note:

Oracle recommends that all nodes in a Real Application Clusters configuration have the same access to all backups on all storage devices.

Deleting on Disk and sbt Channels with One Command: Example In this example, you delete a backup from both disk and tape:

# back up datafile to disk and tape
BACKUP DEVICE TYPE DISK DATAFILE 1 TAG "weekly_bkup";
BACKUP DEVICE TYPE sbt DATAFILE 1 TAG "weekly_bkup";

# manually allocate gsbt channel and disk channel
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
DELETE BACKUPSET TAG "weekly_bkup";