Exam Preparation – Google Cloud Certified – Professional Cloud Database Engineer

I have aimed to take a Google certification since starting my career. However, I only had the opportunity to work with Google’s products in the last 3 years, when I began working with GCP Cloud. Therefore, I started my preparation in the segment that is my domain: databases. And, mainly because I wanted to go deeper into a product that as Athena for AWS and Oracle as RDBMS, it became one of my favorite products to work with, which is Google’s fully managed, serverless data warehouse named BigQuery. To my…

Exam Preparation – AWS Certified Data Analytics – Specialty

Many people don’t know that the idea of learning from data is not something from the current decade. It was pointed out over 50 years ago by John Tukey in “The Future of Data Analysis” (Donoho, D. (2017)). More and more companies have a Data Warehouse (Data Lake or both – Data Lakehouse) that can handle a massive amount of data, such as 900 TB, and has data imported constantly with SQL-like queries and operators accessing it over the day. What is the reason behind it? Identifying and visualizing patterns…

Analyzing my personal running history data of 2022

2022 was an odd year. I started running in 2021, but only in 2022 I began to compete seriously as an amateur. Therefore, I competed in 12 official races where 9 of which were 10km races and three half-marathon (21 km each). However, using gadgets that helped me to record my results, I ended with 98 unique records, which counted all the official races and all the training. Bearing this in mind, what can we do with this whole amount of saved data? The answer is simple: analyzing and visualizing…

Export Data From Nike Run Club in GPX File Type for Data Analytics

I came up with the idea of creating a dataset to analyze my runnings from 2021 to 2022. Therefore, as I was using Nike Run Club, I tried to extract the data from the application. Still, unfortunately, I only managed to do it using third-parties software. In this case, it was used the RunGAP Workout Data Manager for iOS to get the complete training history to create from the Nike Run Club app to upload it to the DropBox file storage and sharing service. From the DropBox, I successfully downloaded…

I am now an Oracle ACE Alum

On October 2017, I received an e-mail from the Oracle Corporation with the approval of my application to become an Oracle ACE Associate, being then the first member of the Oracle ACE program in Hungary. The years passed, and I moved from Hungary to Sweden. Thus, on Jun 16, 2020, Oracle corporation upgraded my level from Oracle ACE Associate to Oracle ACE, the 2nd Oracle ACE in Sweden at that moment. For more information about it check it out: https://www.techdatabasket.com/2020/06/17/finally-an-oracle-ace/ The Oracle ACE Program, managed by Jennifer Nicholson and her…

RMAN-06429: TARGET database is not compatible with this version of RMAN

I restored a backup from an older version than the current database version. Therefore, when I tried to use the RMAN utility, I received the following errors: After executing the scripts dbmsrman.sql,dbmsbkrs.sql,prvtrmns.plb and prvtbkrs.plb under the location @$ORACLE_HOME/rdbms/admin/ as the SYS owner, I was able to use the RMAN utility as below:

RMAN: ORA-19910: can not change recovery target incarnation in control file

I tried to reset the incarnation to its previous state when I received the following error below: After some analysis, I acknowledge that the database was OPEN. Therefore, to change the incarnation, I bounced the database, started it in the MOUNT state, and executed the operation to shift the incarnation, so it finished successfully. The evidence of this operation can be seen below:

RMAN : ORA-01145: offline immediate disallowed unless media recovery enabled

I was working on an activity that required me to set some datafile offline when I received the following error: After some analysis, I realized that the database was in no archive mode, and to be able to make a datafile offline, the database must be in archive mode. Therefore, I enabled the archive mode in the database by restarting the database in the MOUNT state, allowing the archive to mode option, and after it was possible to change the status of the database as below:

RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied when Primary and Standby have the same password for the password file

“Opinions expressed are solely my own and do not express the views or opinions of my employer.” I was creating a standby database and had the intention of using an active duplicate to copy the data from the primary database to the standby when I had the following error: I did all the ordinary checklist by checking if the password file on the standby file had the same password as the primary database and also by checking if the “Password file:” option configured on the srvctl “srvctl config database -d…