自带的,不用下载select value from v$parameter where name = 'log_archive_dest';SELECT member FROM v$logfile where rownum = 1;begin SYS.DBMS_LOGMNR.ADD_LOGFILE('...../o1.log', sys.dbms_logmnr.New); end;begin sys.dbms_logmnr.add_logfile(....._1_407.arc', dbms_logmnr.addfile); end; select min(low_time), max(high_time), min(low_scn), max(next_scn) -1 from V$logmnr_logs;begin SYS.DBMS_LOGMNR.START_LOGMNR(Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG); end;Select SCN, timestamp, sql_redo, session# session_num, username, session_info From V$LOGMNR_CONTENTS Order by 1; begin SYS.DBMS_LOGMNR.END_LOGMNR(); end;
SYS.DBMS_LOGMNR.ADD_LOGFILE('...../o1.log', sys.dbms_logmnr.New);
end;begin
sys.dbms_logmnr.add_logfile(....._1_407.arc', dbms_logmnr.addfile);
end;
select min(low_time), max(high_time),
min(low_scn), max(next_scn) -1
from V$logmnr_logs;begin
SYS.DBMS_LOGMNR.START_LOGMNR(Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
end;Select
SCN,
timestamp,
sql_redo,
session# session_num,
username,
session_info
From V$LOGMNR_CONTENTS
Order by 1;
begin
SYS.DBMS_LOGMNR.END_LOGMNR();
end;
是日志文件还没有加够么?????
用sys用户在pl/sql中,
call dbms_logmnr.start_logmnr(dictionary=>'/home/ora/logdictionary/sqlhistory.ora')
这种命令应该怎么写???
当执行到这一步的时候,如果不指定时间,那么正常
一旦要指定时间,就会提示如下错误
ORA-01291: missing logfile但是redo01.log~redo03.log全都添加了???????????????????
那么查询出的日志只有当天的,历史的完全没有
但是字段中的clob字段开始sql语句就什么都没有了,
这样的话,sql语句就只有一半,
效果如下,假如col3是clob字段,那么语句就为如下:insert into col1,col2,col3,col4 values ('a','b',
这样就没办法恢复
谁有没有办法解决 ???????
col col3 format a5000;