Re: Track and maintain data changes for analysis and back tracking

Thank you all for the suggestions, will try to explore FBA and will keep the bugs in mind Chris figured it out.

Many Thanks
Nilesh

On Wed, Nov 2, 2022 at 8:02 PM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> Let me tell you, if you use FBA (Flashback Data Archive - formerly known
> as Total Recall) be very careful to set it up correctly.
>
> We've got an issue on 19.14 after upgrading from 12.1 where transactions
> are missing from FDA but show up in the trigger tracking tables.
>
> Quite a few bugs related to FBA in 19c (since 18c)
>
>
> On Wed, Nov 2, 2022 at 7:58 AM Frank Gordon <frankagordon_at_gmail.com>
> wrote:
>
>> Would Flashback data archive help here at all I wonder?
>> https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/flashback.html
>>
>> On Wed, Nov 2, 2022 at 3:11 AM Al B. <albert.y.balbekov_at_gmail.com> wrote:
>>
>>> If it is to track commands executed (and not the data that commands have
>>> changed), then one option is carefully configured db audit. Then
>>> application will be able to display data from unified audit table. This
>>> will give who, what and when.
>>>
>>> If it is for data changes, then within a reasonable time window
>>> supported by UNDO_RETENTION, the app can use AS OF TIMESTAMP or one of
>>> flashback transaction queries. This will give what,when,and who (in terms
>>> of db username) along with TXID. The UNDO retention can be expanded with
>>> Undo Data Archive option.
>>>
>>> In general change management is big topic and can easily balloon into a
>>> tool of its own. You can potentially look at Enterprise Manager Lifecycle
>>> Management Pack if you already have EM.
>>>
>>> These days developers are using some form of Devops CICD platform for
>>> change management, and it feels natural for them to expand the platform
>>> into database world. This brings in tools such as Flyway or Liquibase, or
>>> more self-contained Flexagon Flexdeploy.
>>>
>>> Best,
>>> Albert Balbekov
>>>
>>> On Mon, Oct 31, 2022 at 11:25 PM nilesh kumar <nileshkum_at_gmail.com>
>>> wrote:
>>>
>>>> Dear All,
>>>>
>>>> Good Morning!
>>>>
>>>> We have a special requirement from one of the application folks.
>>>> 1. They would like to track the database changes, who did what changes
>>>> and when in the database via the application interface.
>>>> 2. They would like to document the individual steps that were executed
>>>> for the data changes, its main purpose is for analysis and back tracking.
>>>>
>>>> I had suggested a change management approach which would have a
>>>> separated database and any changes in the database will be tracked via the
>>>> change ticket, but the solution does not seem to be feasible to application
>>>> owners.
>>>>
>>>> Actually they are building a new system and process in place.
>>>>
>>>> Any suggestions on this would be a great help.
>>>> --
>>>> Thanks & Regards
>>>> Nilesh
>>>> Oracle DBA (sqlplus "/as sysdba" is my world)
>>>>
>>>> "As our circle of knowledge expands, so does the circumference of
>>>> darkness surrounding it."--Einstein
>>>> "All men die, few men ever truly live" -- Braveheart
>>>> "You can get help from teachers, but you are going to have to learn a
>>>> lot by yourself, sitting alone in a room." --Dr. Seuss
>>>> "Know me for what I do and for not what I am. Judge me for what I can
>>>> do and not for what I have done."-Unknown
>>>> "Don't walk in front of me, I may not follow. Don't walk behind me, I
>>>> may not lead. Just walk beside me and be my friend."- Albert Camus
>>>> "Never argue with an idiot. They drag you down to their level and then
>>>> beat you with experience." - Unknown
>>>>
>>>
>>
>> --
>> +353-86-0695383
>>
>

-- 
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)

"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown

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