ORA-19588: archived log recid 181834 stamp 780173554 is no longer valid

来源:互联网 发布:java 字符串查找 编辑:程序博客网 时间:2024/06/10 18:47

https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=6449148

Bug 6449148: RMAN BACKUP WITH COMPRESSION FAILS ORA-19588

 

PROBLEM:
--------

Customer is attempting to backup archivelogs with the compression mode and it fails with:

RMAN-8038: channel dev4: starting piece 1 at 25-SEP-07
RMAN-8044: channel dev4: finished piece 1 at 25-SEP-07
RMAN-8530: piece handle=/oracle/ora1020/dbs/3qispnei_1_1
tag=TAG20070925T015635 comment=NONE
RMAN-8540: channel dev4: backup set complete, elapsed time: 00:00:25
RMAN-8049: channel dev4: starting compressed archive log backupset
RMAN-8014: channel dev4: specifying archive log(s) in backup set
RMAN-8504: input archive log thread=1 sequence=14946 recid=29148
stamp=633990007
RMAN-8031: released channel: dev1
RMAN-8031: released channel: dev2
RMAN-8031: released channel: dev3
RMAN-8031: released channel: dev4
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of backup command on dev4 channel at 09/25/2007 01:59:09
ORA-19588: archived log recid 29150 stamp 633990307 is no longer valid

DIAGNOSTIC ANALYSIS:
--------------------
- If they do not use compression the backup runs fine.
- The error is reproducable at will as it occurs every night.
- RMAN debug has been generated: Uploaded ( file: RMAN_trace.log)
- RMAN script is available: Uploaded ( file: rman_script.txt)
- RMAN Configuration : Uploaded (file: show_all.txt
- RMAN Truss will be avilable next week.

WORKAROUND:
-----------
No Compression. However they need compression due to high volume