OraFAQ Forum: Security » Error at adding logfile in logminer process

Home » RDBMS Server » Security » Error at adding logfile in logminer process (Oracle 9i.2, Windows. )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error at adding logfile in logminer process [message #472465]

Fri, 20 August 2010 15:15

muktha_22
Messages: 527
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.

Report message to a moderator

Re: Error at adding logfile in logminer process [message #472466 is a reply to message #472465]

Fri, 20 August 2010 15:30

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Error at adding logfile in logminer process [message #472471 is a reply to message #472466]

Fri, 20 August 2010 16:45

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi

Thanks a lot.

Report message to a moderator

Previous Topic:	Login Attempts Exceed Maximum
Next Topic:	Modify profile to Use the old password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 16:25:49 CDT 2024