RMAN LIST BACKUP COMMAND
806464Oct 25 2010 — edited Oct 25 2010I am using the following commands.
RMAN> sql "alter session set nls_date_format=''dd-mon-yyyy HH24:MI:SS''";
2> report unrecoverable database;
3> report need backup days 2 database;
4> list backup;
5> EXIT;
BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------
6249525 Full 68G SBT_TAPE 01:38:05 *25-OCT-2010*
BP Key: 6249547 Status: AVAILABLE Tag: TAG20101025T040741
Even after setting nls_date_format, completion time in list backup command is not returning exact time..it is returning just the date..
how to get completion time in RMAN LIST BACKUP COMMAND with hour,minute and second details...please let me know
I am using catalog database...target database version 9i and catalog db version is 10g.
Thanks,
db