Hi Big
Planet,
They
db files are not consistence you can apply the changes with 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
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
.
|