RECOVERING/RESTORING/RECREATING DATAFILE

RECOVERING/RESTORING/RECREATING DATAFILE

 

  

Hi all,

If I lost a datafile, for example, deleted/removed by mistake and I do
not have a backup of it. Can I restore the datafile if I do not have all
the archived logs from when the datafile was first created? Or am
totally messed up and need to get a litre of coffee with a 1000
words-per-minute keystroke and 100% accuracy to input all those records
... :-)

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


Oracle LazyDBA home page