12c

Oracle RMAN restore & recover until – assuming you don’t have redo or just want to recover to an earlier point

assuming you have the control FILE and after a “startup mount;” using the controlfile to restore/RECOVERABLE rman target /restore database UNTIL TIME“to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”; recover database UNTIL TIME“to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”; alter database open resetlogs; OR run{set UNTIL TIME “to_date(’12/31/2021 11:34:50 am’,’mm/dd/yyyy hh:mi:ss am’)”;restore database;recover database;alter database open resetlogs;}

Oracle 11gR2 and 12c etc. – Create a script that will help recreate a controlfile – using: alter database backup controlfile to trace;

The “alter database backup controlfile to trace;” will create a text based file – human readable – that contains the steps necessary to recreate an Oracle controlfile for a specific database (the database you were connected to when you issue the alter command). See Oracle’s documentation on how to use this file. It actually has …

Oracle 11gR2 and 12c etc. – Create a script that will help recreate a controlfile – using: alter database backup controlfile to trace; Read More »

Oracle Does NOT "Get" How to Grow Their Own Cloud Business – And They Should

Oracle Does NOT “Get” How to Grow Their Own Cloud Business – And They Should… While Oracle claims a significant growth rate in Oracle Cloud use, they are not growing to keep pace with the competition. This blog will not address the statistics, the current market break down but, clearly Amazon, Google, and Azure/Microsoft are …

Oracle Does NOT "Get" How to Grow Their Own Cloud Business – And They Should Read More »

Methods To Analyze Performance and Debug Oracle SQL and PL/SQL

Just a categorized list of Oracle performance tools at this stage… Oracle Enterprise Manager – OEM Tools – OEM 12 and forward AWR Reports – Historical Windows ASH Reports – Real Time SQL Advisor SQL Profiler – uses active or historical GUI Explain Plan Top Active SQL – under performance tab and then the grandfather …

Methods To Analyze Performance and Debug Oracle SQL and PL/SQL Read More »

Oracle 18c and forward RU (Release Updates) versus RUR (Release Update Revisions)

Oracle 18c RU (Release Updates) versus RUR (Release Update Revisions) Generally my understanding is RUs will contain the most current bug fixes and security updates. RURs lag behind RUs in regression bug fixes (at least one quarter – I’m verifying the exact lag time), but do contain current security fixes – applying RURs could be …

Oracle 18c and forward RU (Release Updates) versus RUR (Release Update Revisions) Read More »