RE: Multiple DBs on One RAC - Adding New Nodes and Different Storage

From: Patterson, Joel <jpatterson_at_entint.com>
Date: Thu, 2 Jan 2014 12:06:26 -0500
Message-ID: <C1117B1AA0340645894671E09A7891F71569177E84_at_EIHQEXVM2.ei.local>



Not sure if the 'app' is just software or also database data files.

The Compellent has its own architecture... (maybe you have a different one) that moves blocks around dynamically depending on an algorithm - unless you pin them ahead of time, (you can pin after, but they might not migrate back as per algorithm). The blocks move from tier 1 fast, through other tiers perhaps to like tier 3, slow cheap disks.

In the case of Database datafiles, the data that is accessed least will be migrated to the slow cheap disks... this has a big impact on Backups and say year end / month end reporting since both scenarios will access perhaps the majority of data off of the slow disks. The impact is noticeable.

Joel Patterson
Database Administrator
904 928-2790

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steve Harville Sent: Friday, December 27, 2013 3:54 PM
Cc: oracle-l mailing list
Subject: Re: Multiple DBs on One RAC - Adding New Nodes and Different Storage

If you plan to migrate the current databases from EMC to Compellent, the easiest way is to have both storage arrays represented as ASM disks, add the Compellent disks to the existing disk groups, then drop the EMC disks.

Steve Harville<https://apex.appshosting.com/pls/apex/f?p=1076:steveharville>

On Thu, Dec 26, 2013 at 3:51 PM, David Barbour <david.barbour1_at_gmail.com<mailto:david.barbour1_at_gmail.com>> wrote:  The VMAX lease is coming due and 'something' is going to change. Meanwhile, we've purchased Compellent and the dictate is the new application WILL be on Compellent.

--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916
www.entint.com<http://www.entint.com/>


[http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/>

[http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231> [http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg] <http://twitter.com/#!/entint> [http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg] <http://www.linkedin.com/company/18276?trk=tyah> [http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg] <http://www.youtube.com/user/ValueofIT>
This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1] -- http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 02 2014 - 18:06:26 CET

Original text of this message