D’accord, c’est stupide mais ça aide… Si vous voulez utiliser des formats de date qui vous parlent avec Recovery Manager (RMAN), utilisez NLS_DATE_FORMAT
et to_date
comme ci-dessous :
export NLS_DATE_FORMAT="DD/MM/YYYY HH24:MI:SS"
rman target /
list copy of datafile 1;
List of Datafile Copies
Key File S Completion Time Name
------- ---- - ------------------- ----
3 1 A 16/08/2008 01:56:48 /backup/BLACK/f1z
2 1 A 16/08/2008 00:56:56 /backup/BLACK/f1y
delete copy of datafile 1
completed before
"to_date('16/08/2008 01:00:00','DD/MM/YYYY HH24:MI:SS')";
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
List of Datafile Copies
Key File S Completion Time Name
------- ---- - ------------------- ----
2 1 A 16/08/2008 00:56:56 /backup/BLACK/f1y
Do you really want to delete the above objects (enter YES or NO)? YES
deleted datafile copy
datafile copy filename=/backup/BLACK/f1y recid=2 stamp=662864216
Deleted 1 object
RMAN>
On dirait que je suis à cours d’idée cet été alors posez une question utile à la communauté !