Re: create controlfile (help needed)

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sat, 22 Feb 2003 05:30:48 -0600
Message-ID: <v5enr94qnkb22d@corp.supernews.com>

Look up the CREATE CONTROLFILE command.
Also 'ALTER DATABASE backup controlfile to trace.' Depending on what you all have, you may be able to pull this off. I suggest checking out the Backup and Recovery Guide.

Best of luck:

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Andy Kwok" <andy.kwok_at_noos.fr> wrote in message news:3e575722$0$10504$79c14f64_at_nan-newsreader-03.noos.net...
> Hello
>
> I'm facing a kind of huge problem .
>
> I'm trying to make a copy of my database (on SunOs 2.6 with oracle
7.3.4) )
> but with mssing datafile .
>
> I've the essential datafile (for the tablespace system, the tablespace for
> the rollback and last but not least the temporary tablespace ) and of
course
> the redo log files .
>
> But some of my datafile are missing .
>
> Do you know if it is possible to recreate control files ?
>
> I heard (read) through metalink that it 'seems' possible ...
>
> Any tips would be highly welcome ,
>
> Regards
> Andy
>
>
Received on Sat Feb 22 2003 - 05:30:48 CST