Let we discuss about Report operation on Rman in oracle11g

Here Rman  “ List “ and  “ Report”  Commands will generate the report on backup activities based on the rman

 

List commands

 

-It 'll display the information about backups and datafile copies listed in the repository

1) By Backup  “ LIST BACKUP OF DATABASE BY BACKUP” –  display the output by backup set

2) By File  “LIST BACKUP BY FILE” – list the backup  according to which file was backed up

3) Summary “List backup summary” – display summary output

4) Expired  “List expired backup” or “List expired copy”

             – List backup that is recorded in the  Rman repository   but it was not available in the expected location  on disk or tape during the  last “crosscheck “ command, It(expired backup) may have been deleted  by operating system utility

5) Recoverable “List backup  recoverable” –display the result of data file backup or copies which are in “Available” state that can be restored or recoverable  the database

                     

1)By Backup:

RMAN> list backup of database by backup;


List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

84      Full    3.75G      DISK        00:02:43     02-MAY-17

        BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T162002

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\BACKUPSET\20

17_05_02\O1_MF_NNNDF_TAG20170502T162002_DJJS2VG6_.BKP

  List of Datafiles in backup set 84

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

  5       Full 4882837    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

87      Incr 1  65.46M     DISK        00:01:15     02-MAY-17

        BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T163739

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3AS

38AQK_1_1_DHONI_942943060_106_1

  List of Datafiles in backup set 87

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

  5    1  Incr 4883466    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

90      Incr 0  3.74G      DISK        00:02:33     02-MAY-17

        BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: INCRE_BACKUP_1

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3DS

38B0S_1_1_DHONI_942943260_109_1

  List of Datafiles in backup set 90

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

91      Incr 1  9.87M      DISK        00:00:03     02-MAY-17

        BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: INCRE_BACKUP_1

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3ES

38C3D_1_1_DHONI_942944365_110_1

  List of Datafiles in backup set 91

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  5    1  Incr 4883999    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6    1  Incr 4883999    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

93      Incr 1  11.39M     DISK        00:01:03     02-MAY-17

        BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: INCRE_CULMUL

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3GS

38CF7_1_1_DHONI_942944743_112_1

  List of Datafiles in backup set 93

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

  5    1  Incr 4884186    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF



2) By File:

RMAN> list backup by file;



List of Datafile Backups

========================


File Key     TY LV S Ckp SCN    Ckp Time  #Pieces #Copies Compressed Tag

---- ------- -  -- - ---------- --------- ------- ------- ---------- ---

1    93      B  1  A 4884186    02-MAY-17 1       1       NO         INCRE_CULMU

L

     90      B  0  A 4883569    02-MAY-17 1       1       NO         INCRE_BACKU

P_1

     87      B  1  A 4883466    02-MAY-17 1       1       NO         TAG20170502

T163739

     84      B  F  A 4882837    02-MAY-17 1       1       NO         TAG20170502

T162002

2    93      B  1  A 4884186    02-MAY-17 1       1       NO         INCRE_CULMU

L

     90      B  0  A 4883569    02-MAY-17 1       1       NO         INCRE_BACKU

P_1

     87      B  1  A 4883466    02-MAY-17 1       1       NO         TAG20170502

T163739

     84      B  F  A 4882837    02-MAY-17 1       1       NO         TAG20170502

T162002

3    93      B  1  A 4884186    02-MAY-17 1       1       NO         INCRE_CULMU

L

     90      B  0  A 4883569    02-MAY-17 1       1       NO         INCRE_BACKU

P_1

     87      B  1  A 4883466    02-MAY-17 1       1       NO         TAG20170502

T163739

     84      B  F  A 4882837    02-MAY-17 1       1       NO         TAG20170502

T162002

4    93      B  1  A 4884186    02-MAY-17 1       1       NO         INCRE_CULMU

L

     90      B  0  A 4883569    02-MAY-17 1       1       NO         INCRE_BACKU

P_1

     87      B  1  A 4883466    02-MAY-17 1       1       NO         TAG20170502

T163739

     84      B  F  A 4882837    02-MAY-17 1       1       NO         TAG20170502

T162002

5    93      B  1  A 4884186    02-MAY-17 1       1       NO         INCRE_CULMU

L

     91      B  1  A 4883999    02-MAY-17 1       1       NO         INCRE_BACKU

P_1

     87      B  1  A 4883466    02-MAY-17 1       1       NO         TAG20170502

T163739

     84      B  F  A 4882837    02-MAY-17 1       1       NO         TAG20170502

T162002

6    93      B  1  A 4884186    02-MAY-17 1       1       NO         INCRE_CULMU

L

     91      B  1  A 4883999    02-MAY-17 1       1       NO         INCRE_BACKU

P_1

     87      B  1  A 4883466    02-MAY-17 1       1       NO         TAG20170502

T163739

     84      B  F  A 4882837    02-MAY-17 1       1       NO         TAG20170502

T162002


List of Archived Log Backups

============================


Thrd Seq     Low SCN    Low Time  BS Key  S #Pieces #Copies Compressed Tag

---- ------- ---------- --------- ------- - ------- ------- ---------- ---

1    1       3162174    09-FEB-17 82      X 1       1       NO         TAG201705

02T161640

                                  78      A 1       1       NO         TAG201702

10T150054

1    2       3183784    10-FEB-17 82      X 1       1       NO         TAG201705

02T161640

                                  78      A 1       1       NO         TAG201702

10T150054

1    3       3193955    10-FEB-17 82      X 1       1       NO         TAG201705

02T161640

1    1       3194488    10-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    2       3218367    13-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    3       3241050    13-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    4       3270612    15-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    5       3304170    16-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    6       3341359    17-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    7       3376504    20-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    8       3410447    21-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    9       3444395    22-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    10      3478914    23-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    11      3513582    24-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    12      3546965    01-JAN-12 83      X 1       1       NO         TAG201705

02T161640

1    13      3583617    28-FEB-17 83      X 1       1       NO         TAG201705

02T161640

1    14      3619923    01-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    15      3653869    02-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    16      3691113    06-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    17      3726993    07-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    18      3771168    07-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    19      3791728    08-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    20      3824491    09-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    21      3855515    09-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    22      3875826    09-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    23      3897827    09-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    24      3919856    10-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    25      3942498    14-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    26      3977630    15-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    27      4013703    17-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    28      4017617    17-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    29      4048307    20-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    30      4075562    21-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    31      4110742    22-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    32      4146572    23-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    33      4181043    24-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    34      4214163    27-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    35      4248322    28-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    36      4281165    30-MAR-17 83      X 1       1       NO         TAG201705

02T161640

1    37      4307872    01-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    38      4336511    03-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    39      4370462    04-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    40      4407099    06-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    41      4428427    06-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    42      4465285    07-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    43      4497374    10-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    44      4531721    17-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    45      4568139    18-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    46      4600316    20-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    47      4636041    21-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    48      4669091    22-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    49      4679260    22-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    50      4701633    24-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    51      4734245    25-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    52      4767635    26-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    53      4803036    27-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    54      4835596    28-APR-17 83      X 1       1       NO         TAG201705

02T161640

1    55      4868511    02-MAY-17 86      A 1       1       NO         TAG201705

02T163738

                                  83      X 1       1       NO         TAG201705

02T161640

1    56      4882699    02-MAY-17 86      A 1       1       NO         TAG201705

02T163738

1    57      4882956    02-MAY-17 86      A 1       1       NO         TAG201705

02T163738

1    58      4882992    02-MAY-17 86      A 1       1       NO         TAG201705

02T163738

1    59      4883454    02-MAY-17 89      A 1       1       NO         TAG201705

02T163908


List of Control File Backups

============================


CF Ckp SCN Ckp Time  BS Key  S #Pieces #Copies Compressed Tag

---------- --------- ------- - ------- ------- ---------- ---

4884213    02-MAY-17 94      A 1       1       NO         INCRE_CULMUL

4884001    02-MAY-17 92      A 1       1       NO         INCRE_BACKUP_1

4883502    02-MAY-17 88      A 1       1       NO         TAG20170502T163739

4882926    02-MAY-17 85      A 1       1       NO         TAG20170502T162248

3384793    20-FEB-17 80      A 1       1       NO         TAG20170220T151249

List of SPFILE Backups

======================


Modification Time BS Key  S #Pieces #Copies Compressed Tag

----------------- ------- - ------- ------- ---------- ---

02-MAY-17         94      A 1       1       NO         INCRE_CULMUL

02-MAY-17         92      A 1       1       NO         INCRE_BACKUP_1

02-MAY-17         88      A 1       1       NO         TAG20170502T163739

02-MAY-17         85      A 1       1       NO         TAG20170502T162248

20-FEB-17         80      A 1       1       NO         TAG20170220T151249


 

3) Summary

   I)Backup summary

RMAN> list backup summary;



List of Backups

===============

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

78      B  A  A DISK        10-FEB-17       1       1       NO         TAG201702

10T150054

80      B  F  A DISK        20-FEB-17       1       1       NO         TAG201702

20T151249

82      B  A  X DISK        02-MAY-17       1       1       NO         TAG201705

02T161640

83      B  A  X DISK        02-MAY-17       1       1       NO         TAG201705

02T161640

84      B  F  A DISK        02-MAY-17       1       1       NO         TAG201705

02T162002

85      B  F  A DISK        02-MAY-17       1       1       NO         TAG201705

02T162248

86      B  A  A DISK        02-MAY-17       1       1       NO         TAG201705

02T163738

87      B  1  A DISK        02-MAY-17       1       1       NO         TAG201705

02T163739

88      B  1  A DISK        02-MAY-17       1       1       NO         TAG201705

02T163739

89      B  A  A DISK        02-MAY-17       1       1       NO         TAG201705

02T163908

90      B  0  A DISK        02-MAY-17       1       1       NO         INCRE_BAC

KUP_1

91      B  1  A DISK        02-MAY-17       1       1       NO         INCRE_BAC

KUP_1

92      B  1  A DISK        02-MAY-17       1       1       NO         INCRE_BAC

KUP_1

93      B  1  A DISK        02-MAY-17       1       1       NO         INCRE_CUL

MUL

94      B  1  A DISK        02-MAY-17       1       1       NO         INCRE_CUL

MUL



  II)Database Summary

RMAN> List backup of database summary;



List of Backups

===============

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

84      B  F  A DISK        02-MAY-17       1       1       NO         TAG201705

02T162002

87      B  1  A DISK        02-MAY-17       1       1       NO         TAG201705

02T163739

90      B  0  A DISK        02-MAY-17       1       1       NO         INCRE_BAC

KUP_1

91      B  1  A DISK        02-MAY-17       1       1       NO         INCRE_BAC

KUP_1

93      B  1  A DISK        02-MAY-17       1       1       NO         INCRE_CUL

MUL

4) Recoverable

RMAN> list  backup recoverable;



List of Backup Sets

===================



BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

78      17.22M     DISK        00:00:01     10-FEB-17

        BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: TAG20170210T150054

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\BACKUPSET\20

17_02_10\O1_MF_ANNNN_TAG20170210T150054_D9V22KNB_.BKP


  List of Archived Logs in backup set 78

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    1       3162174    09-FEB-17 3183784    10-FEB-17

  1    2       3183784    10-FEB-17 3193955    10-FEB-17


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

80      Full    9.70M      DISK        00:00:02     20-FEB-17

        BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20170220T151249

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\AUTOBACKUP\2

017_02_20\O1_MF_S_936457969_DBOGJTHZ_.BKP

  SPFILE Included: Modification time: 20-FEB-17

  SPFILE db_unique_name: DHONI

  Control File Included: Ckp SCN: 3384793      Ckp time: 20-FEB-17


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

84      Full    3.75G      DISK        00:02:43     02-MAY-17

        BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T162002

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\BACKUPSET\20

17_05_02\O1_MF_NNNDF_TAG20170502T162002_DJJS2VG6_.BKP

  List of Datafiles in backup set 84

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

  5       Full 4882837    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6       Full 4882837    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

85      Full    9.70M      DISK        00:00:02     02-MAY-17

        BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T162248

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\AUTOBACKUP\2

017_05_02\O1_MF_S_942942168_DJJS81O9_.BKP

  SPFILE Included: Modification time: 02-MAY-17

  SPFILE db_unique_name: DHONI

  Control File Included: Ckp SCN: 4882926      Ckp time: 02-MAY-17


BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

86      21.57M     DISK        00:00:01     02-MAY-17

        BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T163738

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_39S

38AQI_1_1_DHONI_942943058_105_1


  List of Archived Logs in backup set 86

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    55      4868511    02-MAY-17 4882699    02-MAY-17

  1    56      4882699    02-MAY-17 4882956    02-MAY-17

  1    57      4882956    02-MAY-17 4882992    02-MAY-17

  1    58      4882992    02-MAY-17 4883454    02-MAY-17


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

87      Incr 1  65.46M     DISK        00:01:15     02-MAY-17

        BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T163739

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3AS

38AQK_1_1_DHONI_942943060_106_1

  List of Datafiles in backup set 87

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

  5    1  Incr 4883466    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6    1  Incr 4883466    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

88      Incr 1  9.70M      DISK        00:00:02     02-MAY-17

        BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T163739

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3BS

38AT9_1_1_DHONI_942943145_107_1

  SPFILE Included: Modification time: 02-MAY-17

  SPFILE db_unique_name: DHONI

  Control File Included: Ckp SCN: 4883502      Ckp time: 02-MAY-17


BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

89      6.50K      DISK        00:00:00     02-MAY-17

        BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20170502T163908

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3CS

38ATC_1_1_DHONI_942943148_108_1


  List of Archived Logs in backup set 89

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    59      4883454    02-MAY-17 4883508    02-MAY-17


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

90      Incr 0  3.74G      DISK        00:02:33     02-MAY-17

        BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: INCRE_BACKUP_1

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3DS

38B0S_1_1_DHONI_942943260_109_1

  List of Datafiles in backup set 90

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4    0  Incr 4883569    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

91      Incr 1  9.87M      DISK        00:00:03     02-MAY-17

        BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: INCRE_BACKUP_1

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3ES

38C3D_1_1_DHONI_942944365_110_1

  List of Datafiles in backup set 91

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  5    1  Incr 4883999    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6    1  Incr 4883999    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

92      Incr 1  9.70M      DISK        00:00:02     02-MAY-17

        BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: INCRE_BACKUP_1

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3FS

38C3K_1_1_DHONI_942944372_111_1

  SPFILE Included: Modification time: 02-MAY-17

  SPFILE db_unique_name: DHONI

  Control File Included: Ckp SCN: 4884001      Ckp time: 02-MAY-17


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

93      Incr 1  11.39M     DISK        00:01:03     02-MAY-17

        BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: INCRE_CULMUL

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3GS

38CF7_1_1_DHONI_942944743_112_1

  List of Datafiles in backup set 93

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF


  2    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.D

BF

  3    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF


  4    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

  5    1  Incr 4884186    02-MAY-17 D:\REC_CATALOG\REC_CATALOG.DBF

  6    1  Incr 4884186    02-MAY-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

94      Incr 1  9.70M      DISK        00:00:01     02-MAY-17

        BP Key: 94   Status: AVAILABLE  Compressed: NO  Tag: INCRE_CULMUL

        Piece Name: C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\DH_3HS

38CH9_1_1_DHONI_942944809_113_1

  SPFILE Included: Modification time: 02-MAY-17

  SPFILE db_unique_name: DHONI

  Control File Included: Ckp SCN: 4884213      Ckp time: 02-MAY-17




5) Expired

RMAN> list expired backup;



List of Backup Sets

===================



BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

82      17.31M     DISK        00:00:01     02-MAY-17

        BP Key: 82   Status: EXPIRED  Compressed: NO  Tag: TAG20170502T161640

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\BACKUPSET\20

17_05_02\O1_MF_ANNNN_TAG20170502T161640_DJJRWNXZ_.BKP


  List of Archived Logs in backup set 82

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    1       3162174    09-FEB-17 3183784    10-FEB-17

  1    2       3183784    10-FEB-17 3193955    10-FEB-17

  1    3       3193955    10-FEB-17 3194488    10-FEB-17


BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

83      547.33M    DISK        00:00:26     02-MAY-17

        BP Key: 83   Status: EXPIRED  Compressed: NO  Tag: TAG20170502T161640

        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\DHONI\BACKUPSET\20

17_05_02\O1_MF_ANNNN_TAG20170502T161640_DJJRWRSV_.BKP


  List of Archived Logs in backup set 83

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    1       3194488    10-FEB-17 3218367    13-FEB-17

  1    2       3218367    13-FEB-17 3241050    13-FEB-17

  1    3       3241050    13-FEB-17 3270612    15-FEB-17

  1    4       3270612    15-FEB-17 3304170    16-FEB-17

  1    5       3304170    16-FEB-17 3341359    17-FEB-17

  1    6       3341359    17-FEB-17 3376504    20-FEB-17

  1    7       3376504    20-FEB-17 3410447    21-FEB-17

  1    8       3410447    21-FEB-17 3444395    22-FEB-17

  1    9       3444395    22-FEB-17 3478914    23-FEB-17

  1    10      3478914    23-FEB-17 3513582    24-FEB-17

  1    11      3513582    24-FEB-17 3546965    01-JAN-12

  1    12      3546965    01-JAN-12 3583617    28-FEB-17

  1    13      3583617    28-FEB-17 3619923    01-MAR-17

  1    14      3619923    01-MAR-17 3653869    02-MAR-17

  1    15      3653869    02-MAR-17 3691113    06-MAR-17

  1    16      3691113    06-MAR-17 3726993    07-MAR-17

  1    17      3726993    07-MAR-17 3771168    07-MAR-17

  1    18      3771168    07-MAR-17 3791728    08-MAR-17

  1    19      3791728    08-MAR-17 3824491    09-MAR-17

  1    20      3824491    09-MAR-17 3855515    09-MAR-17

  1    21      3855515    09-MAR-17 3875826    09-MAR-17

  1    22      3875826    09-MAR-17 3897827    09-MAR-17

  1    23      3897827    09-MAR-17 3919856    10-MAR-17

  1    24      3919856    10-MAR-17 3942498    14-MAR-17

  1    25      3942498    14-MAR-17 3977630    15-MAR-17

  1    26      3977630    15-MAR-17 4013703    17-MAR-17

  1    27      4013703    17-MAR-17 4017617    17-MAR-17

  1    28      4017617    17-MAR-17 4048307    20-MAR-17

  1    29      4048307    20-MAR-17 4075562    21-MAR-17

  1    30      4075562    21-MAR-17 4110742    22-MAR-17

  1    31      4110742    22-MAR-17 4146572    23-MAR-17

  1    32      4146572    23-MAR-17 4181043    24-MAR-17

  1    33      4181043    24-MAR-17 4214163    27-MAR-17

  1    34      4214163    27-MAR-17 4248322    28-MAR-17

  1    35      4248322    28-MAR-17 4281165    30-MAR-17

  1    36      4281165    30-MAR-17 4307872    01-APR-17

  1    37      4307872    01-APR-17 4336511    03-APR-17

  1    38      4336511    03-APR-17 4370462    04-APR-17

  1    39      4370462    04-APR-17 4407099    06-APR-17

  1    40      4407099    06-APR-17 4428427    06-APR-17

  1    41      4428427    06-APR-17 4465285    07-APR-17

  1    42      4465285    07-APR-17 4497374    10-APR-17

  1    43      4497374    10-APR-17 4531721    17-APR-17

  1    44      4531721    17-APR-17 4568139    18-APR-17

  1    45      4568139    18-APR-17 4600316    20-APR-17

  1    46      4600316    20-APR-17 4636041    21-APR-17

  1    47      4636041    21-APR-17 4669091    22-APR-17

  1    48      4669091    22-APR-17 4679260    22-APR-17

  1    49      4679260    22-APR-17 4701633    24-APR-17

  1    50      4701633    24-APR-17 4734245    25-APR-17

  1    51      4734245    25-APR-17 4767635    26-APR-17

  1    52      4767635    26-APR-17 4803036    27-APR-17

  1    53      4803036    27-APR-17 4835596    28-APR-17

  1    54      4835596    28-APR-17 4868511    02-MAY-17

  1    55      4868511    02-MAY-17 4882699    02-MAY-17

Report Commands

 

The “Report “ the command performs more complex analysis than “LIST”

 

1)Need Backup “Report need backup database”

 

  -Which files need to take backup under the current retention policy

 

2)Obsolete “Report Obsolete”

 

  - Lists backups that are obsolete under the configured backup retention policy

 

3)Schema “Report Schema”

 

  -Display the current time or different time the  tablespace and data files info of the database

 

4)Unrecoverable “Report Unrecoverable”

 

  -Display the list  of datafiles which is not recoverable from the database since the  last backup


1)Need Backup

RMAN> report need backup database;


RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 5

Report of files with less than 5 redundant backups

File #bkps Name

---- ----- -----------------------------------------------------

1    2     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF

2    2     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF

3    2     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF

4    2     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF

5    3     D:\REC_CATALOG\REC_CATALOG.DBF

6    3     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.DBF


2)Obsolete

RMAN> REPORT OBSOLETE;


RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 5

no obsolete backups found

3)Schema

RMAN> report schema;


Report of database schema for database with db_unique_name DHONI


List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    370      SYSTEM               ***     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYS

TEM.DBF

2    670      SYSAUX               ***     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UND

OTBS1.DBF

3    430      UNDOTBS1             ***     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYS

AUX.DBF

4    3260     USERS                ***     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USE

RS.DBF

5    149      REC_CATALOG          ***     D:\REC_CATALOG\REC_CATALOG.DBF

6    50       VR                   ***     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\VR.

DBF


List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    20       TEMP                 32767       C:\ORACLEXE\APP\ORACLE\ORADATA\XE

\TEMP.DBF

 

 

Diff between List and Report in Rman: 

List

Report

1) List display general info about backup And data files

It 'll give the info more complex Analysis than List

2) Most of the list commands display Backup,backup set, which files are backedup, backup summary, And expired backup details

Report commands 'll give current or diff time tablespace and datafiles,unrecoverable datafiles, Need to take backup files details

     

Source:Oracle Website