Re: moving database in the filesystem

I do this all the time on Digital Unix but I don't have the notes in front of me. Maybe this will help: To change the SID (after copying the admin directory and adjusting init and config) you have to change the controlfiles (follow directions for recreating the control file -- start with "alter database backup controlfile to trace" don't forget to change "REUSE" to "SET"). To move the datafiles you have to move the datafiles with your OS, then startup mount exclusive and internally rename the files saying "alter database datafile '/usr/....' to '/usr/...' ;" for each datafile. Trust to the documents, and practice on a test database!

Steven Egberghs <steven.egberghs_at_advalvas.be> wrote in article <34BC8682.D0492E89_at_advalvas.be>...
> F50
> AIX 4.2.1
> Oracle7.3
>
> I have a database in /database/prod
> and I want to move that database to eg. /database/prod_line_1
> Together with that I need to change the SID.
>
> What are my possibilities.
>
> Regards Steven.
>
> --
> \\\///
> ø ø
> -------------------------------------------
> There are three ways to get something done:
> 1. Do it yourself
> 2. Hire someone to do it for you
> 3. Forbid your kids to do it.
>
>
>
Received on Fri Jan 16 1998 - 00:00:00 CST