My Oracle Support Banner

FBDA: ORA-00600: [ktfa_purge_history] MANUAL OR AUTOPURGE WITH SYS_FBA_FA PURGESCN = 0 (Doc ID 2531217.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.