查看過期備份
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Control File Copy
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
RMAN>
report obsolete命令刪除過期備份
RMAN> delete obsolete;
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Backup Set
Backup Piece
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/backup/database/arch_ATYU
deleted backup piece
backup piece handle=/backup/database/arch_ATYU
deleted backup piece
backup piece handle=/backup/database/dbfull_ATYU
RMAN> list copy;
using target database control file instead of recovery catalog
List of Archived Log Copies
Key Thrd Seq S Low Time Name
RMAN>
同步控制文件的信息和實際物理文件的信息
RMAN>
RMAN> crosscheck archivelog all;
allocated channel: ORA_DISK_
channel ORA_DISK_
validation succeeded for archived log
archive log filename=/opt/oracle/flash_recovery_area/ATYU
Crosschecked
RMAN>
From:http://tw.wingwit.com/Article/program/Oracle/201311/16974.html