RMAN Commands , 34 of 59

maintQualifier

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

Use this clause in the following commands:
- LIST
- CROSSCHECK
- DELETE
The BACKED UP integer TIMES clause applies only to archived redo logs.
You cannot use LIKE with backup pieces.

Syntax Element	Description
`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
completedTimeSpec	Specifies a range of time for completion of the backup or copy. See Also: "completedTimeSpec"
`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.
`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"
`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.

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

LIST BACKUP DEVICE TYPE sbt;
LIST COPY LIKE '/tmp';

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;