Data Migration(Oracle)


 
Thread Tools Search this Thread
Special Forums Hardware Filesystems, Disks and Memory Data Migration(Oracle)
# 1  
Old 03-13-2008
Data Migration(Oracle)

Hello All,
I am part of a planning process to migrated 40+ Sparc(Solaris8) server from site 'A' to site 'B', these server house oracle databases. We will setup a staging environment in site B, then go thru a cutover process. Currently we are thinking of TARing the ORACLE datafiles, saving them USBdrive or tape, then overnighting from site A to site B. Network transfer is not an option at this point.

What does everyone think of this approach?

TIA,
Vada010
# 2  
Old 03-13-2008
You have bottlenecks:
writing to tape
restoring from tape

You may need to plan a production shutdown starting Friday at noon, and expect the new system up by 9 am Monday - if you have Sunday delivery. You have to migrate applications. You have to migrate users. You have to update TNSnames settings and file protections on the new boxes. You will have to update software on PC's to use the correct forms servers, etc.
Don't forget ftp/sftp/ssh processes and their keys, etc.

We just did this. We did a trial run, had problems, corrected them, did another trial run had a few problems, then did a real push. For each trial run we had to get users out of production Friday early on.

It is NOT just the Oracle dbf files you have to worry about.
# 3  
Old 03-13-2008
I am familiar with the process, but, I am looking for transport options.

For example:
1. COPY DATA FROM EMC SAN(BCV)
I. setup a LINUX system which is attached to the SAN.
II. Insert an ESTATA card
III. import filesystem
IV. COPY FS to external ESTATA drive.
V. SHIP esata drive to site B and restore

2. NAS appliance
I. purchases a portable NAS appliance
II. bring it online on network
III. mount on server
IV. copy files datafile or export dump
V. SHIP esata drive to site B and restore

Any other ideas are welcome? Or thought on these?
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Web Development

Oracle Jet - LP: 10. Lesson 1: Oracle JET 4.x - Lesson 1 - Part 4: Data Binding

Working on LP: 10. Lesson 1: Oracle JET 4.x - Lesson 1 - Part 4: Data Binding in this Oracle JET online course - Soar higher with Oracle JavaScript Extension Toolkit (JET), I have created this code for incidents.js I cannot get the load average data in this Oracle JET test to update the... (4 Replies)
Discussion started by: Neo
4 Replies

2. AIX

AIX - FC Switch migration, SAN Migration question!

I'm New to AIX / VIOS We're doing a FC switch cutover on an ibm device, connected via SAN. How do I tell if one path to my remote disk is lost? (aix lvm) How do I tell when my link is down on my HBA port? Appreciate your help, very much! (4 Replies)
Discussion started by: BG_JrAdmin
4 Replies

3. Shell Programming and Scripting

Oracle Data BackUp with Help Of Perl

Hi All I am able to connect my oracle database with Perl and able to execute the queries. There is one schema names master19 which contains 50 table. I want to take backup of each table in and store at a given directory location in Perl For example suppose if a table student is present in... (1 Reply)
Discussion started by: parthmittal2007
1 Replies

4. Solaris

Veritas Storage Question (Data Migration)

Using Solaris 10 with Veritas Storage Foundation running. I want to copy all contents from DISKA LUN1 to DISKB LUN2. What would be the command syntax to do this? (0 Replies)
Discussion started by: soupbone38
0 Replies

5. Shell Programming and Scripting

Get data from 3 differrnt oracle DB & then compare data

Hi All, I have a requirement to write a shell script for the following... we have 3 different database.... lets say A, B, C From these 3 DBs, i need to get data.. all have 3 different table...a,b, c A.a => Emp_code, count(*) B.b => emp_code, count(*) C.c => emp_code, copunt(*) Once get this... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies

6. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies

7. UNIX for Advanced & Expert Users

Jobs scheduled in crontabs are not running after a migration to oracle 9i

Good Morning. The problem started after tha migration to a newer version of oracle - migration to oracle 9i. Before the migration jobs that were scheduled in crontabs were running ok. but after the migration they are not running. I understand that is not easy to find out what the problem is.... (4 Replies)
Discussion started by: alexcol
4 Replies
Login or Register to Ask a Question