Search

Top 60 Oracle Blogs

Recent comments

manual standby

What Happens When I Add Datafiles to a Manual Standby Primary in Standard Edition?

Introduction

One of the customers I’ve been working closely with over the past few months is running Standard Edition (SE) 12.1.0.1 (yes, I know they should upgrade but that’s coming further down the road). Recently, we moved their database to another, much larger ASM diskgroup (that’s the subject of another post that I haven’t written yet), so we now have the opportunity to add some more space to their existing tablespaces, which were mostly running close to full (as was the original diskgroup, for that matter). Now my experience of SE has not been particularly long, and I knew they were running a manual standby configuration like people used to use before Data Guard came around. Data Guard, of course, is an Enterprise Edition feature, so that’s not an option for this particular customer. I wondered what would happen to the standby when I added new datafiles.