A logical error happened in one Pluggable Database. A PDB Point-In-Time-Recovery rewinds it while the others remain available and stay as they are.
Logical error in PDB2
The blue arrow represents the Multitenant Database cdb1 with all its containers. A while back in the past, a logical error affected only pdb2. cdb1 is in Archive Log Mode and backups from before the logical error of at least the root container and pdb2 are available. What (more...)
Having spent the last two weeks at Oracle OpenWorld 2016, what’s the obvious thing to do within a couple of days of getting back? Go to Oracle Midlands to hear more about Oracle 12c Release 2 of course!
First up was Dominic Giles with “Oracle Database 12c Release 2: Whats new?… What’s improved?” I’ve been a big fan of SwingBench forever so the name Dominic Giles has been familiar to me for a (more...)
One of the most requested features in the compliance management area has been a compliance standard for Oracle Database 12c. As most of you would know, Oracle Database 12c has been out for quite some time, and indeed Larry Ellison has just announced at OOW2016 availability of Oracle Database 12cR2 in Oracle’s public cloud offering. However, as I discussed in another post earlier this year, creating a new STIG compliance standard is not a simple (more...)
That’s another Oracle OpenWorld (OOW) done, so it’s time to reflect on the event.
I think the most surprising thing for me was how much I enjoyed the User Experience (UX) and Internet of Things (IoT) stuff. I did the UX Strategy Day and the “Oracle Applications User Experience Cloud Exchange” afternoon and they were really fun and interesting. The IoT session took me back to my childhood, playing with wires and breadboards.
For years the (more...)
"Don't you know anything at all about numbers?"
"Well, I don't think they're very important," snapped Milo, too embarrassed to admit the truth.
"NOT IMPORTANT!" roared the Dodecahedron, turning red with fury. "Could you have tea for two without the two, or three blind mice
without the three? Would there be four corners of the earth if there weren't a four? And how would you sail the seven seas without
One of the little myths of Oracle appeared on the Oracle-L list server a few days ago – the one that says: “you don’t need a histogram on a single column unique/primary key”.
Not only can a histogram be helpful on a column that’s declared to hold unique values, the optimizer may even spot the need automatically. It’s a little unusual (and probably the result of poor programming practice) but it does happen. Here’s an (more...)
Does this question sound familiar? “We are running the exact same workload in UAT as we do in production, but it behaves completely different. Can you help?”
If it does, then you might find the following post useful, provided you are appropriately licensed to use this feature anyway. I have been working on AWR data for a long time, and one of the best ways to do so according to David Kurtz and others, (more...)
Last week, I attended the Oracle Open World and did a presentation about writing scripts with EMCLI. If you’re not familiar with EMCLI, it’s the command line interface for Oracle Enterprise Manager Cloud Control. Here’s my presentation:
Although EMCLI is a very specific topic which appeals only to advanced users, a lot of people attended my session. I would like to thank Ray Smith (IOUG Director (more...)
Today I started having a look to the Oracle Database Exadata Express Cloud Service announced last week at Oracle OpenWorld. Note that since the amount of resources provided (in summary, 1 OCPU, 20 or 50 GB of database storage) is very limited, in general, in my opinion that service will only be useful for functional tests. In fact, if it wasn’t because that is the very first 12.2 release (188.8.131.52.3 (more...)
I did my usual thing of not sleeping well before an early flight. I’m so nervous about waking up late and missing the flight I can’t sleep properly, which sets me up for a terrible day of travelling…
I was awake before my 04:45 alarm, so I had a shower and messed about on the computer until it was time to leave. I was sharing a car with Gustavo and Alex, who both had (more...)
MobaXterm version version 9.3 was released about a week ago. The eagle eyed amongst you may have noticed I didn’t post about 9.2. That’s because it was released the day before 9.3.
The downloads and changelog are in the usual places.
If you use Windows and ever need SSH or an X server, you need this in your life. Imagine Putty and Cygwin wrapped up together, placed on a exercise program and injected (more...)
And here we are. The last day of Oracle OpenWorld 2016…
The first session I went to was a panel session called “Thinking Clearly About Database Application Architecture” with Gerald Venzl, Bryn Llewellyn, Connor McDonald, Toon Koppelaars, Cary Millsap. The session started with an introduction by Toon, explaining how the thick database architecture model is provably superior to the thin database model, especially from a performance perspective. I am definintely in (more...)
I mean, in principle it’s not that special, being that the info is already on…
As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool version, the downside is that is currently available on Oracle cloud only. We are all waiting for the on-premise release so we can install and … Continue reading Oracle 12.2 Cool New Features
Don’t forget Oracle Midlands Event #17 next week!
I don’t know about you, but I would like to know what Oracle have been up to. There has been very little in the way of publicity from them recently…
If you live near, please show your support for the event and come along. It’s free thanks to the sponsorship by RedStackTech.
Oracle Midlands : Event #17
was first posted on September 22, 2016 at 7:41 am.
I started the day by meeting up with a bunch of people at the Dbvisit breakfast. This has become a regular event over the last few years. Followers of the blog know I like the Dbvisit folks and they tend to attract people I find fun and interesting. After food, loads of coffee and interesting conversation, it was time to head across to the conference.
I bumped into Liron and Zohar at the OTN lounge and walked over with them to watch Connor (more...)