I just started reading up on logminer and have a few questions.
1) is it possible to use logminer to retrieve data that's a few days old or do you first have
to initiate a log miner session
2) I am trying to find data by scn number (see below) and I am getting the folllowing
erorr. Can somebody layout the steps I need to do in order to get log miner to work.
FYI
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SUPPLEME
--------
YES
show parameter utl_file_dir
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
utl_file_dir string
/u01/app/oracle/admin/ifdtest3
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR( -
DICTFILENAME => '/tmp/dictionary.ora', -
STARTSCN => 146, -
ENDSCN => 146);
BEGIN DBMS_LOGMNR.START_LOGMNR( DICTFILENAME => '/backup/ifdtest3/dictionary.ora', STARTSCN => 146, ENDSCN => 146); END;
*
ERROR at line 1:
ORA-01292: no log file has been specified for the current LogMiner session
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 1
Once setup I am looking to find all updates for the above mentioned scn numbers.
Thanks in advance to all who answer