Formats de Dates et Recovery Manager

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é !