chp6231

RMAN> list backup summary;

40      B  A  A DISK        17-FEB-13 16:05:00 1       1       NO         TAG20130217T160458
41      B  A  A DISK        17-FEB-13 16:05:00 1       1       NO         TAG20130217T160458
42      B  F  A DISK        17-FEB-13 16:05:15 1       1       NO         TAG20130217T160502
43      B  F  A DISK        17-FEB-13 16:05:16 1       1       NO         TAG20130217T160502
44      B  A  A DISK        17-FEB-13 16:05:23 1       1       NO         TAG20130217T160521
45      B  A  A DISK        17-FEB-13 16:05:23 1       1       NO         TAG20130217T160521
46      B  F  A DISK        17-FEB-13 16:05:27 1       1       NO         TAG20130217T160525

RMAN> list backup tag TAG20130217T160458;

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— ——————
40      1.37M      DISK        00:00:01     17-FEB-13 16:05:00
BP Key: 40   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160458
Piece Name: +FRA/db1dup/backupset/2013_02_17/annnf0_tag20130217t160458_0.357.807638699

List of Archived Logs in backup set 40
Thrd Seq     Low SCN    Low Time           Next SCN   Next Time
—- ——- ———- —————— ———- ———
1    21      1031003    17-FEB-13 15:53:35 1031471    17-FEB-13 16:04:17

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— ——————
41      14.50K     DISK        00:00:01     17-FEB-13 16:05:00
BP Key: 41   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160458
Piece Name: +FRA/db1dup/backupset/2013_02_17/annnf0_tag20130217t160458_0.352.807638699

List of Archived Logs in backup set 41
Thrd Seq     Low SCN    Low Time           Next SCN   Next Time
—- ——- ———- —————— ———- ———
1    22      1031471    17-FEB-13 16:04:17 1031474    17-FEB-13 16:04:18
1    23      1031474    17-FEB-13 16:04:18 1031494    17-FEB-13 16:04:57

RMAN>  list backup tag TAG20130217T160502;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— ——————
42      Full    188.53M    DISK        00:00:11     17-FEB-13 16:05:15
BP Key: 42   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160502
Piece Name: +FRA/db1dup/backupset/2013_02_17/nnndf0_tag20130217t160502_0.339.807638705
List of Datafiles in backup set 42
File LV Type Ckp SCN    Ckp Time           Name
—- — —- ———- —————— —-
1       Full 1031509    17-FEB-13 16:05:05 +BIG_DATA/db1dup/datafile/system.263.807624303
4       Full 1031509    17-FEB-13 16:05:05 +BIG_DATA/db1dup/datafile/hh_test.265.807624303

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— ——————
43      Full    218.23M    DISK        00:00:13     17-FEB-13 16:05:16
BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160502
Piece Name: +FRA/db1dup/backupset/2013_02_17/nnndf0_tag20130217t160502_0.358.807638705
List of Datafiles in backup set 43
File LV Type Ckp SCN    Ckp Time           Name
—- — —- ———- —————— —-
2       Full 1031507    17-FEB-13 16:05:04 +BIG_DATA/db1dup/datafile/sysaux.264.807624303
3       Full 1031507    17-FEB-13 16:05:04 +BIG_DATA/db1dup/datafile/undotbs1.266.807624305

RMAN> list backup tag  TAG20130217T160521;

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— ——————
44      2.50K      DISK        00:00:01     17-FEB-13 16:05:23
BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160521
Piece Name: +FRA/db1dup/backupset/2013_02_17/annnf0_tag20130217t160521_0.330.807638723

List of Archived Logs in backup set 44
Thrd Seq     Low SCN    Low Time           Next SCN   Next Time
—- ——- ———- —————— ———- ———
1    24      1031494    17-FEB-13 16:04:57 1031515    17-FEB-13 16:05:12
1    25      1031515    17-FEB-13 16:05:12 1031519    17-FEB-13 16:05:13

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— ——————
45      2.00K      DISK        00:00:01     17-FEB-13 16:05:23
BP Key: 45   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160521
Piece Name: +FRA/db1dup/backupset/2013_02_17/annnf0_tag20130217t160521_0.374.807638723

List of Archived Logs in backup set 45
Thrd Seq     Low SCN    Low Time           Next SCN   Next Time
—- ——- ———- —————— ———- ———
1    26      1031519    17-FEB-13 16:05:13 1031526    17-FEB-13 16:05:20

RMAN> list backup tag TAG20130217T160525;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— ——————
46      Full    9.45M      DISK        00:00:02     17-FEB-13 16:05:27
BP Key: 46   Status: AVAILABLE  Compressed: NO  Tag: TAG20130217T160525
Piece Name: +FRA/db1dup/autobackup/2013_02_17/s_807638725.336.807638727
SPFILE Included: Modification time: 17-FEB-13 15:22:01
SPFILE db_unique_name: DB1DUP
Control File Included: Ckp SCN: 1031541      Ckp time: 17-FEB-13 16:05:25

Leave a Reply

Your email address will not be published. Required fields are marked *