Tag Archives: raheel

Restore and Recover Table Using RMAN

  While scanning through Oracle Database 12c New Feature guide, one feature that caught my attention Table-Level Recovery from Backups RMAN can restore and recover table or set of tables from existing disk or tape backups using RECOVER TABLE option.   … Continue reading

Posted in 12, RMAN | Tagged , , , , | 4 Comments

Read-only tablespace recovery

I was asked about read-only tablespace recovery scenario in an interview. Interviewer: All current controlfiles are lost and no backup of controlfiles, one of the tablespace is in read-only mode. What do you do after re-creating the controlfile ? In … Continue reading

Posted in Backup and Recovery | Tagged , , , , , | Leave a comment

Backup archivelog to disk – An Oldie

This is long pending post though it’s not unique :), you may get 1 million hit with archivelog to disk keyword on google. However this post is for those who have faced this kind of situation like ME on CRITICAL production … Continue reading

Posted in Archivelog Backup, RMAN | Tagged , , , , , , , | Leave a comment

Fix dbms_scheduler jobs after upgrade

After applying 10.2.0.5.6 patch to 10.2.0.4 on 2 node RAC database, dbms_scheduler jobs were effected and do not run at scheduled start time. MOS Doc ID 727363.1 and 731678.1 helped me understand what caused this and how to fix it, … Continue reading

Posted in RAC, upgrade | Tagged , , , , , , , , , , | 1 Comment