18 Shares 0 Facebook 1 Twitter 3 Linkedin 1 Facebook-messenger 12 Whatsapp 1 Email 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…
Category: Tutorials
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part II – Redo)
2 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 2 Whatsapp 0 Email 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…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part I)
3 Shares 0 Facebook 0 Twitter 1 Linkedin 0 Facebook-messenger 2 Whatsapp 0 Email 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…
Playing with Active Data Guard – DML Redirection and Automatic Block Media Recovery
5 Shares 0 Facebook 1 Twitter 3 Linkedin 0 Facebook-messenger 1 Whatsapp 0 Email 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…
Playing with Oracle Database Security Assessment Tool (DBSAT)
2 Shares 1 Facebook 1 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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…
Playing with ADWC (Autonomous Data Warehouse Cloud Service)
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email Oracle has launched Oracle 18c and the Autonomous Data Warehouse Cloud Service (ADWC). Many people call the Oracle 18c as the Autonomous database, and this is a huge mistake! Oracle 18c (that is in reality Oracle 12.2.0.2) is not an autonomous…
Playing with Oracle Ravello – Migrating your VMs to the Cloud
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email Hello everyone, A few years back we had the boom of the “Private Cloud” rush, where everyone started to implement virtualization technologies to make a better use of it Infrastructure resources and improve high availability, scalability and innovation! Now to simplify…
Playing with Oracle Cloud – Creating a Hybrid DR Deployment
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high availability…
Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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…
Playing with Oracle Database Cloud Backup Service
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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)….