First time mover of database [message #481127] |
Sun, 31 October 2010 12:09 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
Are there any good information about on how to move a 10g database to a new server? We will keep the same disks on the SAN, but make a new installation on the new server.
Any feedback is appreciated.
Regards
H
|
|
|
|
Re: First time mover of database [message #481245 is a reply to message #481129] |
Tue, 02 November 2010 02:57 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
I know that on Windows, you have to run a command to create the services for the DB.
But Im not sure if they will move the disks from the server or use new disks. If they use new disk, I guess I have to create the database again, or how is it done on Linux?
If we use new disks, what are the steps? (the datafiles are stored on the SAN).
Regards
Hristo
|
|
|
Re: First time mover of database [message #481246 is a reply to message #481245] |
Tue, 02 November 2010 03:08 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote:I guess I have to create the database again
No you have not.
Quote:If we use new disks, what are the steps?
Copy the file to the new disks, change the control files location in init.ora, mount the database, use alter database to rename each file, open the database.
Regards
Michel
|
|
|