RMAN Crosscheck Backup and Delete Expired Backup


> rman target /
 
Recovery Manager: Release 11.1.0.6.0 - Production on Thu Jun 2 14:06:15 2014
 
Copyright (c) 1982, 2007, Oracle. All rights reserved.
 
connected to target database: ANARDB (DBID=1270013502)
 
RMAN> crosscheck backup;
 
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=108 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/ora1024/stage/Database01mb9q77_1_1 RECID=1 STAMP=750053608
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/ora1024/stage/Database02mb9q7h_1_1 RECID=2 STAMP=750053619
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/ora1024/stage/Database03mb9q98_1_1 RECID=3 STAMP=750053674
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/ora1024/stage/Database04mb9q9c_1_1 RECID=4 STAMP=750053676
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/ora1024/stage/Control05mb9qa0_1_1 RECID=5 STAMP=750053697
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora1024/product/11.1.0/db_1/dbs/16mc1k3a_1_1 RECID=35 STAMP=750833775
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/ora1024/product/11.1.0/db_1/dbs/17mc1ka7_1_1 RECID=36 STAMP=750833996
Crosschecked 7 objects
 
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 /home/ora1024/stage/Database01mb9q77_1_1
2 2 1 1 EXPIRED DISK /home/ora1024/stage/Database02mb9q7h_1_1
3 3 1 1 EXPIRED DISK /home/ora1024/stage/Database03mb9q98_1_1
4 4 1 1 EXPIRED DISK /home/ora1024/stage/Database04mb9q9c_1_1
5 5 1 1 EXPIRED DISK /home/ora1024/stage/Control05mb9qa0_1_1
 
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/home/ora1024/stage/Database01mb9q77_1_1 RECID=1 STAMP=750053608
deleted backup piece
backup piece handle=/home/ora1024/stage/Database02mb9q7h_1_1 RECID=2 STAMP=750053619
deleted backup piece
backup piece handle=/home/ora1024/stage/Database03mb9q98_1_1 RECID=3 STAMP=750053674
deleted backup piece
backup piece handle=/home/ora1024/stage/Database04mb9q9c_1_1 RECID=4 STAMP=750053676
deleted backup piece
backup piece handle=/home/ora1024/stage/Control05mb9qa0_1_1 RECID=5 STAMP=750053697
Deleted 5 EXPIRED objects
Advertisements

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: