Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question of dbms_logmnr

Question of dbms_logmnr

From: Lee <gnt00011_at_partner1.nri.co.jp>
Date: Fri, 12 Sep 2003 17:16:41 +0900
Message-ID: <3F6180E9.AE3BB1CD@partner1.nri.co.jp>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US