oracle on EC2

From: max scalf <oracle.blog3_at_gmail.com>
Date: Mon, 11 Jan 2016 08:44:41 -0600
Message-ID: <CAKoJ+qDta--YOCFBq+R3BctyXQk3fWUNa8s8iwEhXtXeN=iL9A_at_mail.gmail.com>



Hello all,

This question is related to running oracle database on Amazon Web Service. Just so i respect everyone's time on here, I would say please ignore this question if you do not work with AWS.

We are running oracle some 11g and 12c database on AWS EC2 server. Most of the server have anywhere from 2 -8 EBS Volume attached(general purpose SSD), they are NOT striped or mirrored. Lately we have been seeing some performance issue(year end closing) with high IO wait time(60-80 ms per read), for some mission critical application we have moved the EBS volumes from general purpose SSD to Provisioned IOPS(PIOPS) and everything seems happy. But now we are coming back to some of the other application and our sysadmin says instead of moving everything from general purpose volumes to PIOPS we should just strip the volumes to get better performance.

I agree with him, but my question if we were to strip the EBS volumes how do we deal with taking EBS Snapshot and managing them. We rely on them for our DR in another region. From what i understand about taking snapshot when your EBS volumes are stripped is that you have to freeze the IO before you do the snapshot to guarantee EBS snapshot consistency, see below link..

https://aws.amazon.com/premiumsupport/knowledge-center/snapshot-ebs-raid-array/

So i wanted to see what others are doing in the community to achieve higher IOPS and i am sure quite a few ppl are running oracle on AWS and also I wanted to find out when they say "Freeze IO", I am assuming putting database in HOT BACKUP mode is the wrong thing.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 11 2016 - 15:44:41 CET

Original text of this message