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

listObjList

Syntax

listObjList::=

Text description of listObjList.gif follows


Text description of listObjList

dbObject::=

Text description of dbObject.gif follows


Text description of dbObject

Purpose

A subclause used to specify database files and archived redo logs.

Restrictions and Usage Notes

Use this clause in the following commands:

Keywords and Parameters

listObjList
Syntax Element Description

archivelogRecordSpecifier

Specifies a range of archived redo logs.

See Also: "archivelogRecordSpecifier"

CONTROLFILE

Specifies the current control file.

DATABASE SKIP TABLESPACE 'tablespace_name'
[
, 'tablespace_name' ]

Omits the specified tablespaces from the DATABASE specification.

SPFILE

Specifies the current server parameter file.

dbObject
Syntax Element Description

DATABASE

Specifies backup sets or image copies of all files in the current database.

DATAFILE datafileSpec

Specifies datafiles by filename or file number. The clause specifies datafile image copies or backup sets that contain at least one of the datafiles.

See Also: "datafileSpec"

TABLESPACE 'tablespace_name'

Specifies tablespace names. The clause specifies datafile image copies or backup sets that contain at least one of the datafile from the specified tablespace.

Examples

Listing Datafile Copies: Example

The following command lists image copies of all the files in the database, skipping the temp tablespace, which is a dictionary-managed temporary tablespace:

LIST COPY OF DATABASE SKIP TABLESPACE temp;
Crosschecking Archived Redo Logs: Example

The following example queries the media manager for the status of server parameter file and archived redo log backups (either backup sets or image copies) created in the last three months:

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
CROSSCHECK BACKUP OF SPFILE ARCHIVELOG FROM TIME 'SYSDATE-90';
Deleting Expired Control File Backup Sets: Example

The following command deletes expired backups (either backup sets or image copies) of the control file:

DELETE EXPIRED BACKUP OF CONTROLFILE;