I must thank my fellow DBA Franky Weber Faust for his publication in his blog.

In this post I board a little more about the Flex Disk Group.

In the previous post we had started this subject, if you did not see check there

The purpose here is to show how to store a PDB in a Flex Disk Group. In this example we will store one of the tablespaces of the PDB pdb1 and compare it with the others.

With the oracle user, I point the environment variables to my orcl_2 instance:

We created the new PDB and pointed to the PDB1TBS tablespace to be stored in Disk Group Flex:

Then we open PDB1:

Let’s see how the PDB1 files are left. Point the environment variables to the +ASM1 instance:

Access asmcmd and list the orb database (CDB) and PDB1 datafiles to see the differences:

Note that in the Flex Disk Group the pdb1 PDB datafile was created with Mirror Redundancy and the orcl CDB datafiles that are in the Disk Group DATA are as Unprotected.

This is due to the standard redundancy of datafiles in a Flex Disk Group.

Querying information from the disk groups we find that the redundancy is of the Flex type:

In this post we saw that to store a database, be it Non-CDB, CDB or PDB, we only need to inform the disk group. In the example presented we stored only one of the tablespaces of our PDB pdb1 in the disk group FLEX. In the next post we will see some more features of Flex Disk Groups.

Leave a Reply