Re: Student backup and recovery question

OklahomaDave wrote:
> 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.
>

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.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