RE: Question - FLASHBACK_DATA_ARCHIVES - checking on purge?

Try

alter flashback archive FDA purge before timestamp (SYSTIMESTAMP - INTERVAL '4' DAY);

And then run you test again let see it computes From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Chris Taylor Sent: Monday, September 19, 2022 2:39 PM To: oracle-l_at_freelists.org
Subject: Question - FLASHBACK_DATA_ARCHIVES - checking on purge?

***This email is from an external source. Only open links and attachments from a Trusted Sender.*** 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.

[cid:image001.png_at_01D8CC37.8CC61910] Problem is, the "CREATE_SCN" is null and the "LAST_PURGE_SCN" doesn't compute when using SCN_TO_TIMESTAMP function:

[cid:image002.png_at_01D8CC37.8CC61910]

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

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

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




image/png attachment: image001.png



image/png attachment: image002.png