RE: one datafile lost.
Hi Big Planet, They db files are not consistence you can apply the changeswith archived redo log since. How you recover your database is depend on how you backup your database. For example you can use old "redundancy set" + latest exported dump file Sinardy -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: 17 January 2003 01:29To: Multiple recipients of list ORACLE-LSubject: one datafile lost. Just wondering what will happen in this condition . supposse I have two tablespaces data_large and data_small . with datafiles data_large01.dbf and data_small01.dbf . some transactions affects tables in both tablespaces . Now one day I lost data_small01.dbf data files . I thought of recovering that data file from one day old backup . when I recover this data data file , will oracle maintain transactio consistency for all transaction happened today . becuase data_large01.dbf is up to date . but data_small01.dbf is one day old . will oracle keep this in mind while applying archived logs at the time of recovery .
RE: one datafile lost.
absolutely. -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: one datafile lost. Just wondering what will happen in this condition . supposse I have two tablespaces data_large and data_small . with datafiles data_large01.dbf and data_small01.dbf . some transactions affects tables in both tablespaces . Now one day I lost data_small01.dbf data files . I thought of recovering that data file from one day old backup . when I recover this data data file , will oracle maintain transactio consistency for all transaction happened today . becuase data_large01.dbf is up to date . but data_small01.dbf is one day old . will oracle keep this in mind while applying archived logs at the time of recovery .
