| log miner [message #361467] |
Wed, 26 November 2008 09:35  |
allahmorad
Messages: 18
Registered: June 2006
|
Junior Member |
|
|
Hi,
if i can not speak english ,sorry.
I run following commands
but when i run last select staement ,only return:
SQL_REDO -------------------------------------------
create table mytbl2 (c1 number,c2 varchar2(10)); 1 rows selected
but i want return information about insert and update.
whey dont show that information?
thanks
allahmorad
connect scott/tiger;
create table mytbl2 (c1 number,c2 varchar2(10));
insert into mytbl2 values (10,'dah');
insert into mytbl2 values(20,'bist');
insert into mytbl2 values(30,'si');
insert into mytbl2 values(40,'chel');
insert into mytbl2 values(50,'panjah');
commit;
select * from mytbl2;
update mytbl2 set c2='test' where c1=20;
commit;
connect / as sysdba
execute dbms_logmnr.add_logfile('D:\log\O1_MF_1_3_4LTN2K1G_.ARC', dbms_logmnr.new);
execute dbms_logmnr.add_logfile('D:\log\O1_MF_1_4_4LTOBJNJ_.ARC', dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('D:\log\O1_MF_1_5_4LTOPO89_.ARC', dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('D:\log\O1_MF_1_6_4LTOPQ4W_.ARC', dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('D:\log\O1_MF_1_7_4LTOPXWB_.ARC', dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('D:\log\O1_MF_1_8_4LTOPZ1Y_.ARC', dbms_logmnr.addfile);
select * from v$logmnr_logs;
EXECUTE DBMS_LOGMNR.start_logmnr ( options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG );
SELECT sql_redo FROM v$logmnr_contents where sql_redo like '%mytbl2%';
|
|
|
|
|
|
| Re: log miner [message #361857 is a reply to message #361482] |
Fri, 28 November 2008 04:59  |
allahmorad
Messages: 18
Registered: June 2006
|
Junior Member |
|
|
Hi Michel Cadot,
thank , for your help.
but after insert & update commands
i run following commanf for 3 or 4 time.
alter system switch logfile
an i have only 3 online redo logfile,
i think after run this commands.
online redo logfile save as archive logfile.
if that is right. why dont show any information
about insert and update?
best regards
allahmorad.
|
|
|
|
|
|
| Re: log miner [message #361971 is a reply to message #361867] |
Fri, 28 November 2008 23:40 |
allahmorad
Messages: 18
Registered: June 2006
|
Junior Member |
|
|
Hi ,
I add The online redo log.
but no change in result.
SQL_REDO
-----------------------------------------
create table mytbl2 (c1 number,c2 varchar2(10));
I think my problem is in
DBMS_LOGMNR.start_logmnr parameters.
But I am not sure.
|
|
|
|
|
|
| Re: log miner [message #361978 is a reply to message #361975] |
Sat, 29 November 2008 00:47 |
allahmorad
Messages: 18
Registered: June 2006
|
Junior Member |
|
|
Hi,
add all groups REDO01.LOG ,REDO02.LOG,REDO03.LOG
and add a new row in result ,
but no abbout insert and update in mytbl2.
SQL_REDO
-----------------------------------------
create table mytbl2 (c1 number,c2 varchar2 10));
insert into "SYS"."WRH$_SQLTEXT"("SNAP_ID","DBID","SQL_ID","SQL_TEXT","COMMAND_TYPE","REF_COUNT")
values ('54','2049544261','d7h6frrgg6c8y',
'SELECT sql_redo FROM v$logmnr_contents where sql_redo like '%mytbl2%'','3','0');
Regards
Allahmorad
[Updated on: Sat, 29 November 2008 01:40] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
