RE: Best option for moving database of server

How do you normally back up your databases? Use this as an opportunity to make sure you can restore a backup.

1. Install the Oracle Software on the new machine. Same patch level as the source.
2. Backup the source database using whatever you normally use for backups (hot, cold, RMan, manual file copies?)
3. Restore the backup to the new machine. If the disk arrangement is different on the new machine, you will have to tell Oracle where the files are located. The method to do that varies with the type of backup you are restoring.
4. If you need to change the name and/or database id of the restored database, use the DBNewID utility (see the utilities manual).

It sounds like you have never tested your backup strategy and this would be a very good chance to do it.

If you haven't tried RMan, it is a very nice tool. You can use an RMan backup as the source to duplicate the database with a new name and database ID. It's easy to change file locations if your disk setup is different.

Sarah

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Oliver Sent: Thursday, May 03, 2012 4:26 AM
To: oracle-l
Subject: Best option for moving database of server

Hi,
I have to move a oracle database 10g (10.2.0.5.0) to another server, what
would you recommend me that is the best option for doing it? Cloning database?
Architecture will be the same in the source and target server, different distribution of Linux, but with same architecture (x86-64). I had thought install oracle 10.2.0.1 (I think that there isn't 10.2.0.5 full install), I will have to install 10.2.0.5 patchset and then cloning database :-?
I know transport tablespaces too ... and export/import. What would be the
best option? Database is not large/great, and it isn't a important database, it can be stopped, although I don't want a large downtime. Thanks beforehand.
P.D.: If you prefer cloning database, some manual about it?

Cheers...

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 03 2012 - 09:18:06 CDT