Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How Oracle Restore SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How Oracle Backup SPFILE
In this post, I'm trying to design the best practice to install OPatch. In fact, the procedure means to replace the old OPatch utility with… Read More »How to Install OPatch
Move Data File Online Since 12c, we can move data files online simply by one SQL statement. In other words, we move it by ALTER… Read More »Alter Database Move Datafile