请教:关于rman备份中归档日志文件丢失造成备份错误的问题

显示全部楼层 · 2014-2-18 16:42:02

本地一个oracle901数据库,采用Rman的catalog模式备份,由于误删除了一些归档日志文件,所以rman备份数据库时报错,说无法找到某个日志文件。
于是我在rman中敲入命令：change archivelog all validate;
但是，该命令似乎没效果，备份时还是报无法找到日志文件的错误，请问这个问题如何解决？

千问 · 2014-2-18 16:42:02

运行crosscheck archivelog all;

然后backup database archivelog all delete input;即可.

千问 · 2014-2-18 16:42:02

请问:crosscheck archivelog all与change archivelog all validate有区别吗?

千问 · 2014-2-18 16:42:02

千问 · 2014-2-18 16:42:02

There has been a change of functionality between 8i and 9i.In 8.1.7, any archived logs that are not found were deleted from the catalog. In 9.0.1, the records are not deleted, but the status is updated from 'A' to 'X'
For Oracle 8 use:
RMAN> Change Archivelog All Validate;
For Oracle 8i use:
RMAN> Change Archivelog All Crosscheck;
For Oracle 9/10g use:
RMAN> crosscheck archivelog all ;

千问 · 2014-2-18 16:42:02

检查归档日志可用性

千问 · 2014-2-18 16:42:02

crosscheck backup;
delete expired backup;