The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Special Forums > Filesystems, Disks and Memory
Google UNIX.COM


Filesystems, Disks and Memory Questions involving NAS, SAN, RAID, Robotic Libraries, backups, etc go here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How To Encrypt Data in Oracle Using PHP (from The Oracle+PHP Cookbook) iBot Oracle Updates (RSS) 0 04-06-2008 02:10 AM
Howto capture data from rs232port andpull data into oracle database-9i automatically boss UNIX for Dummies Questions & Answers 1 09-22-2007 11:35 PM
Storage Solutions: Oracle and Symantec Certify Veritas Data - Data Storage Connection iBot UNIX and Linux RSS News 0 07-19-2007 09:40 PM
Oracle and Symantec Certify Veritas Data Center Solutions on Oracle - WebWire (press iBot UNIX and Linux RSS News 0 07-17-2007 05:30 AM
Jobs scheduled in crontabs are not running after a migration to oracle 9i alexcol UNIX for Advanced & Expert Users 4 03-27-2007 07:35 PM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-13-2008
Registered User
 

Join Date: Mar 2008
Posts: 3
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 03-13-2008
...@...
 

Join Date: Feb 2004
Location: NM
Posts: 3,289
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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.
Reply With Quote
  #3 (permalink)  
Old 03-13-2008
Registered User
 

Join Date: Mar 2008
Posts: 3
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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?
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes


The 50 most popular UNIX and Linux searches.
Google Search Cloud for The UNIX and Linux Forums
"inappropriate ioctl for device" 421 service not available, remote server has closed connection ^m automate ftp autosys awk trim bash eval bash for loop boot: cannot open kernel/sparcv9/unix command copy/move folder in unix curses.h cut command in unix find grep find mtime find null character in a unix file grep multiple lines grep or grep recursive gzip password hp-ux ifconfig inaddr_any inappropriate ioctl for device lynx javascript mailx attachment mget mtime perl array length ping port remove first character from string in k shell replace space by comma , perl script scp recursive segmentation fault(coredump) sftp script snoop unix stale nfs file handle syn_sent tar exclude tar extract to folder test: argument expected unix unix .profile unix forum unix forums unix internals unix interview questions unix mtime unix simulator unix.com vi substitute while loop within while loop shell script


All times are GMT -7. The time now is 02:24 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101