Oracle8i Backup and Recovery Guide
Release 8.1.5

A67773-01

Library

Product

Contents

Index

Prev Prev Next


completedTimeSpec

Syntax


Purpose

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

Requirements

All date strings must be either:

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

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';



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index