How start LogMnr [message #70189] |
Fri, 26 April 2002 19:42 |
RachyKing
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
My Oracle8.1.6 is runing on Win2K Server,I want to start LogMiner as follow:
1.Create a dir e:oracleadminrachylogs as the initialization parameter UTL_FILE_DIR
2.Edit initrachy.ora and set the UTL_FILE_DIR=e:oracleadminrachylogs
3.Start instance and Open database
4.Create dictionary:
SQL>EXECUTE DBMS_LOGMNR_D.BUILD( DICTIONARY_FILENAME=>'dictionary.ora',DICTIONARY_LOCATION => 'E:oracleadminrachylogs');
5.Add archived log to analyze
SQL>EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => 'E:/oracle/oradata/rachy/archive/RACHYT001S01018.ARC', OPTIONS => dbms_logmnr.NEW);
6.Start LogMiner:
SQL>EXECUTE DBMS_LOGMNR.START_LOGMNR( DICTFILENAME =>' E:oracleadminrachylogsdictionary.ora');
Here I got a Error Messeage:
ORA_01843:invaild month
Tanks for any help!
|
|
|
|