Database Software

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!

How to find the exact time backup run

YoavMay 8 2012 — edited May 8 2012

Hi,

I would like to know the specific date ( hour + minute) a backup was executed.

For example the output of rman command : list backup of database;
show Completion Time : 08-MAY-12 . I would like to get the exact time .

Please advice.

......

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
33627   Incr 1  256.00K    SBT_TAPE    00:00:05     08-MAY-12    <<<<<<======
        BP Key: 33994   Status: AVAILABLE  Compressed: NO  Tag: TAG20120507T230332
        Handle: bzq1<bzq1_inc_889661:782699508:1>.dbf   Media:
  List of Datafiles in backup set 33627
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  279  1  Incr 8042759810240 08-MAY-12 /bzq1/oracalls_2011_data2/y0211pricing_internet04.dbf
.....

Thanks

This post has been answered by anand prakash - oracle on May 8 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2012

Added on May 8 2012

#performance-availability, #recovery-manager-rman

11 comments

10,225 views