Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.
By Mouhamadou Diaw In a previous blog I talked about the FSFO callout scripts which is a new feature with Oracle 21c with the broker. This feature will allow to execute some tasks before and after a fast-start failover. By default, the automatic failover will not happen if the pre-script fails. Maybe it’s not what we want, sometimes we will…
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…
By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I write the results in this blog Below the actual configuration of my Data Guard environment 1 2 3 4 5…
By Clemens Bleile I had a discussion with a customer recently about the risk of running into an issue with ransomware encrypting data of Oracle databases. Just to quickly recap on what ransomware is: Wikipedia: Ransomware is a type of malware from cryptovirology that threatens to publish the victim’s personal data or perpetually block access to it unless a ransom…
I have recently deployed a new ODA with last version 19.14 at customer side, and we could face an interesting failure deploying the appliance, which I would like to share with you. Problem description After reimaging the ODA and configuring the network interface with configure-firstnet, we created the appliance : [root@oak ~]# odacli create-appliance -r /u01/patch/ODA01.json Enter an initial password…
By Mouhamadou Diaw With Oracle 21c (In fact Oracle 20c), we have a nice new feature with the broker which is the Fast-start Failover Callout Configuration scripts. I talked about this feature in some presentations I did about the new features with Oracle 21c for the broker This feature will allow to automate tasks that must be performed before and…
Introduction Patch 19.14 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings January’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest 21.5 but only for DB Systems (21c being an innovation release). Don’t expect too many new features for this release (actually, I don’t…
Introduction While patching ODAs from 19.10 to 19.13, the update-dbhome could fail if some databases inside this dbhome are stopped or only mounted. Job would then stop with a DCS-10001:Internal error encountered: PRGH-1153 : RHPHelper call to get runing nodes failed for DB: “ARITSTDB”. How to solve this problem? Environment description My environment is composed of 3 X8-2M ODAs, 2…
By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. We have seen here how the target refreshable PDB can be used as a master to provide PDB snapshots. In this blog we are going to continue in the same topic and talk about PDB Snapshot Carousel…
Introduction Oracle Database Appliance now fully supports virtualization with KVM, and this could be interesting for some of us. If you’re using Enterprise Edition, you probably decreased the number of cores to comply with your licenses. Now you can increase your core configuration with more cores, some being dedicated to your databases, and some for user-managed VMs. Let’s find out…
By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. The target PDB can be in mounted state (mandatory to be refreshed) or can be opened in a read only mode. One application is to use the target refreshable PDB as a master to provide PDB snapshots.…
Would you like to quickly provide your engineering team with a real production environment database with updated data to develop new features? Does your operational team need a copy of the production database to test a new release or a new patch? “Easy” would you say. “Let’s do a clone and duplicate the production database with RMAN!”. Yes, but would…
