There are many blog posts out there about active database duplication. However, they were all tested in an ideal environment or condition. What happens when a tablespace is created during the middle of active duplication and how to resolve the error? Read on if you would like to know.
For my test case, I created database db01 using OMF and will perform active duplication to db02 using OMF as well on the same host. While duplication was running, I created a new tablespace. Here are the details of the steps performed:
Today I’ll be discussing Integrity Check on SQL Server – we have some very good info in the community, but I’d like to summarize my thoughts here. When a DBA talks about Integrity Check, the conversation is usually redirected to one subject: CheckDB. And yes, we are going to talk about it in today’s post. :)
I was working on my presentations for IOUG Collaborate, and I came upon this strange behaviour in RMAN 12c (220.127.116.11.0) which to me, shouldn’t happen. Seems that when you do a DROP PLUGGABLE DATABASE , it is the equivalent of DROP DATABASE INCLUDING BACKUPS. This means that if you need to restore your PDB later on, you won’t have this registered – just be careful when dropping them.
Here we go: So I took a backup of my CDB and all of its PDBs, and kept an eye on this TAG 20140212T191237 (I removed a couple of lines for better reading)
There are multiple paths a database can use to answer a query, some of them being faster and more efficient than others. It is the job of the query optimizer to evaluate and choose the best path, or execution plan, for a given query. Using the available indexes may not always be the most efficient plan. For example, if 95% of the values for a column are the same, an index scan will probably be more efficient than using the index on that column.
On this Valentine’s Day, what is the most romantic thing you could do as database professional? Why, yes — you could read (and then share) this scintillating and lovely Log Buffer Edition!
Oracle is kicking off a 17-city North American event series on how running Oracle Applications on Oracle hardware can help customers deliver maximum value and achieve dramatically better business results.
Yeah, well… Evidence is strongly against me so far. :)
Today we’re having a quick one.
Earlier during the day, I had to peruse an Oozie log for the first time. And it looked like:
Here are the Top 5 things in Oracle E-Business Suite world that will have major impact in 2014 and beyond.
1. Oracle E-Business Suite 12.2 Now Available
Sometimes, you idly think about a problem, and an answer comes to you. And it has the simplicity and the elegance of a shodo brush-stroke. It is so exquisitely perfect, you have to wonder… Have you reached the next level of enlightenment, or did the part of your brain responsible for discernment suddenly called it quits?
I’ll let you be judge of it.