chandra_2000_us_at_yahoo.com (chan01) wrote in message news:<480cb9d4.0302221520.68461acc_at_posting.google.com>...
> I am planning to move the database from Sun storage to EMC Symm. Now
> we have our production database on Sun Storeage T3's and we are moving
> entire database
> (all tablespaces, redologs, control file ) on to EMC. I woule like to
> know
> what are the pre-cautions have to taken.
> Here is my hardware and software Configuration:
> Sunfire 3800 ( 8CPU's, 8GB RAM )
> Solaris 5.8 (08/02)
> Veritas VM, VFS, QuickIO for Oracle
> Oracle 8.1.6.0.0
> The database size is ~ 700 GB.
>
> I am planning to do:
>
> - Backup all the tables ( not indexes ) on to different tablespaces
> on T3 like
> sql> create table backup_xxxx as select * from xxx tablespace
> backup_tbs;
> - Then move the table to New tablespace.
>
> For the redo log and control files i am following the Concepts manual.
What's wrong with shutdown database, copy files, rename files, startup
database?
Or If you do not have access between old and new disk array, with
cold/hot backup to tape and restoring to new destination?
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Mon Feb 24 2003 - 02:58:19 CST
