Home » RDBMS Server » Server Administration » First time mover of database (RDBMS 10.2.0.3, HPUX x64, SAN)
First time mover of database [message #481127] Sun, 31 October 2010 12:09 Go to next message
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 #481129 is a reply to message #481127] Sun, 31 October 2010 13:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you use the same disks then, assuming these are the disks on the previous server, mount them at the same place at the new server and just start the instance and database.

Regards
Michel
Re: First time mover of database [message #481245 is a reply to message #481129] Tue, 02 November 2010 02:57 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Rebuilding of Index (2 merged)
Next Topic: DB Moving
Goto Forum:
  


Current Time: Fri Nov 29 08:48:53 CST 2024