of course you had better be certain you don’t need the archivelog BEFORE you remove it, you can put it back if you have a copy – you would just have to do another rman crosscheck (see below) to tell rman it is back Archivelog sub-directories are typically of the form: YYYY_MM_DD and contain archivelog. …
removing old un-necessary archivelog from fast_recovery_area Read More »
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;}
Nice little article on how to restore from DDBoost with no catalog and a lost control file. Key is to have the DBID and the RMAN backup logs – so that you can find a backup of the control file from DDBoost. So make sure you have both the RMAN logs, and DBID – copies …
Recovering DDBoost & Oracle RMAN with no catalog or control file Read More »
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 …
create or replace trigger sys.after_startup after startup on database begin execute immediate ‘alter pluggable database all open’; end after_startup; /
This one is powerful enough that I would just like to reference Jeff Smith’s post on the subject: Generating User DDL in SQLcl
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 »
# Yes there are lots of ways to turn on trace an the session level – here is the one I use the most # to get my current SID, SERIAL SQL> select sid, serial# from v$session where audsid = userenv(‘SESSIONID’); # Now give my session a prefix I can find SQL> ALTER SESSION SET …
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 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 »