To all the Gurus out there
I'm quite new with Oracle....I've read some articles on how we can dig into the redo log files to seek all updates
that have been made to tables in the database.
Log Miner come into the pictures. Can anyone tell me
1) how to manipulate this features (e.g installation, requirements and steps needs to be consider).
2) If I'm not mistaken there are certain scripts needs to be installed, where can I get the scripts
* I'm using oracle 8.1.5, running on AIX 4.3.3
Thanks in advanced
Yours Truly
Ezree
http://www.experts-exchange.com/jsp/qList.jsp?ta=oracle
Now you might post a 0-point question with a link to your question to attract oracle experts to your question!
Now, i'm not (yet) a guru in Oracle.
I know however that you can query the v$logmnr_contents dynamic view, which can show the undo and redo sql.
Before that, you must however create the dictionary file (by using a parameter in the init file:_
utl_file_dir=d:\Oracle\Ora
and then create the following package:
@d:\oracle\Ora81\rdbms\adm
Execute the build procedure
EXEC DBMS_LOGMNR_D.build ('logmnrd.ora', 'c:\oracle\oradata\PROD')
create the following package:
@d:\oracle\Ora81\rdbms\adm
Now you can add the log files to analyse:
EXEC DBMS_LOGMNR.ADD_LOGFILE 'c:\...\redo01.log', dmbs_logmnr.NEW);
EXEC DBMS_LOGMNR.ADD_LOGFILE 'c:\...\redo02.log', dmbs_logmnr.ADDFILE);
EXEC DBMS_LOGMNR.ADD_LOGFILE 'c:\...\redo03.log', dmbs_logmnr.ADDFILE);
...
Finally (filename same as above (build), the starttime and endtime parameters are optional:
EXEC DBMS_LOGMNR.START_LOGMNR ('c:\oracle\oradata\PROD\l
CHeers