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: Tutorials
Playing with various Boot options and Kernels in Oracle Linux
Are you curious about what a boot is and how it works? Look no further! Check out this informative article on Oracle Linux where you can learn about boot options, available kernels, and more. Plus, you’ll get to play with exciting tools and applications that will make your life easier. Discover how to change your…
OracleMAA comes to Japan – Come and Join me
This middle November, I will be presenting three sessions at one of my favourite events, the DB Tech Showcase in Tokyo, Japan. This is a free event, and if you are in Japan, please feel free to register and come to meet me at any of my following sessions (Dates and Times in Japan Time…
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…
Announcement – Oracle Data Guard per Pluggable Database (DGPDB) is available today with the 21.7 RU
I am very happy to announce that with the new 21.7 RU for Oracle Database released today (Doc ID 2796590.1), a new functionality for Data Guard is out! Data Guard per Pluggable Database, or DGPDB for short, fully enables multi-tenancy at high availability level. Ludovico Caldara is talking about this new functionality in an official…
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…