This post was originally published on Working With Devs. Welcome to part 2 in this short series. In this post I’ll explain how to extend the Oracle DB continuous integration process I set up in part 1 by adding a release management process that deploys changes to staging or production databases at the click of a button. Objective for part… Continue Reading →

All Things Oracle Full Articles, Continuous Delivery, Database Administration, Database Development

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database files (database version 11.2.0.4 and up) in addition to general-purpose files so that entire Oracle databases can be stored inside Oracle Cloud FS. In my earlier articles I demonstrated that: For a database having its files stored on Oracle Cloud… Continue Reading →

All Things Oracle Full Articles, Backup and Recovery

This post was originally published on Working With Devs. Welcome to part 1 in this short series, where I explain how to set up a continuous integration process for Oracle databases. In part 2 I’ll set up a release management process that allows a user to deploy changes to staging and live databases at the click of a button. Objective… Continue Reading →

Continuous Delivery, Database Development

In my last article, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database files (database version 11.2.0.4 and up) in addition to general purpose files, so that entire Oracle databases can be stored inside Oracle Cloud FS. In addition, for a database with its files stored… Continue Reading →

All Things Oracle Full Articles, Backup and Recovery

Introduction: Integrated Replicat is a feature unique to Oracle GoldenGate 12c, for Oracle Database versions starting from Oracle 11g (11.2.0.4) and Oracle 12c (12.1.0). Classic Capture Mode: The Oracle GoldenGate Extract process captures data changes from the Oracle redo log files or archive log files on the source database system. Integrated Capture Mode: Oracle GoldenGate Extract process works directly with… Continue Reading →

12c, All Things Oracle Full Articles

In the first three installments of this series I outlined the mechanisms used by Oracle to analyze a very simple query. Sticking with the informal approach, I’m going to look at the high-level strategy the optimizer takes when handling a more complex query. To do this I’ll be looking at query blocks, scratching the surface of query transformation, explaining why it’s a… Continue Reading →

All Things Oracle Full Articles

Recovery Manager (RMAN) is the preferred tool to backup and recover the Oracle Database. You can use recovery catalog or the control file of the target database for RMAN Repository, but Recovery Catalog is the preferred method as it offers several advantages over the others, like reporting operations, simple recovery in case of control file damage, and more. Generally in… Continue Reading →

11g, 12c, All Things Oracle Full Articles

We need a baritone voiceover man. You know how those huge TV shows – 24, Prison Break, Jane the Virgin – always start with a recap sequence to bring you up-to-date in case you’d missed the last episode. And it’s always a deep-voiced male narrator: “Previously on The Walking Dead,” he’ll say. We need that guy. Previously on Anatomy of a… Continue Reading →

All Things Oracle Full Articles

Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS option. From Oracle 12cR1, database RMAN introduced an option called ‘NO OPEN’, which duplicates your database to a new location and keeps it in an unopened state. Using this feature we can duplicate a database… Continue Reading →

12c, Backup and Recovery

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment ) supports database files (database version 11.2.0.4 and up) in addition to general purpose files so that entire Oracle databases can be stored inside Oracle Cloud FS and can leverage the Advanced Data Services such as snapshots, tagging and auditing although replication and… Continue Reading →

12c, All Things Oracle Full Articles