A lock is a mechanism that prevents destructive interactions. Interactions are destructive when they incorrectly update data or incorrectly alter underlying data structures, between transactions accessing shared data. Locks play a crucial role in maintaining database concurrency and consistency. Summary of Locking Behavior The database maintains several different types of locks, depending on the operation … Read more
Problem:While patching 19.3 GRID_HOME with July2019 RU patch 19.4 I got this error: Solution:The problem was with the RU patch binaries, looks the files were not copied properly, extracting the binaries properly from the zip file has fixed the problem!Initially, copied the “extracted” RU binary files from another node, seems they were incomplete.
Instance recovery is the process of applying records in the online redo log to data files to reconstruct changes made after the most recent checkpoint. Instance recovery occurs automatically when an administrator attempts to open a database that was previously shut down inconsistently. Purpose of Instance Recovery Instance recovery ensures that the database is in … Read more