Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-01
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
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

maintQualifier

Syntax

maintQualifier::=

Text description of maintQualifier.gif follows


Text description of maintQualifier



Purpose

A subclause used to specify database files and archived redo logs.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description

completedTimeSpec

Specifies a range of time for completion of the backup or copy.

See Also: "completedTimeSpec"

DEVICE TYPE deviceSpecifier

Allocates automatic channels for the specified device type only. This option is valid only if you have configured automatic channels and have not manually allocated channels. For example, if you configure automatic disk and tape channels, and issue CHANGE ... DEVICE TYPE DISK, then RMAN allocates only disk channels.

See Also: "deviceSpecifier"

LIKE 'string_pattern'

Restricts datafile copies by specifying a filename pattern. The pattern can contain Oracle pattern matching characters % and _. RMAN only operates on those files whose name matches the pattern.

Note: You cannot use the LIKE option with the LIST ... ARCHIVELOG command.

BACKED UP integer TIMES TO DEVICE TYPE deviceSpecifier

Restricts the command to archived logs that have been successfully backed up integer or more times to the specified media.

TAG = 'tag_name'

Specifies the datafile copies and backup sets by tag. Tag names are not case sensitive and display in all uppercase.

See Also: "BACKUP" for a description of how a tag can be applied to an individual copy of a duplexed backup set, and also for a description of the default filename format for tags

Example

Listing Backups on a Specific Device: Example

The following command lists all backups located on tape and copies located in /tmp:

LIST BACKUP DEVICE TYPE sbt;
LIST COPY LIKE '/tmp';
Deleting Archived Logs That Are Already Backed Up: Example

The following command deletes only those archived logs that have been successfully backed up three or more times to tape:

DELETE ARCHIVELOG ALL BACKED UP 3 TIMES TO DEVICE TYPE sbt;