Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: migration DB to new server on raw device

Re: migration DB to new server on raw device

From: Alex Gorbachev <>
Date: Thu, 12 Jul 2007 23:33:10 -0400
Message-ID: <>

I won't provide all details as a lot depends on what you want and what's available. Ask specific questions if you want more details.

Are you going to use the same storage?
If so than you just need to stop your database on one node, move raw devices over to another node making sure they are mapped to the same locations so that you don't need to rename the files. If you are using links for raw devices - re-create them.
You will need to install appropriate oracle software and copy init.ora and password files if any. Network configuration (change as appropriate).

Now if you are moving to the new storage than it's more hassle. The first option to consider right away it to move to filesystem - managing 800 raw devices is damn time consuming. Someone might suggest ASM as well - it would also simplify storage management. If you are moving to raw devices or FS than you can use "dd" over the network (via remsh or ssh). You might need to skip the first block depending on your OS version.

If you are using ASM/raw devices/FS - you can copy datafiles as images while source database is mounted and copy controlfile. Note that you will need to see your new storage on your source machine for that time. Than you can move that new storage to the new box and start database from there. You might want to dd redo logs or open it resetlogs. You might actually even do image copy online with RMAN and then recover database on target host.

Another option would be to take backup (any method you prefer) to some shared storage and restore from there.

The last option leads us to the best choice ever -- use your regular backup (you do have one, don't you?). That will also help you to validate recoverability of your current backup.


On 7/12/07, Arif Gulzar <> wrote:
> I have existing 2 DB 20gb, 400gb on raw devices, No of dbfiles/raw devices
> are aroudn 800. Not using RMAN, i want to migrate this DB on new servers on
> raw devices, what would be the road map, what would be best options to do
> this?Any notes/examples would be appreciate

Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
BAAG party -
Received on Thu Jul 12 2007 - 22:33:10 CDT

Original text of this message