Tag Archives: 12c

Oracle Database 12c : Some Backup and Recovery Stuff

In a previous post, I had already listed an article on backup and recovery when using the Oracle 12c multitentant option. Multitenant : Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB) In that article I made reference to a restriction when using flashback database against a CDB with a PDB [...]




Articles on Oracle Database 12c Multitenant Option

From a technology perspective, the Multitenant option is really cool, but it can be rather difficult to get to grips with some aspects of it. Everything is so intertwined and every feature in 12c somehow links back to the Multitentant option. As I’ve been working my way through the features the same pattern keeps repeating. [...]




Scheduler Enhancements in Oracle Database 12c

I’ve spent the last couple of days playing around with the scheduler enhancements in Oracle 12c. Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) I guess the big news is the new “script jobs”, which are pretty cool. This kind-of passed me by until Brynn Llewellyn mentioned them at UKOUG in his Multitenant [...]




Data Pump Enhancements in Oracle Database 12c

Another one to file under “Not sexy but flippin’ awesome!” If you are a DBA, you are going to spend a lot of time with Data Pump. All roads seem to lead back to it. There are some more headline worthy features, like transportable database, but the two that jumped out at me were actually [...]




PL/SQL White Lists in Oracle Database 12c Release 1 (12.1)

I’ve been playing about with the ACCESSIBLE BY clause to create PL/SQL white lists in Oracle 12c. Here’s the article I wrote about it. PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1) There seem to be some discrepancies in the documentation*, which I’ve highlighted in the article. Not [...]




Online Move Datafile in Oracle 12c

The ability to move datafiles as an online operation is bloody awesome! It’s another one of those cool little things that you will wonder how you ever lived without. I can’t wait to move to 12c just for this feature. I could clean up so much crap so easily. Here’s a little write-up on it. [...]




Cloud Control 12c Database Backup Jobs (Continued)

I’ve been rather critical of the way Cloud Control handles database backup jobs, as can be seen in these two previous posts. I love Cloud Control 12c, but the job management is really annoying! Oracle Cloud Control EMCLI : First Thoughts Yesterday I found out I schedule database backups in Cloud Control the “wrong way”… [...]




Quick Pluggable Database (PDB) Update…

I’ve been playing around with using SQL Developer and Cloud Control 12cR3 for managing pluggable databases (PDBs) this morning. I’ve added a couple of quick references to my PDB article. Multitenant : Create and Configure a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) If you understand the DBCA and SQL*Plus approach, the [...]




Oracle 12c Multitenant Option : CDBs and PDBs…

I started trying to play with the Oracle multitenant optionĀ (all that pluggable database stuff) a little while ago and gave up. It’s wasn’t that it was that difficult. More than anything my problem was I didn’t know what to focus on first. There is so much to it and it’s all interrelated, so you start [...]




Oracle Certified Professional (OCP) Database 12c…

I just noticed the Database 12c OCP beta exams have started to appear (see here). Not surprisingly, the multitenant option seems to be a big factor in the content of the both the Advanced Administration and Upgrade exam. There are a few things that seem a little odd (to me) though: Use Oracle Restart to [...]