[oratest@oracle ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Thu Sep 9 22:50:22 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST (DBID=2378581000)
RMAN> crosscheck backup; using channel ORA_DISK_1 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0106mhr1_1_1 RECID=1 STAMP=1080772449 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210816-00 RECID=2 STAMP=1080772496 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0306mo87_1_1 RECID=3 STAMP=1080779015 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210817-00 RECID=4 STAMP=1080779016 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/050797sg_1_1 RECID=5 STAMP=1081384849 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210824-00 RECID=6 STAMP=1081384850 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/070798lh_1_1 RECID=7 STAMP=1081385650 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-01 RECID=8 STAMP=1081385651 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/090798lu_1_1 RECID=9 STAMP=1081385662 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-02 RECID=10 STAMP=1081385719 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0b07bnao_1_1 RECID=11 STAMP=1081466201 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-03 RECID=12 STAMP=1081466202 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0d07bnbi_1_1 RECID=13 STAMP=1081466226 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-04 RECID=14 STAMP=1081466242 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0f07e69t_1_1 RECID=15 STAMP=1081547069 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210825-00 RECID=16 STAMP=1081547125 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0h07e6de_1_1 RECID=17 STAMP=1081547183 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210825-01 RECID=18 STAMP=1081547198 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210830-00 RECID=19 STAMP=1081978741 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0m07rmdf_1_1 RECID=20 STAMP=1081989551 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210831-00 RECID=21 STAMP=1081989628 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210831-01 RECID=22 STAMP=1081997052 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210831-02 RECID=23 STAMP=1081997951 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0q07uikl_1_1 RECID=24 STAMP=1082083989 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210901-00 RECID=25 STAMP=1082083991 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0s07ujal_1_1 RECID=26 STAMP=1082084693 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210901-01 RECID=27 STAMP=1082084759 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/0u08ggfl_1_1 RECID=28 STAMP=1082671605 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210907-00 RECID=29 STAMP=1082671607 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/1008gis0_1_1 RECID=30 STAMP=1082674049 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210907-01 RECID=31 STAMP=1082674104 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/1208j2hb_1_1 RECID=32 STAMP=1082755628 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210908-00 RECID=33 STAMP=1082755629 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/1408j583_1_1 RECID=34 STAMP=1082758403 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210908-01 RECID=35 STAMP=1082758405 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210908-02 RECID=36 STAMP=1082759210 Crosschecked 36 objects
Delete Expired Backups
RMAN> delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 EXPIRED DISK /u01/app/oracle/product/19.0.0/dbhome_1/dbs/0106mhr1_1_1
2 2 1 1 EXPIRED DISK /u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210816-00
3 3 1 1 EXPIRED DISK /u01/app/oracle/product/19.0.0/dbhome_1/dbs/0306mo87_1_1
4 4 1 1 EXPIRED DISK /u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210817-00
5 5 1 1 EXPIRED DISK /u01/app/oracle/product/19.0.0/dbhome_1/dbs/050797sg_1_1
6 6 1 1 EXPIRED DISK /u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210824-00
7 7 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/070798lh_1_1
8 8 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-01
9 9 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/090798lu_1_1
10 10 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-02
11 11 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/0b07bnao_1_1
12 12 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-03
13 13 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/0d07bnbi_1_1
14 14 1 1 EXPIRED DISK /u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-04
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0106mhr1_1_1 RECID=1 STAMP=1080772449
deleted backup piece
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210816-00 RECID=2 STAMP=1080772496
deleted backup piece
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0306mo87_1_1 RECID=3 STAMP=1080779015
deleted backup piece
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210817-00 RECID=4 STAMP=1080779016
deleted backup piece
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/050797sg_1_1 RECID=5 STAMP=1081384849
deleted backup piece
backup piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-2378581000-20210824-00 RECID=6 STAMP=1081384850
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/070798lh_1_1 RECID=7 STAMP=1081385650
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-01 RECID=8 STAMP=1081385651
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/090798lu_1_1 RECID=9 STAMP=1081385662
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-02 RECID=10 STAMP=1081385719
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0b07bnao_1_1 RECID=11 STAMP=1081466201
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-03 RECID=12 STAMP=1081466202
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0d07bnbi_1_1 RECID=13 STAMP=1081466226
deleted backup piece
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210824-04 RECID=14 STAMP=1081466242
Deleted 14 EXPIRED objects
RMAN> crosscheck backup;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0f07e69t_1_1 RECID=15 STAMP=1081547069
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210825-00 RECID=16 STAMP=1081547125
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0h07e6de_1_1 RECID=17 STAMP=1081547183
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210825-01 RECID=18 STAMP=1081547198
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210830-00 RECID=19 STAMP=1081978741
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0m07rmdf_1_1 RECID=20 STAMP=1081989551
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210831-00 RECID=21 STAMP=1081989628
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210831-01 RECID=22 STAMP=1081997052
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210831-02 RECID=23 STAMP=1081997951
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0q07uikl_1_1 RECID=24 STAMP=1082083989
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210901-00 RECID=25 STAMP=1082083991
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0s07ujal_1_1 RECID=26 STAMP=1082084693
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210901-01 RECID=27 STAMP=1082084759
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/0u08ggfl_1_1 RECID=28 STAMP=1082671605
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210907-00 RECID=29 STAMP=1082671607
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/1008gis0_1_1 RECID=30 STAMP=1082674049
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210907-01 RECID=31 STAMP=1082674104
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/1208j2hb_1_1 RECID=32 STAMP=1082755628
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210908-00 RECID=33 STAMP=1082755629
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/1408j583_1_1 RECID=34 STAMP=1082758403
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210908-01 RECID=35 STAMP=1082758405
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/oradata/TEST/backup/c-2378581000-20210908-02 RECID=36 STAMP=1082759210
Crosschecked 22 objects
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8
One thought on “CROSSCHECK BACKUPS Using RMAN”