From: Browett, Darren (dbrowett@coquitlam.ca)
Date: Thu Apr 22 2004 - 14:42:12 EDT
Thank you to the following for responding :
Thomas Sjolshagen
Dr Thomas.Blinn
Jim Fitzmaurice
Alan Rollow - Dr. File System's Home for Wayward Inodes.
Martin Rønde Andersen
Jenny Butler
Bob Harris
Geoff Paul
In summary, it is very straight forward,
1. add a new volume
2. remove the old volume
ADVFS will handle the move, no migrate is necessary.
Everybody that responded with this solution has had great success.
A couple of comments :
1. Make sure you have a backup before you start :)
2. Will create a large amount of disk activity, therefore you should not do it during peak hours.
3. One person responded to do a balance in the middle. My thoughts on this is it would be one of checking the
new drive before I do the rmvol.
4. One person had concerns (and experiences) with file locks, they recommended shutting the database down and do the addvol/rmvol steps.
5. And lastly make sure none of my files are greater then 16Tb.
Again thank you for your responses.
Darren
-----Original Message-----
From: Browett, Darren
Sent: Thursday, April 22, 2004 10:01 AM
To: Tru64-Unix-Managers
Subject: Moving Oracle Datafiles around using ADVFS migrate.
Hi managers,
The system is a 2 node 5.1b cluster, connected to an HSG80.
Before I go down the migration path, I would like to get some feedback
on moving an oracle database to a different raidset.
Not sure at this time if I have all the steps, but
gennerally they would be as follows
1. Add raidset to existing domain.
2. migrate all files from existing raidset to the new raidset.
3. remove old raidset from the domain.
Now the questions :
1. Can this be done while the database is up and running ?
2. Is this a good way of doing it, or should I simply create a new
domain, add the raidset, shutdown the database
and copy the database files to the new raidset. ?
There are two databases on the existing raidset, with some of the
datafiles as large as 2Gb.
Thank you
Darren
------------------------------------------------------------------------
-----------
Darren Browett P.Eng This
message was transmitted
Data Administrator using
100% recycled electrons
Information and Communication Technology
City of Coquitlam
P:(604)927 - 3614
E:dbrowett@coquitlam.ca
------------------------------------------------------------------------
-----------
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:57 EDT