Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN LIST BACKUP COMMAND

806464Oct 25 2010 — edited Oct 25 2010
I 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
This post has been answered by Pierre Forstmann on Oct 25 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2010
Added on Oct 25 2010
4 comments
398 views