completedTimeSpec

Syntax

Purpose

A sub-clause that specifies when a backup or copy completed.

Requirements

All date strings must be either:

• Formatted according to the NLS date format specification currently in effect.

• Created by a SQL expression that returns a DATE value, for example, 'SYSDATE-30'.

Use this sub-clause in conjunction with the following commands:

• crosscheck

• deleteExpired

• list

  Note: The from time and until time parameters no longer work with commands that use completedTimeSpec. If you run a script that specifies these parameters, the job will fail.

Keywords and Parameters

after 'date_string'	specifies the time after which the backup was completed.
between 'date_string' and 'date_string'	specifies a time range during which the backup was completed.
before 'date_string'	specifies the time before which the backup was completed.

Examples

Crosschecking Backups within a Time Range

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

crosscheck backup of database between 'SYSDATE-62' and 'SYSDATE-31';

Deleting Expired Backups

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

delete expired backup of datafile 1 after 'SYSDATE-14';

Listing Copies

This example lists image copies of /oracle/dbs/tbs_22.f made before December 13, 1998:

list copy of datafile '/oracle/dbs/tbs_22.f' before 'Dec 13 1998 20:31:10';