[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Moving one terabyte oracle database

Posted on 2006-03-24
Medium Priority
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
  • 2
LVL 35

Accepted Solution

johnsone earned 600 total points
ID: 16288173
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.

Author Comment

ID: 16296987
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 35

Expert Comment

ID: 16299566
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.

Expert Comment

ID: 16308105

 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

872 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