Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
|
|
View PDF |
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';