recordSpec

Syntax

recordSpec::=

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. Use the output of the LIST command to obtain keys.

Keywords and Parameters

Syntax Element	Description
`ARCHIVELOG`	Specifies an archived redo log by either `primary_key` or `'filename'`.
`BACKUPSET` `primary_key`	Specifies a backup set by `primary_key`.
`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`.
`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`.
`NODUPLICATES`	With `CONTROLFILECOPY` or `DATAFILECOPY`, specifies that only one copy of the control file or datafile copy specified by the rest of the clause should be the target of the operation, even when there are multiple copies.

Examples

Crosschecking Backups: Example This example crosschecks backup sets specified by primary key:

CROSSCHECK BACKUPSET 507, 509;

Deleting Datafile Copies: Example This example deletes a specified datafile copy:

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