Skip Headers

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

Part Number B10770-02
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

recordSpec

Syntax

recordSpec::=

Text description of recordSpec.gif follows


Text description of 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. Run the LIST command to obtain the key.

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.

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';