All date strings must be either:
Created by a SQL expression that returns a
DATE value, as in the following examples:
TO_DATE('09/30/2000 08:00:00','MM/DD/YY HH24:MI:SS')
TO_DATE function specifies dates independently of the current Global Technology environment variable settings.
||Specifies the time after which the backup was completed (see Example 4-7).|
||Specifies the time before which the backup was completed (see Example 4-9).|
||Specifies a time range during which the backup was completed (see Example 4-8).
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 backups of archived logs made in the last two weeks:
DELETE EXPIRED BACKUP OF ARCHIVELOG ALL COMPLETED AFTER 'SYSDATE-14';
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