A subclause that specifies when a backup or copy completed.
All date strings must be either:
Formatted according to the Global Technology date format specification currently in effect.
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 technique specifies dates independently of the current Global Technology environment variable settings.
Note:In Oracle8i, the
TIMEsyntax in the
DELETEcommands was replaced with
completedTimeSpec. If you are adapting an RMAN script from before Oracle8i for use in the current release, then you must update these commands for the script to work correctly.
||Specifies the time after which the backup was completed.|
||Specifies the time before which the backup was completed.|
||Specifies a time range during which the backup was completed. Note that
CROSSCHECK BACKUP OF DATABASE COMPLETED BETWEEN 'SYSDATE-62' AND 'SYSDATE-31';
DELETE EXPIRED BACKUP OF DATAFILE 1 COMPLETED AFTER 'SYSDATE-14';
LIST COPY OF DATAFILE '?/oradata/trgt/users01.dbf' COMPLETED BEFORE '27-SEP-01';