> 
> Dear Ari,
> 
> I have small doubt in Oracle Recovery.
> 
> What will happen if I apply archived redo log files to data files twice 
> at the same time during database recovery. Will there be any problem of 
> data duplication ?
> 
> Please send me the answer at your earlist.
> 
> Thanks and Regards,
> 
> Prashant 
> 

There will be NO problem of duplication with archived redo logs. Oracle keeps
track of which redo logs have been applied already. If you try to re-apply the
same log file, Oracle will just skip through it.

You will need to be careful if you import twice, with IGNORE=Y. Oracle will load
data in every time you issue such an import.


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 150+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page o Ari Kaplan's Home Page