Oracle® Database Recovery Manager Reference 10g Release 1 (10.1) Part Number B10770-01 |
|
|
View PDF |
allocateForMaint::=
Text description of allocateForMaint
To manually allocate a channel in preparation for issuing a CHANGE
, DELETE,
or CROSSCHECK
command. Note that if you use CONFIGURE
to set up automatic channels, then RMAN can use these automatic channels for maintenance operations; you do not have to manually allocate them.
If RMAN allocates the automatic maintenance channel for you, then it uses the same naming convention as any other automatically allocated channel. If you explicitly invoke ALLOCATE
CHANNEL
FOR
MAINTENANCE
, then RMAN uses the following convention for channel naming: ORA_MAINT_
devicetype
_
n
, where devicetype
refers to DISK
or sbt
and n
refers to the channel number. For example, RMAN uses these names for two manually allocated disk channels:
ORA_MAINT_DISK_1 ORA_MAINT_DISK_2
You can allocate multiple maintenance channels for a single job, but you should only use this feature in these scenarios:
See Also:
Oracle Database Backup and Recovery Advanced User's Guide to learn how to crosscheck and delete on multiple channels |
ORA_
to a channel name. RMAN reserves channel names beginning with the ORA_
prefix for its own use.Syntax Element | Description |
---|---|
|
Specifies the type of storage device. See Also: "deviceSpecifier" Note: If you do not specify the |
Specifies control options for the allocated channel. See Also: "allocOperandList" |
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';
This example crosschecks all archived logs on disk (by using the preconfigured disk channel) and tape. 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;
In this example, you perform a crosscheck of backups on two nodes of an Oracle Real Application Clusters configuration:
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;
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 sbt channel and disk channel ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt; DELETE BACKUPSET TAG "weekly_bkup";