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

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

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