Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ora8 NT problem
In article <3505FCB7.534B_at_p3.net>, Jerry Gitomer <jgitomer_at_p3.net> wrote:
>Hi Billy,
>
>
>
>Billy Verreynne wrote:
>
> In response to Joel Garry
>
> SNIP
>
>> The question basically is - if you loose your control file in a crash and
>> you have to recover the database on a different drive without a controlfile,
>> what is the recovery sequence?
>
>Copy over one of the other two control files which you of course had on
>different spindles <g>.
>
>By the way Billy I suggest a variation of your T1, T2, C1, C2, ...
>naming convention --
>use T as the prefix for columns and C as the prefix for tables <bg>.
And then use M for Index and G for constraints, then your db will have all the reliability and documentation of an MG-TC! Classic development!
>
>
>Regards
>
>Jerry
>
>--
>Jerry Gitomer Since I know how to spell DBA I became one.
>jgitomer_at_p3.net
-- These opinions are my own and not necessarily those of Information Quest jgarry@eiq.com http://www.informationquest.com http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA!Received on Wed Mar 11 1998 - 00:00:00 CST