Solved

Move logical volumes to new EVA and bring up Oracle db's

Posted on 2007-04-09
8
324 Views
Last Modified: 2013-12-23
We are getting a new EVA.  I am wondering if I can move the logical volumes and then bring my data bases, which are Oracle10g back up on the new EVA.  Need to put together a process and risk assessment of how to move all my data to new EVA, db servers remain the same.

I can see the file systems now.  And can read/write to what has been presented.  Trying to find a fast and low risk way of moving all the data as the old EVA will not be available after the cut over.

Thanks
0
Comment
Question by:mjimison1956
  • 3
  • 3
  • 2
8 Comments
 
LVL 16

Accepted Solution

by:
MohanKNair earned 250 total points
Comment Utility
For moving datafiles from one volume or "mount point" to another, it is better to rename datafiles and then using OS commands move the datafiles to destination.

The steps are

1) First table the tablespace offline
SQL> alter tablespace app_data offline;

2) Rename datafiles
SQL> alter tablespace app_date rename datafile '/u01/oracle/U1/data01.dbf ' TO '/u02/oracle/U1/data04.dbf ' ;

3) Using OS commands move datafiles

4) Bring tablespace online
SQL> alter tablespace app_data online;
0
 
LVL 55

Assisted Solution

by:andyalder
andyalder earned 250 total points
Comment Utility
For "moving" the data I would use Continuous Access EVA to replicate from the old to new and keep it in sync, then you can test using the new EVA without having to copy the entire data across multiple times. There's a trial version of Replication Solutions Manager on HP's web you can use. Obviously once replicated you would have to take a snapshot or clone to do any live testing with. Whoever provides your new EVA can help with this.
0
 

Author Comment

by:mjimison1956
Comment Utility
MohanKNair,

If I copy the data files, build a new oracle home on the new eva with same sid and bring the db up, how could I then synchronize the data during the maintenance window?  Would I have to bring db up as a different sid or would that screw up the redo and archive log application to synch the data?

Is there a way to use two task in this scenario?
0
 

Author Comment

by:mjimison1956
Comment Utility
andyalder,

we are checking to see what has to be done to install this.  One issue is we have multiple lunds and want to cut the number down to three large.  Does this require a restart of the EVA?
0
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.

 
LVL 16

Expert Comment

by:MohanKNair
Comment Utility
Another option is to use emp/imp using transportable tablespace option. This will enable to synchronize data tablespace wise.
0
 

Author Comment

by:mjimison1956
Comment Utility
Our current production is not set up as transportable tablespace .. would this be a requirement or how would I engineer it.
0
 
LVL 16

Expert Comment

by:MohanKNair
Comment Utility
transporting a tablespace only requires the copying of datafiles and integrating the tablespace structural information
Transportable Tablespace
http://www.oracle.com/technology/deploy/availability/htdocs/xtts.htm

http://www.oracle-base.com/articles/9i/TransportableTablespaces9i.php
0
 
LVL 55

Expert Comment

by:andyalder
Comment Utility
It's probably what HP's RSM leverages where it says it now has Oracle tablespace support.
0

Featured Post

Google Storage: Standard vs. Nearline vs. Coldline

Google Cloud Storage has a number of classes to choose from. Although there are a lot in common, they vary in price and usage terms. This post explains Google Cloud Storage classes and helps to understand which  one to choose.

Join & Write a Comment

Suggested Solutions

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Don’t let your business fall victim to the coming apocalypse – use our Survival Guide for the Fax Apocalypse to identify the risks and signs of zombie fax activities at your business.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

13 Experts available now in Live!

Get 1:1 Help Now