Top Reviews

Scenario 1 – Restore control file from backup after loss of all control files

Condition: All copies of the control file have been deleted The data is in the order of files and online redo logs Our control file has backups Database archive works in log mode First we look at where our control files are located SQL> select name from v$controlfile; NAME ——————————————————————————– /u01/app/oracle/oradata/DB11G/control01.ctl /u01/app/oracle/oradata/DB11G/control02.ctl   We then…

Read more

Software’s Accelerating Data Needs May Benefit From Intel’s High-Optane Push

For all of computing’s advances the past few decades, one aspect that’s remained fairly constant is the fundamental relationship among processors, memory chips, and storage, coupled with software designed to route data where it’s most urgently needed. New memory technology that reached the market this year in response to big computing trends could upend this…

Read more

Solving An Unusual Oracle Upgrade Issue

by Jim Okla January 27, 2015 Posted in: How To I recently came across a very unusual situation. During an upgraded review, I noticed the dba_registry_sqlpatch was empty when it shouldn’t be: SQL> select patch_id, patch_uid, version, action, action_time, status, description from dba_registry_sqlpatch; no rows selected SQL> The expected output should be (from another CDB…

Read more


Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment