一、备份信息
1.1、列出备份信息
列出数据库中所有文件的备份信息:
RMAN>LIST BACKUP OF DATABASE;
列出指定表空间的备份信息:
RMAN>LIST BACKUP OF TABLESPACE SYSTEM;
列出指定数据文件的备份信息:
RMAN>LIST BACKUP OF DATAFILE 4;
列出归档日志的备份信息:
RMAN>LIST BACKUP OF ARCHIVELOG ALL;
1.2、删除备份信息
1.删除陈旧备份
当使用RMAN 执行备份操作时,RMAN 会根据备份冗余策略确定陈旧备份。
RMAN> delete obsolete;
2.删除EXPIRED 备份
执行crosscheck 命令核对备份集,如果备份集丢失或者损坏,那么会将该备份集标记为EXPIRED 状态。为了删除相应的备份记录,可以执行delete expired backup 命令。
RMAN> delete expired backup;
3.删除EXPIRED 副本
RMAN> delete expired copy;
4.删除特定备份集
RMAN> delete backupset 19;
5.删除特定备份片
RMAN> delete backuppiece '/home/backup/DEMO_19.bak';
6.删除所有备份集
RMAN> delete backup;
7.删除特定映像副本
RMAN> delete datafilecopy '/home/backup/DEMO_19.bak';
8.删除所有映像副本
RMAN> delete copy;
9.在备份后删除输入对象
RMAN> delete archivelog all deleteinput;
RMAN> delete backupset 22 format = '/home/backup/%u.bak' delete input;
二、指令运行方式
2.1、批处理
RMAN>run{
......
......
}