Database Reference
In-Depth Information
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.1.0
The corresponding information in the alert.log is shown here as well.
ALTER DATABASE MOUNT
[...]
2013-08-14 18:56:15.100000 +01:00
ALERT: Compatibility of the database is changed from 11.2.0.0.0 to 12.1.0.0.0.
Increased the record size of controlfile section 12 to 96 bytes
Control file expanded from 614 blocks to 618 blocks
Increased the record size of controlfile section 13 to 780 bytes
Control file expanded from 618 blocks to 620 blocks
[...]
ALTER DATABASE OPEN
Switching redo format version from 11.2.0.0.0 to 12.1.0.0.0 at change 1106948
Thread 1 advanced to log sequence 87 (COMPATIBLE advance)
With that setting in place you can move on to the next task which is to check the compatibility of the database
with the destination CDB. It allows you to check if the non-CDB can be plugged into a CDB.
Checking compatibility
The compatibility check is performed in two steps. In the first step you need to create an XML file describing the
future PDB to be plugged in. It goes almost without saying that the aspiring PDB's data files are available to the CDB's
host but this too is a requirement.
You create the XML file using the new DBMS_PDB package using the DESCRIBE function as shown here:
SQL> exec dbms_pdb.describe(-
> pdb_descr_file => '/u01/app/oracle/admin/ora11/pdb/ora11.xml');
PL/SQL procedure successfully completed.
The database needs to be opened READ-ONLY or the execution of the procedure will fail with that error message.
The file created-ora11.xml contains a logical description of the database to be plugged in. It specifically sets the
pdbname to the database's unique name which will be important later. It also records further metadata such as the
byte order (“endianness”), the database ID and others before it lists all the data files. Towards the end of the file you
find the options in use in the database including their respective versions. Finally important initialization parameters
are listed alongside their respective values. All the information in the XML file will next be used to assess the
compatibility of the database with its future container.
Now switch to the CDB into which you want to plug the database and execute the compatibility check. This too is
found in the DBMS_PDB package. Continuing the example here is the check:
SQL> declare
2 is_compatible boolean;
3 begin
4 is_compatible := dbms_pdb.check_plug_compatibility(
5 pdb_descr_file => '/u01/app/oracle/admin/ora11/pdb/ora11.xml'
Search WWH ::
Custom Search