Menu ☰
RMAN one of the best tools to move “On-prem” databases to the Cloud

RMAN one of the best tools to move “On-prem” databases to the Cloud Hi Readers RMAN is that a extreme powerful utility that can be used for many typical DBA Tasks, explore how great can be this tool for moving databases to Cloud. Enjoy watching! We hope the content could useful for your Oracle DBA …

Starting Oracle Database Cloud.. Where the DBAs are going to be working.. ?

Starting Oracle Database Cloud.. Where the DBAs are going to be working.. ? Hi Readers This is an interesting question.. yes or not.. ? Let our talent colleague Oracle ACE Director: Kellyn Pot’Vin-Gorman to answer it in a video of 2:43min. Enjoy!! Future of the DBA #C18LV We hope the content could useful for your …

12 Things You Need to Know about Oracle Database 12c R2

12 Things You Need to Know about Oracle Database 12c R2 Hi Readers At these times we are talking already about Oracle18c, however most of production systems are in 11g,, 12cR1.. 12cR2.. so.. We think you will love this material. Enjoy Connor McDonald Talking about Oracle Database 12c R2 https://go.oracle.com/LP=60882?elqCampaignId=92113https://go.oracle.com/LP=60882?elqCampaignId=92113&src1=:ow:lp:sh:em::LPD100664923NLP3&intcmp=OUNV170405P00034:ow:lp:sh:em::LPD100664923NLP3 Ask Tom Answer Team (Connor McDonald and …

Oracle Cloud: How to Start in Oracle Database Cloud Career

Oracle Cloud: How to Start in Oracle Database Cloud Career Hi Readers  A typical question I receive many times during the week is: “I’m DBA.. I have a lot of experience with “On-Prem” databases.. how I start with Oracle Cloud.  I invite you to read these 3 articles and get the proper answers for that, …

Oracle 12cR2: Cross-Platform PDB Transport Using XTTS

Oracle 12cR2: Cross-Platform PDB Transport Using XTTS Hi Readers Let’s see how we can perform this process: Verify the prerequisites: The source PDB must be closed in MOUNTED mode and the COMPATIBLE parameter must be set to 12.2 or higher. Start an RMAN session and connect to the CDB instance of the PDB to be …

Oracle 12cR2: Cross-Platform Transportable PDB

Oracle 12cR2: Cross-Platform Transportable PDB Hi Readers Oracle Database 12.1 allows you to transport database or tablespace backup sets with conversion at source or destination for same endian platforms. Oracle Database 12.2 includes cross-platform PDB backup and restore into a CDB by unplugging at backup step and plugging at restore step as long as the …

Oracle 12cR2: Upgrading a Single Regular PDB from 12.1 to 12.2

Upgrading a Single Regular PDB from 12.1 to 12.2 Hi Readers  You can also upgrade a specific PDB without upgrading the whole CDB: Prepare the PDB to be unplugged and upgraded in another CDB by executing the same jar file as in the previous slide but only on the PDB. The fixup scripts and log …

Oracle 12cR2: Controlling the Degree of Parallelism of Queries

Controlling the Degree of Parallelism of Queries Hi Readers  Oracle Database 12.2 introduces a new instance parameter to control the Degree of Parallelism of queries, which involves a containers() construct. By default, a query involving a containers() construct uses a DOP that is equal to the following value: In the case of a query in …

Oracle 12cR2 (Tip): Local UNDO Mode Versus Shared UNDO Mode

Local UNDO Mode Versus Shared UNDO Mode Hi Readers Using the local UNDO mode is required when cloning a PDB in hot mode or performing a near-zero downtime PDB relocation or refreshing PDBs or using proxy PDBs. You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB …

Oracle 12cR2 ( New Features ): Near-Zero Downtime PDB Relocation

Hi Readers To get the same result as unplugging and plugging a PDB from a remote source CDB into another CDB, you can take advantage of the Oracle Database 12.2 feature such as near-zero downtime PDB relocating. In Oracle Database 12.1, unplugging and plugging a PDB requires several steps such as unplugging the PDB from …