---

listObjList

Syntax

Purpose

A sub-clause used to specify database files and archived redo logs.

Requirements

Use this clause in the following commands:

• list

• crosscheck

• deleteExpired

Keywords and Parameters

datafile datafileSpec	specifies datafiles by filename for file number. The clause specifies datafile image copies or backup sets that contain at least one of the datafiles. See "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.
archivelogRecord- Specifier	specifies a range of archived redo logs. See "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

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

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 type 'sbt_tape';
crosscheck 
   backup
   of archivelog 
   from time 'SYSDATE-90';
release channel;

Deleting Expired Control File Backup Sets

The following command deletes expired backups of the control file:

delete expired backup of controlfile;

Related Topics

"archivelogRecordSpecifier"

"crosscheck"

"datafileSpec"

"deleteExpired"

"list"

---