Don’t use %NOTFOUND with BULK COLLECT

I was working on a script for the ultimate RMAN backup validation and hoping to submit the article for an Oracle conference.

To my chagrin, one version of the script was failing for one condition and the other version would failed for another condition.

Basically, the script was very buggy.

The objective is to create a RMAN script to validate 8 backupset at a time.

I decided to use Bulk Collect and Limit clause.

Currently (more...)

Automating DataPump Export

Please click link here to read my blog at Pythian.


My Notes on How to Deploy a Four-Node Oracle RAC 12c Cluster

Great post from Oracle on How to Deploy a Four-Node Oracle RAC 12c Cluster in Minutes.

Just a few notes to for me to remember and share.

From the section:

Import the Oracle VM Templates You Downloaded

4.  From the Oracle VM Manager GUI, import the template files by providing both URLs for the same import session. The import process will take several minutes; be patient.

I used the URL below:

http://192.168.56.3/Files/OVM_OL6U4_X86_64_12101DBRAC_PVM-1of2. (more...)

Is that database user really read only?

So there I was, working on a request to determine if users in the database are read only or read write. Sounds pretty simple, right?

Someone once said, “Good artists copy, great artists steal.” In my case, there was nothing to steal.

Basically, there are system, role, table, and (more...)

Cloning Database without ASM

So there I was, working on a project to duplicate a database from a volume copy at the storage level with the database being shutdown.

Sounds pretty simple right? Wrong! Put the database on ASM and it becomes complicated and convoluted.

Volume1 has ASM disk group in the fashion +DG1/db01/datafile, +DG1/db01/onlinelog +DG1/db01/tempfile

(more...)

Happy Thanksgiving

So there I was, one Thanksgiving I came across Randy Pausch’s Last Lecture and wanted to share with you.


Playing with ASM Online Migration

“Everything should be made as simple as possible, but not simpler.” – Albert Einstein

I am curious as to why anyone would use ASM for a standalone database as it introduce more complexity of having to install, maintain, and upgrade Grid Infrastructure.

I asked the DBAs and here are (more...)

5 C’s for Career Change

I have shared this with a few friends and colleagues here and there and thought I would blog about them.

Challenge – bored to death is not a good way to die.

Commute – driving 2 hours to work in traffic kills a lot of time.

Compensation – total compensation (more...)

What’s RMAN Backup Size

So there I was, looking for a script to calculate the backup size.  After several thoughts, it was not exactly what I was looking for.

Here’s the one I created.

SELECT TO_CHAR(completion_time, 'YYYY-MON-DD') completion_time, type, round(sum(bytes)/1048576) MB, round(sum(elapsed_seconds)/60) min
FROM 
(
SELECT 
  CASE
    WHEN s.backup_type='L' THEN 'ARCHIVELOG' 
    WHEN s. (more...)

Playing with Oracle Free Block Corruption

First and foremost, thank you to all the bloggers sharing their knowledge.

My previous post on corruption is here
The corrupt.sql script was stolen from here
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(35) was stolen from here

Free Block Corruption is from a data file block which is now Free but used (more...)