Suddenly our support guys found some archivelog backups were not deleted even they were not needed b...
Archivelog backups were not removed per backup policy
Read More...
Talking about ‘recovery window of 7 days’
Sometimes we will keep the database backup for one week and set the retention policy to 'recovery wi...
ORA-27102 out of memory on a system with huge memory
Today one customer said the data sync of Oracle Dataguard had issue and our guys checked the alert l...
Maybe a dangerous configuration of ASM diskgroup with Normal Redundancy
These days my friend Zhiguo discussed with me about the vote disk issue of Normal Redundancy ASM dis...
Key points for Oracle RAC patching
Several weeks ago I patched a 12.2 Oracle RAC and got several issues, I realized there were some key...
VirtualBox VM caused system hung after laptop upgrade
In last week I upgraded my laptop from T420s to E485 to get maximum 32G memory also because the T420...
How to restore a database with hot backup and without resetlogs?
Normally when we restore the hot backup of a database, we will recover and open it with resetlogs op...
ACFS-9459 & ACFS on Oracle 11.2.0.4 and RHEL7.4
Sometimes, when I installed the Oracle GI and run the asmca, I could create volume and acfs easily, ...
Patch Set Update 11.2.0.4.190115 will not be installed on the GI home using opatch auto
First of all, let me show you the installation log: Perfect! Right? No any error, and even the messa...
OracleWonderful SQL format tool — SQL Pretty Printer
I tried to find a perfect SQL format tool for a long long time, while all the attempts failed until ...
