I'm a student studying oracle 10g backup/recovery strategies and I was
hoping someone could tell me the steps in restoring/recovering a lost
datafile in archivelog mode without a backup.

Thanks.

OklahomaDave wrote:
And I am an instructor that teaches the course so I'll give you
the same advice I'd give one of my students.

http://tahiti.oracle.com

Choose 10gR1 or 2 documentation.

It is a wealth of information on this and many other topics.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

OklahomaDave wrote:
Without a backup? This is akin to creating something from nothing. You
can issue the following:

ALTER DATABASE CREATE DATAFILE '/directory/filename';

But the contents will be empty.

Since you are a student, I would highly recommend reading the Oracle
documentation on this subject.

Cheers,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

OklahomaDave schreef:

No backup? You have no backup?
No recovery, then (or do you mean you have *all*
archived redo logs since the datafile was created
still lingering somehwere?)