This note shows the procedure used to apply the June 2020 patches to an OEM 13c Release 4 Cloud Control environment and also the work around adopted to overcome the error OMSPatcher failed with error code = 241 Download the note ….
In a previous post we have looked at some of the new features for the Data Guard Broker Observer in 19c like the ability to run the Observer in OBSERVE ONLY mode as well as some other features like multiple Observers and multiple failover target standby databases. In this note we look at how Master […]
One of the new features introduced in Oracle 19c is to run the Data Guard Broker Observer in OBSERVE ONLY MODE. Without impacting the current Data Guard configuration, we can test how various fast start failover scenarios would work in our environment before actually enabling the change to the Observer configuration. The Data Guard Broker […]
One of the new Data Guard Broker features introduced in Oracle 12c Release 2 was the ability to set multiple Fast Start Failover (FSFO) targets with the broker determining which was the ideal Data Guard standby database to perform a failover operation to. This was configured via the property FastStartFailoverTarget. In this example we have […]
This note describes the procedure used to clone an Oracle 19c database software ORACLE_HOME using a Gold Image. As a one-time task, we use the new Oracle 19c option –createGoldImage to create a ‘master’ copy of the Oracle 19c database software (this will include January 2020 PSU patch). The generated zip file is then copied […]
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 ….
Introduction In previous releases of Oracle Database prior to Oracle 12c Release 1, there were separate audit trails for individual components. For example: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$ for Oracle Database Vault, Oracle Label Security, Starting with 12c Release 1, Oracle has unified all of the auditing types into […]
This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the note …..
This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the note …..
This note is a step by step guide to installing and configuring an Oracle 12c Release 2 Real Application Clusters environment using VirtualBox. This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the […]
Connect to the GoldenGate Cloud Marketplace Node Identify the Public IP Address of the GoldenGate Cloud Marketplace compute node and connect via PuTTY using the saved PPK private key. (note we had to provide the SSH Public Key details when we deployed Oracle GoldenGate Cloud Marketplace) Note the directory structure of the GoldenGate Cloud […]
Move to Autonomous Database (MV2ADB) is a tool developed by Oracle (thanks Ruggero Citton, great work!) to fully automate the process of migrating data both from on-premise as well as OCI Classic Gen 1 to Autonomous Database Cloud on OCI. Data migration and loading to an Autonomous Database can now be performed using a single […]
In example we will use a combination of Oracle Cloud Marketplace GoldenGate and the MV2ADB tool to migrate data in real-time from an Oracle 12c database hosted on Gen 1 OCI Classic infrastructure to an OCI Oracle 18c Autonomous database. Oracle GoldenGate Extract and Replicat processes run on Cloud Marketplace which has network connectiviy to […]
Oracle Cloud Marketplace (https://cloudmarketplace.oracle.com) is an online store selling a wide variety of business applications and services which can complement an existing Oracle Cloud implementation. All these applications and services available on the Cloud marketplace are offered by Oracle approved and registered partners and developers. Oracle GoldenGate is one of the many applications available on […]
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 new sub-program called COMPARE_PLANS has been added to DBMS_XPLAN. With this new functionality, we can take a reference plan and compare it with some other execution plan – it could belong to a SQL statement already executed where we obtain the plan from the Cursor Cache or from the AWR history […]
