查询一下日志. 更改以下内容中的'C:\oracle\oradata\jhoracle\REDO01.LOG'为你实际的文件名. 注意一共是三个,依秩序进行. 'C:\oracle\oradata\jhoracle\REDO01.LOG' 'C:\oracle\oradata\jhoracle\REDO02.LOG' 'C:\oracle\oradata\jhoracle\REDO03.LOG' begin SYS.DBMS_LOGMNR.ADD_LOGFILE('C:\oracle\oradata\jhoracle\REDO01.LOG', sys.dbms_logmnr.New); 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 where sql_redo like '%update%' Order by 1; begin SYS.DBMS_LOGMNR.END_LOGMNR(); end;
select SPID,SAN,LINKID,REGISTRATION,MESSAGE,SENDERADDRESS,SERVICENUMBER,MOTIME,PARTNERID,SERVID,MOID from MsO_OPER where ISVALID='1'
更改以下内容中的'C:\oracle\oradata\jhoracle\REDO01.LOG'为你实际的文件名.
注意一共是三个,依秩序进行.
'C:\oracle\oradata\jhoracle\REDO01.LOG'
'C:\oracle\oradata\jhoracle\REDO02.LOG'
'C:\oracle\oradata\jhoracle\REDO03.LOG'
begin
SYS.DBMS_LOGMNR.ADD_LOGFILE('C:\oracle\oradata\jhoracle\REDO01.LOG', sys.dbms_logmnr.New);
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 where sql_redo like '%update%'
Order by 1;
begin
SYS.DBMS_LOGMNR.END_LOGMNR();
end;
select SPID,SAN,LINKID,REGISTRATION,MESSAGE,SENDERADDRESS,SERVICENUMBER,MOTIME,PARTNERID,SERVID,MOID from MsO_OPER where ISVALID='1'