FBDA: ORA-00600: [ktfa_purge_history] MANUAL OR AUTOPURGE WITH SYS_FBA_FA PURGESCN = 0
(Doc ID 2531217.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Flashback Archive: FDA1,FDA2,FDA3
*********
The alert.log shows:
2018-12-31T08:22:44.747289-05:00
Restarting dead background process FBDA
Starting background process FBDA
2018-12-31T08:22:44.777622-05:00
FBDA started with pid=241, OS id=27232
PST06P(3):DDE: Problem Key 'ORA 600 [ktfa_auto_purge_fba: failure to get purge SCN]' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
2018-12-31T08:22:49.735122-05:00
PST06P(3):Slave archiving 1 large/PDB transactions
2018-12-31T08:23:06.819348-05:00
PST06P(3):Slave archiving 1 large/PDB transactions
MANUAL PURGE PROCESS
=======================
Each command raised the same ORA-600 [ktfa_auto_purge_fba: failure to get purge SCN]
ALTER FLASHBACK ARCHIVE FDA1 PURGE BEFORE SCN 12578841285640;
ALTER FLASHBACK ARCHIVE FDA2 PURGE BEFORE SCN 12578841285640;
ALTER FLASHBACK FDA3 PURGE BEFORE SCN 12578841285640;
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |