Today we will play with an exciting and not very well-known feature within the Oracle Database, called Application Continuity (AC) which is available with the Oracle Real Application Clusters (RAC), Oracle RAC One Node and Oracle Active Data Guard options and it masks outages from end users and applications by recovering the in-flight database sessions…
Category: 12c
Playing with the new OCI Full Stack Disaster Recovery (Full Stack DR) – Part 2 – It is now time to Play
Note: You can review the environment setup part of the tutorial here. Now that we have all DRPGs created and associated, it is time to add members to each DRPG (primary and standby). For the primary (Ashburn) DRPG we will add: The primary DB (ATP) The 2 Mushop Compute VM’s Two Volume Groups (Boot volumes…
Playing with the new OCI Full Stack DR – Part 1 – Preparing the Environment
I am very happy to announce the GA of the new Oracle Cloud Infrastructure (OCI) solution that the Oracle MAA team has been working very hard to bring to you (Thank you, Suraj Ramesh). Today we will play with the new, Full Stack DR it is a fully managed OCI disaster recovery orchestration and management…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part II – Redo)
What is redo? Let’s look briefly at the redo process. When Oracle blocks (the smallest unit of storage in a database) are changed, including UNDO blocks, Oracle records the changes in vector changes, which are referred to as redo entries or redo records. The changes are written by the server process to the redo log…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part I)
The constant evolution of IT has, among other things, affected the role of a database administrator (DBA). Today the DBA is not merely a Database Administrator anymore but is morphing more into the Database Architect role. If you want to become a successful DBA and be more competitive in the market, you should have a…
Playing with Active Data Guard – DML Redirection and Automatic Block Media Recovery
Today we will be playing with two functionalities of Oracle Active Data Guard (ADG): DML Redirection Automatic Block Media Recovery DML Redirection is the capability ADG has to redirect DML operations made in the active-standby node to the primary node without impacting its protection of it (by redirecting all DML transactions to the primary database…
Playing with Oracle Database Security Assessment Tool (DBSAT)
The Database Security Assessment Tool (DBSAT) is an incredible free command line tool provided by Oracle Corporation as a utility to help you verify your database for common database security issues(including security policies and controls in place), as well as helping to identify possible sensible data stored with the database. To be able to use it you need to…
Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup
The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database deployment (DBaaS) whose database is instantiated from a cloud backup created by using Oracle Database Backup…
Playing with Oracle Database Cloud Backup Service
This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances (DBaaS). Requirements: To perform the steps in this tutorial, you will need: An understanding of…
Playing with CrashSimulator
Hi everyone, Today I will show you how CrashSimulator (Shell Script – current version 1.04) works in detail. When unzipping the zip file you will find the following files within it: CrashSimulator.sh.x – For high-resolution ssh emulator screens, it shows all 3 menu columns on one screen. CrashSimulator_Low.sh.x – For low-resolution ssh emulator screens, it shows…