Question - FLASHBACK_DATA_ARCHIVES - checking on purge?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Mon, 19 Sep 2022 14:38:48 -0400
Message-ID: <CAP79kiQchhKAWCDfo7zt+sY9EF_MJWYKQwZOo91CdaUQ9EBX7A_at_mail.gmail.com>

So I've just started at a new company and they're using FLASHBACK_DATA_ARCHIVING (which is kind of cool)

DB Ver: 12.1.0.2

It appears that our purging is setup to run every 4 days.

[image: image.png]
Problem is, the "CREATE_SCN" is null and the "LAST_PURGE_SCN" doesn't compute when using SCN_TO_TIMESTAMP function:

[image: image.png]

select scn_to_timestamp(243229273761) from dual /
ORA-08181: specified number is not a valid system change number ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1

If I look at DBA_SEGMENTS and DBA_OBJECTS for segments in the FDA_TS (Flashback Data Archive tablespace) , I see create dates going back to 2019.

And of course we're getting application problems because the FDA_TS filled up and then the quota had to be adjusted.

I'm trying to _understand_ this setup and how purging works and if I should only see objects with create dates of 4 days ago inside the flashback data archive tablespace or what?

The documentation on this technology leaves a lot to be desired.

Anyone use Flashback Data Archives and let me pick your brain a bit?

Thanks,
Chris

--
http://www.freelists.org/webpage/oracle-l





image/png attachment: image.png



image/png attachment: image.png

Received on Mon Sep 19 2022 - 20:38:48 CEST