Oracle9i Enterprise Edition Release 188.8.131.52.0 - Production
PL/SQL Release 184.108.40.206.0 - Production
CORE 220.127.116.11.0 Production
TNS for 32-bit Windows: Version 18.104.22.168.0 - Production
NLSRTL Version 22.214.171.124.0 - Production
SQL> EXECUTE SYS.DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>'REDO01.L OG',OPTIONS=>sys.
BEGIN SYS.DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>'REDO01.L OG',OPTIONS=>sys.DBMS_LO
ERROR at line 1:
ORA-01284: file REDO01.LOG cannot be opened
ORA-00308: cannot open archived log 'REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) O5M3UR2;5=V86(5DND<~!#
ORA-06512: at "SYS.DBMS_LOGMNR", line 63
ORA-06512: at line 1
I don't know why. Must I shutdow the database and startup in mount state to execute the DBMS_LOGMNR.ADD_LOGFILE procedure?
My database is in NOARCHIVELOG mode.
This is because the system cannot access a required archived redo log file. This might be due to Non-existence of off-line log or the storage device mayn't be online or the archived file is not in the correct location.
When you restart the Server, it restarts the recovery session. So the Problem is solved.