Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

recordSpec

Syntax

recordSpec::=

Description of recordspec.gif follows
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. 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';