LogMinerHelp
DB enviroment: Oracle Standard 11.1.0.6
OS: SUN
ISSUE: User inserted invalid data.
LOGMINER: Currently not setup
Can we turn logmining on and then go back several days in an attempt to find all the inserts update and deletes from may 19 00:00 through may 21:19:30 and reverse them. There could be just a few and could be hundreds of thousands of DDL changes made.
Also what is the overhead for starting logminer, diskspace, memory, log resizing
So can we setup log minning and then go to past logs and mine for DDL statements
Oscar