Question of dbms_logmnr

Hello,

i want to use dbms_logmnr to register redo log. command [dbms_logmnr.add_logfile(logfilename=>'/usr2/log/aa.dbf');] is sucessfully accessed.
but if i use parameter to change ['/usr2/log/aa.arch'], it can not accessed sucessfully.
my sql script is bb.sql

DECLARE CURSOR io_cur IS select name from v$archived_log; io_rec char(50);
BEGIN
OPEN io_cur;
FETCH io_cur INTO io_rec;
DBMS_OUTPUT.PUT_LINE(io_rec);
dbms_logmnr.add_logfile(logfilename=>io_rec); close io_cur;
END;
/

error message is

sqlplus -s ' / as sysdba' @bb.sql
/usr2/log/aa.arch

DECLARE CURSOR io_cur IS select name from v$archived_log; *
ORA-01284: can not open file /usr2/log/aa.arch

ORA-00308: can not open archive log /usr2/log/aa.arch

ORA-27037:can not get status of file
IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3
ORA-06512: "SYS.DBMS_LOGMNR", 行63 ORA-06512: 行8 mode of file /usr2/log/aa.arch is 777

Thanks
Lee Received on Fri Sep 12 2003 - 03:16:41 CDT