Log minor [message #348839] |
Thu, 18 September 2008 01:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
SELECT distinct member LOGFILENAME FROM V$LOGFILE;
LOGFILENAME
________________________
/home/oracle/oracle/product/oradata/ora10g/redo01.log
/home/oracle/oracle/product/oradata/ora10g/redo02.log
/home/oracle/oracle/product/oradata/ora10g/redo03.log
BEGIN
DBMS_LOGMNR.ADD_LOGFILE
('/home/oracle/oracle/product/oradata/ora10g/redo01.log');
DBMS_LOGMNR.ADD_LOGFILE
('/home/oracle/oracle/product/oradata/ora10g/redo02.log');
DBMS_LOGMNR.ADD_LOGFILE
('/home/oracle/oracle/product/oradata/ora10g/redo03.log');
END;
ORA-01284: file /home/oracle/oracle/product/oradata/ora10g/redo01.log cannot be opened
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '/home/oracle/oracle/product/oradata/ora10g/redo01.log'
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 2
I searched for the solution but the solution says to
Action: Restore the correct log file. But wont work.
How could i resolve the error?
|
|
|
Re: Log minor [message #348855 is a reply to message #348839] |
Thu, 18 September 2008 02:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Post status of the log files.
ORA-00339: archived log does not contain any redo
*Cause: The archived log is not the correct log. It is a copy of a log file
that has never been used for redo generation, or was an online
log being prepared to be the current log.
*Action: Restore the correct log file.
Regards
Michel
|
|
|