Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I MOVE a database?
This is a good case in point for me. I use database cloning all the time,
maybe too much! If your moving a database and not trying to create a second
copy, it's easy. Yet I would have cloned it. Well, now I feel like a
beginner again. Thank you for reminding me, there's always the way Oracle
says to do it.
Rob Medley wrote in message <369E57B8.75D26510_at_iafrica.com>...
>How to move a database :
>
>1. Shutdown normal
>2. Move your database files and/or redo log files and/or control files
using
>whatever O/S commands you like.
>3. If you moved the control files, then edit your configuration file to
reflect the
>new locations.
>4. In Server Manager, mount, but don't open your database : ie. startup
mount
>5. In Server Manager, rename each file that you moved with the alter
database
>command : ie Alter database rename file 'oldname' to 'newname'; (the
ENTIRE path
>must be used)
>6.In Server Manager, open your database : ie. Alter database open;
>
>thats all there is to it.
>
>Rob Medley
>medleyrk_at_iafrica.com
>
Received on Thu Jan 14 1999 - 22:54:29 CST