Pluggable Database save state (automatic start)

On this post I will show one interesting feature on 12c at version 12.1.0.2, save state of a pluggable database.
After restart a container database all pluggables databases stays on mount state, imagine if you are a DBA with more than 100 PDBs.
You may need to write a trigger event or a script to put the PDBs on write mode, this operations could be complexs.
Considering that not all PDBs don’t have to stay on write mode.

Let’s start: Continue reading

Oracle Database 12c: Move datafile online (New feature)

Hello readers!!
Today I will talk about one interesting feature on Oracle 12c: Move a datafile online.
You could have many reasons to move a datafile online, for example: to another file system, or to another ASM disk group.
On previous versions if you want to move a datafile or rename, you must to put datafile offline and you need to recover the datafile and bring back online. During this operation it is not possible access the data inside the datafile. Continue reading