Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving Database
I use the create controlfile command regularly to move databases between
UNIX systems with differing numbers/names of disks.
Basically: use the alter system backup controlfile to trace on the existing
system. Shut it down cleanly. Copy it to the new locations. Edit the trace
file that you generated with the create controlfile command in it to reflect
the new disk locations and run it. Simple and reliable.
Liz Reen <Liz_at_reading.news> wrote in message
news:MPG.12029aaaa3482d6a9896a1_at_news.supernews.com...
> In article <7mndft$cj7$1_at_ezekiel.eunet.ie>, feargal_costello_at_ward.ie
> says...
> > Hi,
> > Our company have an Oracle 7.3 database running on OpenVMS. They plan to
> > cluster the current machine. This will entail renaming the disks. How
can I
> > save my current instance and database
> > a. Recreate new database and import all from dump file
> > b. startup mount and rename files
> > c. another way ?
> >
> > Any suggestions, help, experience of same ????
> >
> > Feargal
> >
> >
> >
> >
> Did you use logicals when you created your database files?
> i.e. disk1:[dir]database.dbf (you will not see a change when the disks
> change)
> or did you hard code it?
> i.e. vax$dua1:[dir]database.dbf (you're in trouble)
>
>
> If you did the second approach take the opportunity to fix it now. I'm
> assuming that you are not the system manager. Get with the manager, find
> out the logical names and then put them in the output from alter database
> controlfile to trace. This way when the disks change again, you will not
> have a problem.
>
>
> Liz
> --
> My real address is L R E E N a t P E R R I E R G R O U P dot C O M
Received on Tue Aug 10 1999 - 11:03:48 CDT