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

completedTimeSpec

Syntax

completedTimeSpec::=

Text description of completedTimeSpec.gif follows


Text description of completedTimeSpec

Purpose

A subclause that specifies when a backup or copy completed.

Restrictions and Usage Notes

All date strings must be either:

Keywords and Parameters

Syntax Element Description

AFTER 'date_string'

Specifies the time after which the backup was completed.

BEFORE 'date_string'

Specifies the time before which the backup was completed.

BETWEEN 'date_string' AND 'date_string'

Specifies a time range during which the backup was completed. Note that BETWEEN 'date1' AND 'date2' is exactly equivalent to AFTER 'date1' BEFORE 'date2'.

Examples

Crosschecking Backups Within a Time Range: Example

This example crosschecks the backup sets of the database made last month:

CROSSCHECK BACKUP OF DATABASE COMPLETED BETWEEN 'SYSDATE-62' AND 'SYSDATE-31';
Deleting Expired Backups: Example

This example deletes expired backup sets of datafile 1 made in the last two weeks:

DELETE EXPIRED BACKUP OF DATAFILE 1 COMPLETED AFTER 'SYSDATE-14';
Listing Copies: Example

This example lists image copies of datafile ?/oradata/trgt/users01.dbf made before September 27, 2001:

LIST COPY OF DATAFILE '?/oradata/trgt/users01.dbf' 
  COMPLETED BEFORE '27-SEP-01';