Home » RDBMS Server » Security » Error at adding logfile in logminer process (Oracle 9i.2, Windows. )
Error at adding logfile in logminer process [message #472465] Fri, 20 August 2010 15:15 Go to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi,

1):
In logminer logfile analyzing, I had added all the online redo log files in the below procedure:
EXECUTE dbms_logmnr.add_logfile(.....
Options => dbms_logmnr.addfile).

Then
2):
I mentioned 3 days at the STARTTIME & ENDTIME in the procedure of LOGMNR.START_LOGMNR(...)

But it shows the below error msg:
Ora-01291: missing logfile.

Thanks in advance.
Re: Error at adding logfile in logminer process [message #472466 is a reply to message #472465] Fri, 20 August 2010 15:30 Go to previous messageGo to next message
Michel Cadot
Messages: 66644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01291: missing logfile
 *Cause:  Not all logfiles corresponding to the time or scn range specified
          have been added to the list.
 *Action: Check the v$logmnr_logs view to determine the missing scn
          range, and add the relevant logfiles.

You should learn:
1/ to read Database Error Messages
2/ to post the whole SQL*Plus session and not just explain what (you think) you did

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Error at adding logfile in logminer process [message #472471 is a reply to message #472466] Fri, 20 August 2010 16:45 Go to previous message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi

Thanks a lot.
Previous Topic: Login Attempts Exceed Maximum
Next Topic: Modify profile to Use the old password
Goto Forum:
  


Current Time: Sun Oct 20 11:19:42 CDT 2019