The Oracle RMAN backup encryption is necessary if you want to backup your database into the Oracle cloud. In Oracle 12c, you have three methods available to encrypt an Oracle RMAN backup: with a passphrase with a master encryption key hybrid with a passphrase and an encryption key On docs.oracle.com, the basic setup is described here: https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/configuring-encryption-backups.html#GUID-4A1F5CF5-7EAF-4D71-9B7F-B46412F552CE In this blog post, I show you how to configure your database environment with a master encryption key and a keystore. I use this solution to to backup and recovery to and into the Oracle cloud. And in the cloud, I don’t like to type in passwords manually for every action or write passwords in backup and restore scripts. There are also some…
Read MoreCategory: 12cR2
Oracle Data Pump with the 12.2.0.1.0 Instant Client for Linux x86-64
From the Oracle Database 12c Release 2 (12.2) New Features Guide: Adding Oracle Data Pump and SQL*Loader Utilities to Instant Client This feature adds SQL*Loader, expdp, impdp, exp, and imp to the tools for instant client. Now you can run these utilities on machines that do not have a complete Oracle Database installation. The newest release of the Oracle Instant Client for Linux x86-64 has an additional package called Tools. This package contains Data Pump, SQL*Loader and the Workload Replay Client for Real Aplication Testing. The good old import export tools is included too. This is very nice. For example, if you want to load application log files with SQL*Loader into the database which are located on a separate server,…
Read MoreOracle 12.2 – how to get access to Enterprise Manager 12c Database Express
Today I have built in my OL 7.3 VM two container databases to verify the new feature in the Enterprise Manager 12c Database Express login screen where I can go direct into a container. The benefit is that I don’t have to set a separate port for each pluggable database anymore. The DBCA has created me a fresh container database called ZH38 and a pluggable database ZHPDB01. I have enable the checkbox to configure EM 12c Database Express for Port 5501. After the database creation was finished, I was able to see the login screen, but the login was not possible. I got an XDB login prompt. SYS, SYSTEM and other users where I tried were not accepted. I found …
Read MoreOracle 12.2 – New Features I like – Part 1: Multitenant “Hot Clones”
I like the Oracle Multitenant architecture which was introduced in 12.1. But the concept to clone a source database to multiple copies in a small step had one big problem. In Oracle 12.1, to clone a pluggable database the source database had to be in state read-only. In 12.2 is it not longer necessary to set the source pluggable database in state read-only, the source database has not to be modified to create a clone. Oracle calls it in the documentation “Hot Clone”. Link to the official Oracle documentation: https://docs.oracle.com/database/122/ADMIN/creating-and-removing-pdbs-with-sql-plus.htm#ADMIN13584 Here is a clone of the pluggable database PDB1 into PDB2 in the Oracle Database Cloud Service. Verify existing Pluggable Databases and States – PDB1 is in state READ-WRITE SQL>…
Read More