Oracle 10G RAC Cross-Instance Archivelog delete steps

当RAC的归档日志是交叉归档在各个节点的本地磁盘,此时在单独一个节点上删除RAC的归档日志,另外一个节点上的日志不会被删除.
RMAN>run{
allocate channel c1 device type disk format '/u02/backup/%U' connect sys/manager@rac1;
allocate channel c2 device type disk format '/u02/backup/%U' connect sys/manager@rac2;
delete noprompt archivelog all;或者delete archivelog until time 'sysdate-5';
}
保证两个节点上的归档日志全部删除.

 

RMAN> connect target *
2> run
3> {
4> BACKUP DATABASE TAG Full_bk;
5> sql 'alter system archive log current';
6> RESTORE DATABASE VALIDATE;
7> CROSSCHECK BACKUP OF DATABASE;
8> REPORT OBSOLETE;
9> DELETE NOPROMPT OBSOLETE;
10> }
11> LIST BACKUP SUMMARY;
12> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-8';