Monitoring RMAN Backup

1.crosscheck backup
2.crosscheck archivelog all
3.listout expired backup and expired archivelog all

Connect Rman:
[root@ltkbwlndb01 ~]# su - oraprod
[oraprod@ltkbwlndb01 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Aug 21 03:01:09 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=191713860)

RMAN>

RMAN> crosscheck backup device type disk;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=65 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=175 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=413 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=479 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=699 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=850 device type=DISK

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_1 RECID=590076 STAMP=952279505

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_2 RECID=590077 STAMP=952279711

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_3 RECID=590078 STAMP=952279948

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_4 RECID=590079 STAMP=952280172

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_5 RECID=590080 STAMP=952280367

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_6 RECID=590081 STAMP=952280559

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_7 RECID=590082 STAMP=952280755

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_8 RECID=590083 STAMP=952280998

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_9 RECID=590084 STAMP=952281251

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_10 RECID=590085 STAMP=952281432

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_11 RECID=590086 STAMP=952281602

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_12 RECID=590087 STAMP=952281754

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_13 RECID=590088 STAMP=952281902

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_14 RECID=590089 STAMP=952282038

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9dsc58eh_366893_15 RECID=590090 STAMP=952282171

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_1 RECID=590091 STAMP=952279505

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_2 RECID=590092 STAMP=952279726

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_3 RECID=590093 STAMP=952279945

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_4 RECID=590094 STAMP=952280165

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_5 RECID=590095 STAMP=952280392

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_6 RECID=590096 STAMP=952280616

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/d03/backup/prodbackup/BackupPROD_DB_9fsc58eh_366895_7 RECID=590097 STAMP=952280853

backup piece handle=/d03/backup/prodbackup/cntrl_c-191713860-20170819-03 RECID=591007 STAMP=952455505

Crosschecked 524 objects

RMAN> list expired backup;

  469     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_data469.dbf

  479     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_data479.dbf

  490     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_data490.dbf

  500     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_data500.dbf

  510     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_idx510.dbf

  519     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_idx519.dbf

  525     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_idx525.dbf

  535     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_tx_idx535.dbf

  551     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_interface551.dbf

  562     Full 37119983424 19-AUG-17 /d01/oracle/PROD/proddata/apps_ts_queues562.dbf

  Backup Set Copy #1 of backup set 365617

  Device Type Elapsed Time Completion Time Compressed Tag

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

  DISK        00:50:39     19-AUG-17       YES        TAG20170819T180504

    List of Backup Pieces for backup set 365617 Copy #1

    BP Key  Pc# Status      Piece Name

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

    590959  1   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_1

    590960  2   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_2

    590961  3   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_3

    590962  4   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_4

    590963  5   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_5

    590964  6   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_6

    590965  7   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_7

    590966  8   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_8

    590967  9   EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_9

    590968  10  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_10

    590969  11  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_11

    590970  12  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_12

    590971  13  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_13

    590972  14  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_14

    590973  15  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_15

    590974  16  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_16

    590975  17  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_17

    590976  18  EXPIRED     /d03/backup/prodbackup/BackupPROD_DB_nbscah6h_367339_18

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

365629  Full    38.05M     DISK        00:00:00     19-AUG-17

        BP Key: 591007   Status: EXPIRED  Compressed: NO  Tag: TAG20170819T185825

        Piece Name: /d03/backup/prodbackup/cntrl_c-191713860-20170819-03

  SPFILE Included: Modification time: 18-AUG-17

  SPFILE db_unique_name: PROD

  Control File Included: Ckp SCN: 37123802958   Ckp time: 19-AUG-17

RMAN>

RMAN> delete expired backup;

590996  365618  20  1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_ngscah6h_367344_20

590997  365619  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nuscak9d_367358_1

590998  365620  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_npscak9d_367353_1

590999  365621  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nqscak9d_367354_1

591000  365622  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nlscak9d_367349_1

591001  365623  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nrscak9d_367355_1

591002  365624  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nsscak9d_367356_1

591003  365625  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_ntscak9d_367357_1

591004  365626  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nnscak9d_367351_1

591005  365627  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_noscak9d_367352_1

591006  365628  1   1   EXPIRED     DISK        /d03/backup/prodbackup/BackupPROD_DB_nmscak9d_367350_1

591007  365629  1   1   EXPIRED     DISK        /d03/backup/prodbackup/cntrl_c-191713860-20170819-03

Do you really want to delete the above objects (enter YES or NO)?YES

backup piece handle=/d03/backup/prodbackup/cntrl_c-191713860-20170819-03 RECID=591007 STAMP=952455505

Deleted 524 EXPIRED objects

RMAN> crosscheck archivelog all;

validation succeeded for archived log

archived log file name=/d02/oracle/PROD/archive/1_60914_779875526.dbf RECID=59712 STAMP=952555371

validation succeeded for archived log

archived log file name=/d02/oracle/PROD/archive/1_60915_779875526.dbf RECID=59713 STAMP=952563970

validation succeeded for archived log

archived log file name=/d02/oracle/PROD/archive/1_60916_779875526.dbf RECID=59714 STAMP=952567317

validation succeeded for archived log

archived log file name=/d02/oracle/PROD/archive/1_60917_779875526.dbf RECID=59715 STAMP=952568949

validation succeeded for archived log

archived log file name=/d02/oracle/PROD/archive/1_60918_779875526.dbf RECID=59716 STAMP=952570798

Crosschecked 1100 objects

RMAN>

RMAN> list expired archivelog all;

specification does not match any archived log in the repository

If you found any expired archive logs delete using below command

RMAN> list expired archivelog all;

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

released channel: ORA_DISK_4

released channel: ORA_DISK_5

released channel: ORA_DISK_6

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=65 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=175 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=413 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=479 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=699 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=850 device type=DISK

specification does not match any archived log in the repository

RMAN>