Introduction Oracle 26ai is not yet available on Bare Metal ODA, but it will probably be in a few weeks. For now, 26ai is available as a DB System on Oracle Database Appliance, meaning that it’s already possible to test this new version. Let’s try to migrate a 19c Bare Metal PDB to a 26ai DB System using 3 different…
I recently had to install and configure the Veeam RMAN plug-in on an ODA, and would like to provide the steps in this article, as it might be helpful for many other people. Create Veeam linux OS user We will create an OS linux user on the ODA that will be used to authenticate on the Veeam Backup server. This…
Troubleshooting Oracle Data Guard when your standby database has errors or is not in sync
As you might know Dbvisit StandbyMP is a great Disaster Recovery solution for Oracle SE databases. Dbvisit recently communicated, providing now, a Test Drive system for customer to easily try the product and for partner to easily have a Demo environment. In less than 2 minutes, an environment with a Control Center host and multiple database server hosts with either…
In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered that a very nice oracle feature existing since Oracle 12cR1 enables us to archive rows automatically. Let’s me explain you how it works:…
Introduction Extracting DDL is sometime useful for creating similar objects in another database without data. Basically everything can be extracted from a running Oracle database. The needs My customer asked me to replicate a database without any data. The goal is to feed development environments running on Docker, so with a minimal footprint. The precise needs were: All the metadata…
Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to go to production and you can scale up and down. Oracle Cloud Infrastructure, or OCI, is a Cloud provider you…
Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5), we will see how we can refresh it and see the impacts on the oracle database itself. For more information on Nutanix products, I would encourage you to visit Nutanix website. Create a test table on the ORATEST source…
Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), that we could run snapshot and take Log Catch Up (see Nutanix Era Blog part 4), we will now see how we can clone an oracle database. For more information on Nutanix products, I would encourage you to visit Nutanix website. Database Menu Source database and…
Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), we will be looking how to run snapshot and Log Catch Up and how will this take effects on our oracle database. For more information on Nutanix products, I would encourage you to visit Nutanix website. Time Machines Snapshot and Log Catch Up are done with…
In the previous blog (Part 2) we have created a VM template for oracle database and we could successfully registered it in Nutanix Era. Now we are going to use it to provision an oracle database named ORATEST on a new VM called test1-VM. For more information on Nutanix products, I would encourage you to visit Nutanix website. Check As…
Introduction In an Oracle database, services have multiple purposes: identifying group of users prior authenticating them enabling/disabling access to a database for particular groups managing preferred nodes on a RAC configuration redirecting users to the primary after a switchover/failover when using Data Guard or Dbvisit Standby redirecting read only connections to Standby database with Active Guard option A customer asked…
