How To Reclaim ASM Disks
The project I have been working on is migrating GoldenGate trails from DBFS and ACFS. Now that the...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Michael Dinh (4)
Why It's Good Practice to Run Datapatch -prereq after Creating Database
Starting with 12c, running datapatch may be required after creating a database, depending on the...
How to delete an RAC Database Using DBCA silent mode
I was recently working on a Proof Of Concept to migrate RAC non-CDB to CDB. I faced multiple issues...
How to Find Cluster Resources Where Target!=State
DBA typically checks cluster resources as part of patching efforts. However, when checking cluster...
How To Resize Oracle ACFS Volume
There may be many reasons as to why Oracle ACFS volume would need to be resized. Current Filesystem...
Using rsync to Copy GoldenGate Trails from DBFS to ACFS
I am currently working on project to migrate GoldenGate trail from Oracle Database File System...
How to mine an RMAN Log
I wanted to compare Oracle Recovery Manager (RMAN) backup to an existing NFS versus a NEW backup...
A script for Relocating and Restoring Database Services
Due to complex requirements for service relocate and restore as part of patching, I decided to...
Troubleshooting failed database startup after GRID Out Of Place (OOP) rollback
GRID Out Of Place (OOP) patching completed successfully for 18.6.0.0.0....
How to remove grid 12.2 after an 18c upgrade
The environment started with a GRID 12.1.0.1 installation, upgraded to 18.3.0.0, and performed...
