Migrating the database from File System to ASM (12c)

Hello everyone!

On this post I will show how migrate your oracle database reside on a file system to an ASM.
I will not entered on the detail how to configure and install your grid infrastructure software and how to allocate/create disks to ASM. 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