listObjList

Syntax

Text description of the illustration listobjl.gif

Purpose

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

Restrictions and Usage Notes

Use this clause in the following commands:

• LIST

• CROSSCHECK

• DELETE

Keywords and Parameters

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.
archivelogRecordSpecifier	Specifies a range of archived redo logs. See Also: "archivelogRecordSpecifier"
DATABASE	Specifies backup sets or image copies of all files in the current database.
	SKIP TABLESPACE 'tablespace_name'	omits the specified tablespaces from the DATABASE specification.
CONTROLFILE	Specifies the current control file.

Examples

Listing Datafile Copies: Example

The following command lists image copies of all the files in the database, skipping the temp tablespace:

LIST COPY OF DATABASE SKIP TABLESPACE temp;

Crosschecking Archived Redo Logs: Example

The following example queries the media manager for the status of archived redo log backup sets created in the last 90 days:

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
CROSSCHECK BACKUP OF ARCHIVELOG FROM TIME 'SYSDATE-90';

Deleting Expired Control File Backup Sets: Example

The following command deletes expired backups of the control file:

DELETE EXPIRED BACKUP OF CONTROLFILE;