Oracle9i Recovery Manager Reference
Release 1 (9.0.1)

Part Number A90136-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

RMAN Commands , 38 of 60


recordSpec

Syntax


Text description of recordsp.gif follows
Text description of the illustration recordsp.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

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'

archivelogRecordSpecifier clause 

Specifies a range of archived redo logs.

See Also: "archivelogRecordSpecifier" 

Examples

Crosschecking Backups: Example

This example crosschecks a set of backup sets specified by primary key:

CROSSCHECK BACKUPPIECE 507, 508, 509;

Deleting Datafile Copies: Example

This example deletes a specified datafile copy:

DELETE DATAFILECOPY "df1_copy.f";

Listing Expired Archived Logs: Example

This example lists all expired archived redo logs:

LIST EXPIRED ARCHIVELOG ALL;

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback