Oracle9i Recovery Manager Reference Release 1 (9.0.1) Part Number A90136-02 |
|
RMAN Commands , 14 of 60
A subclause that specifies when a backup or copy completed.
All date strings must be either:
DATE
value, as in the following examples:
The TO_DATE
technique specifies dates independently of the current Global Technology environment variable settings.
This example crosschecks the backup sets of the database made last month:
CROSSCHECK BACKUP OF DATABASE COMPLETED BETWEEN 'SYSDATE-62' AND 'SYSDATE-31';
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';
This example lists image copies of datafile /oracle/dbs/tbs_22.f
made before October 13, 2000:
LIST COPY OF DATAFILE '/oracle/dbs/tbs_22.f' COMPLETED BEFORE 'Oct 13 2000 20:31:10';
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|