RMAN Backup Error ORA-19588: Archived Log Recid Stamp Is No Longer Valid [ID 1189883.1]
		修改时间 28-AUG-2010 类型 PROBLEM 状态 MODERATED

In this Document
Symptoms
Changes
Cause
Solution
References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

RMAN Backup of archived logs fails with following error:

channel dev_0: starting archive log backupset
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_0 channel at 08/27/2010 07:22:55
ORA-19588: archived log recid 1485 stamp 727949642 is no longer valid

Changes

The backup command is:

RMAN> backup archivelog all archivelog until time 'sysdate -1' delete input ;

Cause

The backup command being used is correct by 'syntax', however incorrect by 'logic' because RMAN will try to backup some archivelogs (archivelogs which completed till 'sysdate-1') twice in the same command:

This backup command is interpreted by RMAN like the following:

+ Take backup of 'all' archived logs and then delete them

and

+ Take backup of archivelogs completed till 'sysdate-1'

If we don't specify 'DELETE INPUT', the command will be succeeded, however, by doing so, we will unnecessarily backing up some of the archived logs (archivelogs which completed till 'sysdate-1') twice which doesn't seem to be the intention of above command.

Solution

Correct the RMAN backup comamnd 'logically' by removing the repeated 'archivelog' keyword:

RMAN> backup archivelog until time 'sysdate -1' delete input ;

If we wish to take backup of all archivelogs, then:

RMAN> backup archivelog all delete input ;

References

NOTE:368518.1 - Archived Log Recid 99760 Stamp 588792619 Is No Longer Valid Ora-19588
BUG:6449148 - RMAN BACKUP WITH COMPRESSION FAILS ORA-19588
RMAN-03009

相关的 产品 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition 错误 ORA-19588; RMAN-3009; RMAN-569; RMAN-571

[@more@]