RE: Advice to get to OFA

If you are simply talking about renaming/reloacting datafiles then 53 is not a lot. I would create two scripts, one unix one sql to a) copy the files at unix level and b) rename the files in the database. shutdown the database - copy the files at unix level - startup mount - rename the datafiles in the database - shutdown normal - startup - if all is well delete the old unix files - take a full backup before and after of course and take a backup of the control file upon completion.

Phil West
Unix Sys Admin and Oracle Financials DBA +44 (0) 20 7623 5222 x5221

-----Original Message-----
From: Armstead, Michael A [mailto:maa25681_at_glaxowellcome.com] Sent: 03 August 2000 21:37
To: Multiple recipients of list ORACLE-L Subject: RE: Advice to get to OFA

I hate to say this, but I believe you have to manually create your OFA-compliant structure. The thread's silence on this topic makes my belief stronger.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo Wellcome

> -----Original Message-----
> From: Tamara Swilley [SMTP:tswilley_at_agency.com]
> Sent: Wednesday, August 02, 2000 8:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Advice to get to OFA
>
> Hi,
> I'm on an Oracle 8.0.5 database on a Sun E450 box (Unix)... our
> database is
> pertty small and it's a development database, not production.
> My question is: what is the easiest way to get to a standard OFA
> setup if
> it's not that way now? Is it easier to use a maint window and go down the
> rename all the datafiles path (there are 53 total) or is there a better,
> shorter, or simpler way?
>
> Thanks much,
>
> Tamara Swilley
> AGENCY.COM
> Avon, Colorado 81620
> tswilley_at_agency.com
>
>
> --
> Author: Tamara Swilley
> INET: tswilley_at_agency.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: Armstead, Michael A
  INET: maa25681_at_glaxowellcome.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


*******************************************************************************
The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.