Welcome!

Big Data Consultant

Ranko Mosic

Subscribe to Ranko Mosic: eMailAlertsEmail Alerts
Get Ranko Mosic via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Ranko Mosic

Amazon recently added Oracle database hosting capabilities to its RDS service offering. You can rent an Oracle database related infrastructure in a pay-as-you-go fashion now. We are going to explore if corporations should be utilizing Amazon AWS Oracle Database related services (EC2, RDS ), how it should be used, where possible savings and potential trouble points are. With services like Amazon AWS it doesn't matter where your hardware and software physically is - it could be in a room next to you or in some other country. It is much easier and cheaper to procure and get new servers up and running. What's Really New? You swipe your credit card and get an Oracle database server up and running in half an hour. Sounds like magic, especially if you compare it to the weeks and months it normally takes to have an Oracle database server operational in an average enterprise ... (more)

Oracle Database Backups to the Amazon Cloud

The traditional way of performing backups includes using Oracle RMAN in combination with media management layer software ( typically Netbackup, Tivoli or similar ), which writes backup data to remote robotic tape unit. Tapes are then stored offsite to a secure location. It is well known fact that tape media poses certain challenges in reliability and physical manipulation areas. Cloud-based backups' main attraction is that they are inherently disk based, always accessible, offsite and there are no capex expenditures. All tape related costs are thus eliminated. On the other hand ... (more)

Oracle Disaster Recovery Site Hosted by Amazon Cloud

DR sites are typically built as an exact replica of the primary site. Application and database software is installed on DR site and sits there mostly unused, waiting for a disaster to happen. DR site is very expensive proposition than only large companies are able to afford. Amazon AWS is an interesting alternative to having your own DR site. Oracle databases on the DR side are in Data Guard configuration with a primary site and actively apply archive log files shipped from there. Pay per use, scalable Amazon Cloud model makes it an attractive alternative to creating and maintai... (more)

Importance of Having DR Procedures

A recent BlackBerry outage is the nightmare for both RIM and its users. Nature and mass popularity of Blackberry service  make this particular outage highly visible. There are many other in-house outages we never hear about. Companies prefer to keep silent about them, if they can. The only insight we get into the poor state of DR procedures is in some public cases like this one, or from limited personal experience. In my Oracle database infrastructure consulting career I have seen several serious production outages and was part of a few data recovery efforts. Backups and DR proc... (more)

AWS Announced New Scaling and Availability Features for Oracle Databases

Oracle database is offering a rich set of HA options in a non-Amazon world - active/passive clusters based on operating system failover capabilities (for example, IBM HACMP), active/active instances -  Oracle RAC (Real Application Clusters), Oracle Data Guard (physical and logical standby databases located in remote data center). Amazon Web Services RDS (Relational Database Service)  is already offering multi-AZ deployments for MySQL, soon to be released for Oracle databases too. Multi-AZ deployment means that a simple click will suffice to create an Oracle physical standby data... (more)