Moving Oracle Datafiles around using ADVFS migrate.

From: Browett, Darren <dbrowett_at_coquitlam.ca>
Date: Thu, 22 Apr 2004 10:00:35 -0700

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_at_coquitlam.ca
------------------------------------------------------------------------
-----------
Received on Thu Apr 22 2004 - 17:01:22 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:44 NZDT