Moving one terabyte oracle database

Posted on 2006-03-24
Last Modified: 2009-12-16
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.

Question by:gyans
    LVL 34

    Accepted Solution

    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.
    LVL 1

    Author Comment

    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 .

    LVL 34

    Expert Comment

    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.
    LVL 5

    Expert Comment


     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...



    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now