Manage

How to get history of modified data from Oracle databases

An Oracle user asks how to get the history of data modified from an Oracle database.

Brian Peasland

Published: 14 May 2008

How can you get the history of data modified from an Oracle database?

There are a few options at your disposal. After the fact, you can mine your archived redo logs using Oracle's Log Miner utility. This presumes you have the archived redo logs available. For more information on how to use Log Miner, refer to the following documentation:

Using LogMiner to Analyze Redo Log Files

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Before the fact, you can set up auditing to record changes. With auditing, you can record actions in a database table as they happen and then query the table any time in the future. For more information on auditing, please refer to the following documentation:

Database Auditing: Security Considerations

Oracle RMAN (Oracle Recovery Manager)

How to tune Oracle instance recovery

Mirroring in Oracle RAC and Data Guard

Understanding rollback in Oracle following SHUTDOWN IMMEDIATE

Please create a username to comment.

Top 7 data catalog use cases for enterprises

Metamorphosis of Kafka Confluent event streaming technologies

Isima emerges with bi(OS) converged data platform

Maine state government modernizes with Oracle Analytics

TigerGraph adds cloud support, helps standardize graph coding

Looker, Google unveil first collaboration since acquisition

SAP S/4HANA Cloud interest increasing

Penn State graduates from legacy ERP to SAP S/4HANA

ASUG/DSAG members like S/4HANA, but implementations still lag

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Reduced cost, responsive apps from micro front-end architecture

How Quarkus fits into the Red Hat Runtimes formula

3 ways a volunteer programmer can help in a pandemic

Big Blue ties its IBM Z Series tighter to hybrid clouds

A mechanical refrigeration system primer for admins

Red Hat Enterprise Linux 8.3 beta released

Consider these electronic signature best practices

What the CCPA means for content security

Microsoft Lists app replaces some SharePoint functionality

4 ways HR and IT can collaborate on employee experience

Digital adoption platforms can improve employee experience

The HR software buying team: Roles, responsibilities, tips

Dig Deeper on Oracle database administration

Oracle RMAN (Oracle Recovery Manager)

How to tune Oracle instance recovery

Mirroring in Oracle RAC and Data Guard

Understanding rollback in Oracle following SHUTDOWN IMMEDIATE

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.