RMAN Commands , 38 of 59

recordSpec

Syntax

Text description of the illustration recordSpec.gif

Purpose

A subclause that specifies which objects the CHANGE, CROSSCHECK, DELETE, and LIST commands should operate on. Most recordSpec options allow you to specify a primary key. Run the LIST command to obtain the key.

Keywords and Parameters

Syntax Element	Description
`BACKUPPIECE`	Specifies a backup piece by `'``media_handle``'`, `primary_key`, or `tag_name`.
`PROXY`	Specifies a proxy copy by `'``media_handle``'`, `primary_key`, or `tag_name`.
`BACKUPSET` `primary_key`	Specifies a backup set by `primary_key`.
`CONTROLFILECOPY`	Specifies a control file copy by `primary_key`, filename pattern (`'filename'`), or `TAG` `=` `tag_name`. If you crosscheck a control file copy, you must specify a filename rather than a primary key.
`DATAFILECOPY`	Specifies a datafile copy by either `primary_key`, filename pattern (`'filename'`), or `TAG` `=` `tag_name`.
`ARCHIVELOG`	Specifies an archived redo log by either `primary_key` or `'``filename``'`.

Examples

Crosschecking Backups: Example

This example crosschecks backup sets specified by primary key:

CROSSCHECK BACKUPSET 507, 508, 509;

Deleting Datafile Copies: Example

This example deletes a specified datafile copy:

DELETE NOPROMPT DATAFILECOPY '?/oradata/users01.cpy';