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 …. Please follow and like us:
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 …. Please follow and like us:
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 …. Please follow and like us:
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 […]
In Oracle 19c a number of new features have been added to DBCA in silent mode. In Oracle 18c, we could clone a PDB both via the GUI DBCA as well as using the dbca -silent -createPluggableDatabase command. New in Oracle 19c is the ability to create a remote clone of a PDB as well […]
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 12.2.0.1.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 […]
This note describes the new features related to the Oracle Database Multitenant option which have been introduced in Oracle 12c Release 2 (12.2.0.1). 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 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 12.1.0.2 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 11.2.0.3 to Oracle 12c Release 1. The Container database cdb12c originally has one pluggable database testdb1 (as well as the seed PDB). We […]
