Recovery – (How to recover corrupted data blocks using ‘recover datafile’ RMAN syntax on a system critical datafile)

As we know that SYSTEM – stores the data dictionary.  Being an Oracle DBA we all know the importance of SYSTEM tablespace.  In these below lines, we can have actual technical knowledge about system’s information. SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata […]

Read More

Recovery – (How to recover a never backed up tablespace after losing its datafile and even the current controlfile after the autobackup feature completes its job)

In this post, we are going to learn steps which are use recover a never backed up tablespace after losing its datafile and even the current controlfile after the autobackup feature completes its job. This crash involves the lost of the “never backed up” tablespace and of the current controlfile. Let’s start with an example. Our […]

Read More

Recovery -(How to recover a never backed up tablespace after losing its datafile and even the current controlfile but before the autobackup feature completes its job)

  This post is about the steps which are used to recover a never backed up tablespace after losing its datafile and even the current controlfile but before the autobackup feature completes its job. The question is: what does it happen if you lose your new tablespace before your nightly backup script is successfully executed? Think […]

Read More

Oracle Licenses

Despite reams of legalese and countless blog/forum posts, basic Oracle RDBMS licensing still remains a mystery to many. While I won’t even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs. Editions The first and most important […]

Read More

Using the Remote Diagnostic Agent (RDA)

The Remote Diagnostic Agent (RDA) is an Oracle-provided diagnostic tool that captures data about your database environment and packages it into a web page report. When submitting a Service Request to Oracle Support, you will often be asked to run the Remote Diagnostic Agent (RDA) and upload the results.  This allows the support analyst to review […]

Read More

Methods for viewing SQL Execution Plans

Using Autotrace SQL> set autotrace traceonly explain SQL> select ename from emp where sal > 500; Execution Plan ———————————————————- Plan hash value: 2872589290 ————————————————————————- | Id | Operation | Name | Rows | Bytes |Cost (%CPU)| Time | ————————————————————————- | 0 | SELECT STATEMENT | | 1 | 25 | 2 (0)| 00:00:01 | |* […]

Read More

Quiescing a Oracle Database

There are times when a DBA needs to perform work on the database that requires no other ACTIVE sessions. This is very common is development databases, where a DBA tries to run a package or a modify a table when the application is till running. There are also frequent occurrences where too much IT support […]

Read More