Home » RDBMS Server » Server Administration » Log minor (oracle 10.2.0.1)
Log minor [message #348839] Thu, 18 September 2008 01:40 Go to next message
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
Michel Cadot
Messages: 64103
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
Previous Topic: ASM Diskgroup State
Next Topic: Updating database to 10.2.0.3
Goto Forum:
  


Current Time: Sat Dec 03 16:08:40 CST 2016

Total time taken to generate the page: 0.12831 seconds