Re: Moving Oracle 8i DB from /abc to /def

It shouldn't be too hard. Follow these instructions.....

1. Sign on to the database and issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE. This will create a dump of your controlfile's contents.
2. Shutdown the database with NORMAL or IMMEDIATE.
3. Copy the datafiles to the location(s) you want them to be.
4. Make sure that you have ORATAB and everything else you need to be able to start this "new" database with a new ORACLE_SID. This includes making sure that you have the right INIT.ORA for this new database (complete with new DB_NAME parameter.
5. Modify the controlfile dump made in step one with the new directories and the new ORACLE_SID.
6. Run the script above to create the new controlfile with the new ORACLE_SID and new datafile locations.

This was just off the top of my head and may require some tweaking...

Cheers,
Brian

"Steve N." wrote:
>
> Hi All,
>
> I have an Oracle 8.1.6 (Enterprise Ed.) database that has a UNIX
> datafile-based configuration. Its laid out in a directory structure
> that starts with /live. I want to take a copy of that database and
> place it in /save. We are not using RMAN.
>
> At present, we know of two ways to do this:
>
> 1) Export all the data, then import it into another database.
>
> 2) Use exp with TRANSPORT_TABLESPACE, copy all the files into the new
> directory, then imp the metadata.
>
> Both of these are very time consuming. I was wondering if there was a
> way to shutdown the database, simply copy all the data files to the
> new directory, then somehow tell the control file to find the data
> files in the new directory instead of where they were previously.
>
> Does anyone know how this might be done? I've had to recover from a
> lost controlfile before so I know we can recreate that using trace
> files, so I was thinking it may be possible to alter the file paths so
> that it finds the new files in the new location in the process...
>
> Thanks in advance for any ideas...
>
> Regards,
>
> SteveN.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"