Moving one terabyte oracle database

Hi ,

We have a large 1 terabyte database on Unix.
I have to move it toa different unix server , what are my options .

We have hot backups runnning and export of different tables.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
Oracle version?

OS and version of both machines?

Here are some options.

Assuming same OS and Oracle versions on both sides, one option is a standby database.  You can restore your hot backup on the new machine, and create a standby control file on the current primary machine.  You will then need every archive file created since the backup and have to apply them to the standby.  Considering this should be a temporary situation, this apply can be manual (although it is not too difficult to set it up for automatic but if I remember correctly requires a shutdown on the primary which may not be an option).  You can keep applying archives until the time to switch, they you shut down the primary, apply the last of the archives (including the online redo log) and activate the standby.

Another option which will work just as well, is to not create the standby.  Just restore the hot backup and every day apply archives using RECOVER DATABASE UNTIL CANCEL.  Then when the switch happens, apply the remaining archives and online redo with RECOVER DATABASE and then the database will be up to date and you can open it.

I have used both of these methods very successfully moving databases.  The standby gives you a means to open it (read only of course) and check things, but in these type of temporary situations, it is usually not necessary.

Both of these methods minimize down time for the actual switch over.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gyansAuthor Commented:
Thank you, that was my approach any way ,I was looking for an alternative way ,because to restore from hot backups it might take a day or so , the copying over of datafiles is in two different data centers in different locations .

I was looking to minimize our worktime also .

johnsoneSenior Oracle DBACommented:
The only other alternative that I can come up with, which is usually not very feasable, is to use external storage, or move the actual array around.

You can use some sort of external storage, do the backup to that and then ship the external storage.

If this can be done by mirroring, it is very fast, but that is usually not possible outside the original array.

You would end up buying a terabyte of external storage just so you don't have to ship tapes around.  That usually does not fly with upper management.

 first create all the bdump acdump and necessary directories ,create the init file....

ddi u have cold backups....if so do a cold backup restore...and start the db...

or put all the hot backup filea with archive logs...and up the db...


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.