Oracle RMAN物理备份技术之管理维护

核心提示： 给出几个CORSSCHECK示例命令：CROSSCHECK BACKUP;# checks backup sets, proxy copies, and image copiesCROSSCHECK COPY OF DATABASE;CROSSCHECK BACKUPSET 1338, 1

给出几个CORSSCHECK示例命令：

CROSSCHECK BACKUP;　# checks backup sets, proxy copies, and image copies
CROSSCHECK COPY OF DATABASE;
CROSSCHECK BACKUPSET 1338, 1339, 1340;
CROSSCHECK BACKUPPIECE TAG = 'nightly_backup';
CROSSCHECK CONTROLFILECOPY '/tmp/control01.ctl';
CROSSCHECK DATAFILECOPY 113, 114, 115;
CROSSCHECK PROXY 789;

交叉验证指定数据库文件的备份

# these CROSSCHECK commands use configured channels, which means that they
# always check the disk device. If you configured an sbt channel, then RMAN
# checks the sbt device, too
CROSSCHECK BACKUP OF DATAFILE "ora_home/oradata/trgt/system01.dbf"
　COMPLETED AFTER 'SYSDATE-180';
CROSSCHECK BACKUP OF ARCHIVELOG ALL SPFILE;

删除备份

删除指定的备份：

1、 先用LIST命令找到备份唯一标识。

LIST BACKUP OF DATABASE ARCHIVELOG ALL; # lists backups of db files and logs
LIST COPY; # lists only image copies
LIST BACKUP; # lists everything

2、 删除指定的备份存储库记录和备份文件。

DELETE BACKUPPIECE 101;
DELETE CONTROLFILECOPY '/tmp/control01.ctl';
DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 300;

批量删除：

DELETE BACKUP; # deletes all backups on disk and tape
DELETE BACKUP OF TABLESPACE users DEVICE TYPE sbt; # delete only from tape
DELETE COPY OF CONTROLFILE LIKE '/tmp/%';　# LIKE specifies name of the copy
DELETE NOPROMPT ARCHIVELOG ALL
BACKED UP 3 TIMES TO sbt; # backs up only if already backed up 3X to tape