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

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
>

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