Recently, I undertook the task of upgrading an Oracle database from version 19.10 to 19.18. As the process progressed, I began to encounter a series of errors that were consistently appearing in the alert log. After diving deep into the issue, it was discovered that running a series of scripts after the upgrade would effectively solve the problem. Furthermore, it was necessary to recompile the invalid packages. Without any delay, I proceeded to execute the specified scripts and recompile the invalid objects. And voila, problem solved! I hope this post…
Day: May 29, 2023
Enable online status for all Oracle database datafiles
I have executed a database migration by transitioning from a physical active data guard to a primary database. Subsequent to the migration, I observed that several data files were offline, as evidenced below: Modifying the status of each individual data file would require a substantial amount of time. To provide an illustrative example: In order to streamline the operation, I devised a PL/SQL procedure that effectively places all data files offline across all tablespaces within the database, subsequently modifying their statuses to online, as illustrated below: I hope this post…