| Log minor [message #348839] |
Thu, 18 September 2008 01:40  |
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  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
