This note outlines the steps to create an Oracle 19c Container Database via DBCA and then use the RMAN DUPLICATE command to create an Oracle 19c physical standby Container Database. Download the note ….
This note illustrates the steps required to upgrade an Oracle 12c Data Guard Primary and Standby database configuration to Oracle 19c and the convert the Oracle 19c non-CDB Primary/Standby databases to an Oracle 19c Pluggable Databases hosted in an Oracle 19c Data Guard Container CDB. Download the note ….
This notes describes the procedure used to upgrade an Oracle 12c non-CDB to Oracle 19c and then plugin the upgraded database to a 19c Container Database as a Pluggable Database(PDB). Download the note ….
We can clone a PDB using snapshots of the underlying storage via the SNAPSHOT COPY clause of the CREATE PLUGGABLE DATABASE statement. Performing PDB clones using a snapshot copy reduces the time required to create the clone because it does not include a complete copy of the source data files. The PDB snapshot copy occupies […]
SNAPSHOT CAROUSEL A PDB Snapshot is a point-in-time copy of a Pluggable Database. We can create snapshots either manually using the SNAPSHOT clause of CREATE or ALTER PLUGGABLE DATABASE command, or automatically using the EVERY interval clause. When a PDB is enabled for snapshots, we can create multiple snapshots or point-in-time copies of the PDB. […]
A new feature in Oracle 19c is the ability to use DBCA to not only perform a remote clone of a PDB, but also to relocate a PDB from one Container Database to another. Let us have a look an example where we will first clone a PDB and then relocate the PDB to another […]
Oracle 12c Release 2 introduced the ability to execute a DGMGRL command script via the @ command as well as the ability to call host operating system commands via the HOST command. A number of new Data Guard Broker features have been introduced in Oracle 18c like the DGMGRL commands like VALIDATE DATABASE SPFILE, VALIDATE […]
Oracle 12c Release 2 introduced a number of new features which would help reduce outages required for database upgrades. Multitenancy feature was introduced in Oracle 12.1 and these features introduced in Oracle 12.2 would help significantly in not only reducing the overall duration required for a database upgrade, but also in managing and having more […]
Shutdown the 12c Release 2 CDB and PDBs [oracle@host02 bin]$ sqlplus sys as sysdba Connected to: Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 – 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO SQL> […]
In earlier releases prior to Oracle 18c, while we could enable Data Guard for a Multitenant Container/Pluggable database environment, we were restricted when it came to performing a Switchover or Failover – it had to be performed at the Container Database (CDB) level. This meant that a database role reversal would affect each and every […]
Create the common user in both the source as well as target CDB’s This user credentials will be used in the database link between CDB1 and CDB2 and between CDB2 and CDB1. Note the roles and permissions which are granted to this common user. CDB1 and CDB2 SQL> CREATE USER c##link_user IDENTIFIED BY oracle; […]
This note describes the new features related to the Oracle Database Multitenant option which have been introduced in Oracle 12c Release 2 (220.127.116.11). The hands-on exercises included in the note demonstrates the use of the following new multitenancy features: Hot Cloning Refreshable Pluggable Databases Support for pluggable databases with multiple character sets Proxy Pluggable Databases […]
In an earlier post I had mentioned one of the new features in Oracle Database 12.2 was the ability to set SGA and PGA memory related parameters even at the individual PDB level. So it enables us to further limit or define the resources which a particular PDB can use and enable a more efficient […]
In the earlier 18.104.22.168 Oracle database version, we could limit the amount of CPU utilization as well as Parallel Server allocation at the PDB level via Resource Plans. Now in 12c Release 2, we can not only regulate CPU and Parallelism at the Pluggable database level, but in addition we can also restrict the amount […]
One of the new multitenancy related features in Oracle 12c Release 2 is Application Containers. In 12c Release 1, we could have a Container database (CDB) host a number of optional pluggable databases or PDBs. Now in 22.214.171.124, the multitenancy feature has been enhanced further and we can now have not only CDBs and PDBs […]
In a CDB since we have multiple pluggable databases sharing a set of common resources, we can prevent multiple workloads to compete with each other for both system as well as CDB resources by using Resource Manager. Let us look at an example of managing resources for Pluggable Databases (between PDB’s) at the multitenant Container […]
Until very recently I had really believed the marketing hype and sales pitch about how in 12c database upgrades are so much faster and easier than earlier releases – just unplug the PDB from one container and plug it in to another container and bingo you have an upgraded database! Partly true …. maybe about […]
Heres a quick look at some of the new features introduced in 126.96.36.199 around Pluggable and Container databases. PDB CONTAINERS Clause Using the CONTAINERS clause, from the root container we can issue a query which selects or aggregates data across multiple pluggable databases. For example each pluggable data can contain data for a specific geographic […]
Here are a few examples of backup and recovery in an Oracle 12c multitenant environment with Container and Pluggable databases involved. The first thing to keep in mind is the structure of a 12c Container and Pluggable database. There is only one set of control files and redo log files and that is at the […]
In one of my earlier posts we had seen how we can create a 12c CDB (container database) using DBCA and we had also seen how we can upgrade a database from 188.8.131.52 to Oracle 12c Release 1. The Container database cdb12c originally has one pluggable database testdb1 (as well as the seed PDB). We […]