detailed time in RMAN using the list backup command


RMAN> list backup;

List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 432.00K DISK 00:00:01 21-NOV-13
 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090912T125258
 Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET
\2013_21_11\O1_MF_NNNDF_TAG20090912T125258_5BPNTTVT_.BKP
 List of Datafiles in backup set 1
 File LV Type Ckp SCN Ckp Time Name
 ---- -- ---- ---------- --------- ----
 4 Full 833627 21-NOV-13 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF

RMAN> exit

Recovery Manager complete.

C:\Documents and Settings\Administrator>set NLS_DATE_FORMAT=dd-MON-YYYY hh24:mi:ss
C:\Documents and Settings\Administrator>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Nov 21 20:55:01 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TEST (DBID=1991558376)

RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
1 Full 432.00K DISK 00:00:01 21-NOV-13 20:55:11
 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090912T125258
 Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET\
2013_21_11\O1_MF_NNNDF_TAG20090912T125258_5BPNTTVT_.BKP
 List of Datafiles in backup set 1
 File LV Type Ckp SCN Ckp Time Name
 ---- -- ---- ---------- -------------------- ----
 4 Full 833627 12-SEP-2009 20:55:11 C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF
RMAN>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: