Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

Part Number E10643-06
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

completedTimeSpec

Purpose

Use the completedTimeSpec subclause to specify when a backup or copy completed.

Usage Notes

All date strings must be either:

Syntax

completedTimeSpec::=

This diagram shows the syntax of completedTimeSpec
Description of the illustration completedtimespec.gif

Semantics

Syntax Element Description
AFTER 'date_string' Specifies the time after which the backup was completed (see Example 4-7).
BEFORE 'date_string' Specifies the time before which the backup was completed (see Example 4-9).

BETWEEN 'date_string'
AND 'date_string'
Specifies a time range during which the backup was completed (see Example 4-8). BETWEEN 'date1' AND 'date2' is exactly equivalent to AFTER 'date1' BEFORE 'date2'.

Examples

Example 4-7 Crosschecking Backups Within a Time Range

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

CROSSCHECK BACKUP OF DATABASE 
  COMPLETED BETWEEN 'SYSDATE-62' AND 'SYSDATE-31';

Example 4-8 Deleting Expired Backups

This example deletes expired backups of archived logs made in the last two weeks:

DELETE EXPIRED BACKUP OF ARCHIVELOG ALL
  COMPLETED AFTER 'SYSDATE-14';

Example 4-9 Listing Copies

This example lists image copies of data file /disk1/oradata/prod/users01.dbf made before March 9, 2007:

RMAN> LIST COPY OF DATAFILE '/disk1/oradata/prod/users01.dbf' COMPLETED BEFORE '9-MAR-07';

List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
3794    28   A 06-MAR-07       1010097    06-MAR-07
        Name: /disk1/oradata/prod/users01.dbf
3793    28   A 06-MAR-07       1009950    06-MAR-07
        Name: /disk2/PROD/datafile/o1_mf_users_2yvg4v6o_.dbf
        Tag: TAG20070306T105314