Solved

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

Posted on 2007-04-09
8
338 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
ID: 18876675
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
ID: 18881702
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
ID: 18882609
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:mjimison1956
ID: 18882618
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
 
LVL 16

Expert Comment

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

Author Comment

by:mjimison1956
ID: 18884473
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
ID: 18884557
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
ID: 18884608
It's probably what HP's RSM leverages where it says it now has Oracle tablespace support.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
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…

685 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