Logminer digging through archivelogs?

[nisha]

Hi All,
How do i know or find which archivelogs is needed for, to capture the changes being made by user(past in time) so as to dig through logminer,do i have to dig through all archivelogs? its 10g.Please any suggestions would be appericated.

Thanks in advance.

[davey23uk]

well if you know when the change was done you can work out which log it may be in

[nisha]

Suppose the cjanhge has been made couple of days back ,then what query should i use for it?

[tamilselvan]

select * from v$log_history ;

will show you the time stamp of each redo log started.