listObjList::=
dbObject::=
A subclause used to specify database files and archived redo logs.
Use this clause in the following commands:
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. |
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. |
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;