Press Summary
EMC RecoverPoint Behavior under Heavy Load
July 23rd, 2010
Written by Centroid
I'm sure this is well-known and documented behavior to RecoverPoint appliance experts, but we recently found what we think to be a very nice feature in EMC's RecoverPoint behavior that perhaps some folks new to the technology are unaware of ...
Today we did a large (1Tb) backup of an assortment of Oracle database files on HP-UX file-systems to a set of ASM disk groups. The ASM disk groups were the source LUNs in a RecoverPoint remote replication consistency group. Our RMAN backup to ASM disk...
Cloning Oracle Databases with EMC SnapView and RecoverPoint
July 8th, 2010
Written by Centroid
Many are familiar with the steps required to clone Oracle database using "rman duplicate" or "hot backup" cloning . Many are also familiar with steps required to create EMC SnapView Clones or SnapView Snapshots, either with the Navisphere web interface or CLI. In this post, I'll outline steps required to build consistent, usable Oracle database "clones" within the framework of the following environment/architecture:
Oracle 11.1.0.7, HP-UX 11iV2
EMC CLARiiON CX4 storage arrays at production...
Large SGA on 32-bit Redhat Linux
June 10th, 2010
Written by Centroid
Many DBAs are familiar with the SGA size limitations on 32-bit platforms. This post shows how to allocate a 3Gb buffer cache on 32-bit RHAS 3.
Step 1: Mount /dev/shm to as type ramfs. Edit /etc/fstab and add an entry like this:
none /dev/shm ramfs defaults,size=4G 0 0
Step 2: do a "mount -a" to mount /dev/shm. I use ramfs instead of tmpfs because it doesn't use swap; tmpfs does. With ramfs memory allocation will also grow dynamically, whereas when...
Using DBMS_SQLDIAG
March 3rd, 2010
Written by Centroid
As a DBA, have you ever had an issue you suspected may be a bug and have been asked to generate "test data" for Oracle development? We ran into this at a client recently and found a cool 11g utility (at least I *think* it's new :)) to get Oracle Support the data they need to reproduce the issue in-house.
The situation had to do with optimizer_features_enable being set to 11.1.0.7 in a database recently upgraded form 9.2.0.5 in an Oracle eBusiness Suite environment (11.5.10.2) that utilized...
Connecting an Oracle Database with a DB2 Database
January 30th, 2010
Written by Centroid
On a recent project we had a business and technology reason to connect Oracle EBS running 11g to a DB2 database. After a few weeks of researching for the best practice and approach we decided on the following implementation steps.
Download a DB2 driver, such as from DataTek, and download to your application server in any storage directory.
Create a directory called "YM" under your custom application top. example: $CUSTOM_TOP/java/YM. (Assumes you have already created a $CUSTOM_TOP and it...
