Infrastructure at your Service

12.2 Archives - Blog dbi services

Franck Pachot

Oracle 12cR2: Online tablespace encryption

By | Database Administration & Monitoring | One Comment

By default, all data is visible in the datafiles. Transparent Tablespace Encryption (TDE) can be used to get them encrypted. It requires Enterprise Edition plus Advanced Security Option. Except in the Oracle Cloud when it is available – and mandatory – in all editions. And we can foresee that security policies will be enforced in the future years, by law or because companies realize their files can be stolen. This means that lot of databases…

 
Read More
Franck Pachot

12cR2: Recover nonlogged blocks after NOLOGGING in Data Guard

By | Database Administration & Monitoring | No Comments

You can accept to do NOLOGGING operations on bulk loads or index build according that you do a backup just after, and that your recovery plan mentions how to load the data again in case of media recovery. With a standby database, we usually force logging because we want redo to be generated for all operations in order to ship it and apply it on standby database. 12.2 brings a new solution: do nologging operations,…

 
Read More
Franck Pachot

12cR2 real-time materialized view (on query computation)

By | Database Administration & Monitoring | 2 Comments

Materialized views is a very old feature (you may remember that it was called snapshots a long time ago). It has all advantages of a view, as you can define any select statement that joins, filters, aggregates, and see it as one table. It has all advantages of a table, as it is stored in one segment, can be indexed, partitioned, have constraints, be compressed, etc. It looks like indexes as it stores data redundantly,…

 
Read More
Pierre Sicot

UKOUG Super Sunday

By | Database Administration & Monitoring | No Comments

Today at the UKOUG Super Sunday in Birmingham, I had the opportunity to assist at interesting conferences. The first presentation was about Oracle RAC internals and its new features in version 12.2.0.1 on Oracle Cloud. The main new features concern the cache fusion, the undo header hash table, the leaf nodes, and the hang manager. In 12c release 2 in a RAC environment, the cache fusion automatically chooses an optimal path; the cache fusion collects…

 
Read More
Franck Pachot

12cR2: Upgrade by remote clone – workaround ORA-17630 in DBaaS

By | Database Administration & Monitoring | No Comments

Easier than unplug/plug, you can move pluggable databases with remote cloning. It’s the same idea but you don’t have to manage the files yourself: the are shipped through database link. However, this uses the ‘remote file protocol’ and it fails with version mismatch: ORA-17628: Oracle error 17630 returned by remote Oracle server ORA-17630: Mismatch in the remote file protocol version client server  

 
Read More
Franck Pachot

12cR2: CREATE_FILE_DEST for PDB isolation

By | Database Administration & Monitoring | No Comments

Two years ago I filled an OTN idea to ‘Constrain PDB datafiles into specific directory’ and made it an enhancement request for 12c Release 2. When you provision a PDB, the PDB admin can create tablespaces and put datafiles anywhere in your system. Of course this is not acceptable in a cloud environment. 12.1 has a parameter for directories (PATH_PREFIX) and 12.2 brings CREATE_FILE_DEST for datafiles.  

 
Read More