Re: OFA on NT

Dick,

The problem is that you are re-arranging the location of the data files, redo logs and control files. There are two ways to move data files. The first only works for moving data files. You alter a tablespace offline using the alter tablespace statement. Then you move your data files for that tablespace to the desired location then you issue another alter tablespace statement renaming the datafiles from their old name to their new name.

The second method is to alter the database to backup the control file to a trace file. The syntax is alter database backup control file to trace; This will generate a create control file statement for you. You then edit the create control file statement with the new locations of your redo logs, data files and modify your init.ora file for the new location of your control files. Then you shutdown your database move every thing to where you documented it in the control file and run the create control file statement.

The first method is better for shifting around a single tablespace the second is better for moving or cloning whole databases.

Thanks
Mike Lacy

Dick Willis wrote:

> I am trying to re-arrange my ORACLE 7.3 files to emulate an OFA structure.
> When I have moved them around, the instance will not start on boot-up, and
> I have to run the Recovery program to get it started.
>
> Q1: What is required to tell the instance to start on boot-up?
> Q2: If the instance can not be started, but Recovery can start it, what is
> it doing ?
> Q3: If OFA is the recommended directory structure, why doesn't ORACLE
> install itself that way, at least as a default, instead of using a
> completely different file structure ?
Received on Sun Oct 12 1997 - 00:00:00 CDT