• Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 5

    Tutorial Objectives Preparation: TERMINAL WINDOW #1for i in {1..10000}doecho “Insert Data $i – `date +%d-%m-%Y-%H%M%S`”sqlplus -s sys/Oracle_4U as sysdba<<EOFset heading on feedback on;alter session set container=pdb1;insert into test_Ins(c1, c2, c3) values ($i, sysdate, ‘Loop1’);commit;EOFdone; TERMINAL WINDOW #2for i in {1..100000}doecho “Insert Data $i – `date +%d-%m-%Y-%H%M%S`”sqlplus -s sys/Oracle_4U as sysdba<<EOFset…

  • Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 4

    Tutorial Objectives CREATE THE RMAN INCREMENTAL LEVEL 1 BACKUP SCRIPT [oracle@prdb01 ~]$ cat rman_bkp.rcv{allocate channel sbt1 device type sbt format ‘%d_%U’ PARMS=”SBT_LIBRARY=/u01/app/oracle/product/19.0.0.0/dbhome_2/lib/libra.so, ENV=(RA_WALLET=’location=file:/u01/app/oracle/product/19.0.0.0/dbhome_2/network/admin/server_wallet credential_alias=dr_zdlra_pr’)”;allocate channel sbt2 device type sbt format ‘%d_%U’ PARMS=”SBT_LIBRARY=/u01/app/oracle/product/19.0.0.0/dbhome_2/lib/libra.so, ENV=(RA_WALLET=’location=file:/u01/app/oracle/product/19.0.0.0/dbhome_2/network/admin/server_wallet credential_alias=dr_zdlra_pr’)”;backup cumulative incremental level 1 filesperset 1 section size 64g database plus archivelog not backed up filesperset…

  • Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 3

    Tutorial Objectives DATA GUARD BROKER CONFIGURATION [oracle@prdb01 server_wallet]$ dgmgrlDGMGRL for Linux: Release 19.0.0.0.0 – Production on Wed Sep 8 16:37:02 2021Version 19.10.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.Welcome to DGMGRL, type “help” for information.DGMGRL> connect / as sysdgConnected to “cdb2″Connected as SYSDG.DGMGRL> show configuration;Configuration – cdb_dg…

  • Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 2

    Tutorial Objectives INCREMENTAL LEVEL 0 BACKUP [oracle@prdb01 server_wallet]$ . oraenvORACLE_SID = [cdb] ? cdbThe Oracle base remains unchanged with value /u01/app/oracleCONNECT TO CATALOG DATABASE [oracle@prdb01 server_wallet]$ rman target / catalog /@dr_zdlraRecovery Manager: Release 19.0.0.0.0 – Production on Sun Sep 19 21:12:48 2021Version 19.10.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates….

  • Zero Data Loss Recovery Appliance (ZDLRA) Hands-On Lab 1

    Tutorial Objectives ENVIRONMENT ZDLRA Servers ZDLRA Catalog Databases Protected Database CDB (19c) Passwords CREATE VPC USER On both ZDLRA servers connect as rootPRIMARY ZDLRA[root@przdlra01 ~]# racli add vpc_user –user_name=vpc_cdb[vpc_cdb] New Password:Sun Sep 19 20:08:16 2021: Start: Add vpc user vpc_cdb.Sun Sep 19 20:08:16 2021: Add vpc user vpc_cdb successfully.Sun Sep…

  • Exadata Cloud@Customer ZDM Online Logical Migration – Configuring GoldenGate Hub

    One of the components of a Zero Downtime Migration online logical migration is a VM or Compute Instance which hosts an instance of GoldenGate MicroServices. Typically for an ExaCS target database migration via ZDM, the VM or Compute Instance hosting GoldenGate would be OCI based. But for a ZDM migration…

  • Oracle Database 23c New Feature – Column Level Auditing

    In pre-Oracle Database 23c database versions, we did not have the ability to audit selectively any ‘sensitive’ columns in a table – we had to enable auditing for the entire table even though we were maybe interested in only a few columns where we would like to have enabled auditing….

  • ZDM 21.4.3 patch apply – Support for Sequences

    One of the issues associated with a ZDM online Logical Migration was that the database Sequences were not replicated as part of the ZDM migration process. Sequences had to manually advanced as part of the outage window in order to avoid the ORA-00001 unique constraint violation error once the application…

  • Using Terraform to manage OCI GoldenGate Cloud Service

    Terraform by Hashicorp is an Infrastructure as code (IaC) tool and provides automation to provision and manage resources in any cloud including Oracle Cloud Infrastructure (OCI). The OCI provider enables usage of Terraform to interact with Oracle Cloud Infrastructure resources including Oracle GoldenGate Cloud Service. The link below shows the…

  • Managing OCI GoldenGate with OCI Command Line Interface (OCI CLI)

    One of the tools available to manage and administer OCI GoldenGate is the OCI Command Line Interface (OCI CLI). The link below provides a list of the available Oracle Cloud Infrastructure GoldenGate CLI commands. https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.37.0/oci_cli_docs/cmdref/goldengate/trail-sequence-summary/list-trail-sequences.html This note describes the usage of OCI CLI commands to perform the following tasks: Creating…

  • Oracle Database 19c Software Cloning using Gold Image (Windows)

    This note describes the process used to create a Oracle Database 19c software Gold Image and using that Gold Image to clone a separate Oracle 19c database software home on a Windows platform. The following issues were encountered in creating the Gold Image as well as when running setup.exe from…

  • Oracle 23c Lock-Free Reservations and GoldenGate 23c Replication support

    One of the new features in Oracle Database 23c is Lock-Free Reservations. In earlier versions, an update to the same row of the same table by two concurrent transactions would impose a row level TX lock – but not any more in Oracle Database 23c! A new RESERVABLE key word…

  • Oracle Database 23c New Feature – Domains

    One of the top new features of Oracle Database 23c is Domains – or SQL Domains or Application Domains or Usage Domains. In short what ever the name – the emphasis is that domains are meant to help the in the development of applications – ensuring data quality and data…

  • GoldenGate23c Replication with Oracle Database New Feature – BOOLEAN Data Type

    Oracle Database 23c introduced the SQL boolean data type which stores the values ‘TRUE’ or ‘FALSE’ in the boolean columns in the table. We can use the keywords BOOLEAN or BOOL in the CREATE TABLE or ALTER TABLE statement. We can use literals to represent “TRUE” and “FALSE” state in…

  • GoldenGate 23c Tutorial – Create Pipelines

    In the earlier tutorial we learned how to create a GoldenGate 23c connection. In this tutorial post we will learn about a new concept in GoldenGate 23c called Pipelines. A Pipeline essentially is an abstract presentation of the entire GoldenGate replication process. All the tasks which were earlier manually performed…

  • GoldenGate 23c Tutorial – Create a database connection

    In pre-23c GoldenGate days, quite a few steps had to be manually performed in the Oracle database which were prerequisites for a GoldenGate configuration. In GoldenGate 23c now all the same steps can be automated when we use the option “Create database connection“. Prerequisites are automatically checked and validated at…

  • Install Oracle GoldenGate 23c Free Release (Part 1 – using Docker)

    At the recent Oracle Cloud World 2023 conference which just concluded at Las Vegas, Oracle has made an announcement about the new Oracle GoldenGate 23c “Free“ release. The free GoldenGate 23c release provides support for all the new Oracle Database 23c objects and data types including blockchain, immutable tables, Boolean…

  • Install Oracle 23c Free Developer Release via Linux RPM

    This note describes the process used to install and configure Oracle 23c Free Developer Release on Oracle Linux 8 using an RPM file. Download the RPM for Oracle Linux via the URL below. https://www.oracle.com/au/database/free/get-started/ Install the oraclelinux-developer-release-el8 package. [root@db23c ~]# dnf install -y oraclelinux-developer-release-el8 Oracle Linux 8 BaseOS Latest (x86_64)…

  • Oracle Database 23c New Feature – SQL Firewall

    One of the new features related to database security introduced in Oracle Database 23c is SQL Firewall. It is embedded in the Oracle Database 23c kernel and conceptually is quite similar to Database Firewall (Audit Vault and Database Firewall AVDF). SQL Firewall offers real-time protection to the database from external…