执行备份时遇到ORA-19588

最新推荐文章于 2021-04-04 02:33:19 发布

cuanmo8775

最新推荐文章于 2021-04-04 02:33:19 发布

阅读量817

点赞数

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:

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

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

显示相关信息 相关的