The AWS Certified Database – Specialty (DBS-C01) y exam has been on my bucket list for a few months. I tried it for the first time on Aug 09, 2022, and I failed. Although I considered that I was not that bad at all, I scored 681, where the minimum passing score is 750: The approach that I took for my first attempt was to buy some courses about the certification at Udemy, which I will no longer share the courses here not to do free merchandising 🙂 , and…
Month: March 2023
Enabling Active Data Guard in Physical Standby Database
Active Data Guard is the option when the standby database is configured to be in its status open with read-only mode. As explained below in the white paper “Oracle (Active) Data Guard 19c Real-Time Data Protection and Availability,” there are some benefits, dated March 2019: With this in mind, the current post is about enabling your Physical Standby database as an Active Data Guard. Taking as a primary step that you already have a configured Physical Standby database, this post follows the procedures below: All these steps mentioned above, except…
Index WRH$_SYSMETRIC_HISTORY_INDEX Status Unusable After Database Upgrade From 12c To 19c
Upgrading Oracle database 12.2 to 19.10 came with some surprises, and one of them was the invalid status of the index WRH$_SYSMETRIC_HISTORY_INDEX owned by the user SYS. Rebuilding the index helped only temporarily, so I decided to recreate the index by following the procedure below: — Confirmation of the invalid index: — Action plan: For more information, please check the following MOS notes below: Index WRH$_SYSMETRIC_HISTORY_INDEX Status Unusable (Doc ID 2426391.1)WRH$_SYSMETRIC_HISTORY_INDEX Index Does Not Get Partitioned After Database Upgrade From 12c To 19c (Doc ID 2777641.1)Index WRH$_SYSMETRIC_HISTORY_INDEX Status Unusable (Doc…
Enabling SPOOL output using RMAN
I had a performance problem in one of the routine backups, so I opened a Service Request (SR) at MOS (My Oracle Support). After a few hours from the moment I opened the SR, I got a request to upload the output of a few commands. Therefore, I used a SPOOL output to create it. For those unfamiliar with how to create a SPOOL output in the RMAN utility, follow below how you can accomplish this task: brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer…
Bug ORA-38881 during “drop tablespace” even though there is NO Guaranteed Restore Point (GRP) – Fixed in version 19.17
I just upgraded one Oracle Database system from 12.2 to 19.10. I was happy with the result until one database procedure started to fail with the message “ORA-38881: Kan inte radera tabellutrymmet TECH_29102_9292 i den primära databasen pga. garanterade återställningspunkter.” . For those unfamiliar with the Swedish language, this is the same error message as “Oracle Error ORA-38881: Cannot drop tablespace string on primary database due to guaranteed restore points.”. I started doing some investigation until I found that there is a BUG:14163359 fixed on version 19.17 of the Oracle databases. And…
Rebuilding Oracle Partitioned Index- Solving “ORA-14086: a partitioned index may not be rebuilt as a whole”
It is known that Oracle has two types of partitioned Indexes: Local and Global Partitioned Index. I will only cover some of the specifications that explain their differences. However, according to the VLDB and Partitioning Guide release 21c, “Partitioning is possible on both regular (heap organized) tables and index-organized tables, except for those containing LONG or LONG RAW columns. You can create nonpartitioned global indexes, range or hash partitioned global indexes, and local indexes on partitioned tables.”. Furthermore, while creating a local index, the database constructs the index, which is…
Oracle Certified Master Exam Updates – March 2023
It has been a while since I aimed to be an Oracle Certified Master (OCM). For those unfamiliar with this exam, it is (or was) an Oracle practical exam that consisted of two days somewhere in the world. It would test your Oracle skills to achieve the master’s and top certification from Oracle. It is a certification that gives prestige and recognization because a minority number of database administrators have this credential, and all because of all the value invested in the courses as prerequisites and other expenses. From the…