Archive for July, 2012

Creation of Packages & ZIP files to send to Oracle Support using ADRCI

For instance, we found problem in Database with Problem ID 1.

adrci> show problem

ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME                             
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1                    ORA 7445 [qcstda()+702]                                     6201                 2011-06-01 10:22:08.924000 +02:00       
1 rows fetched

Now, if you can't solve this problem on your own and you need to claim support from Oracle. You can gather all the required information with a method called “Incident Packaging Service” (IPS).

adrci> ips create package problem 1 correlate all
Created package 2 based on problem id 1, correlation level all

This did not yet create a ZIP file and is therefore referred to as “Logical Package”. The ZIP file is generated from the Logical Package that was created.

adrci> ips generate package 2 in "/home/oracle"  
Generated package 2 in file /home/oracle/, mode complete

A Rahim Khan

expdp/impdp version issue

First of all, there is nothing to do with Version parameter while using impdp. However, you can mention version while taking logical backup using expdp.

You have to use Version Parameter with expdp if want to import this logical backup in a Lower/Down Version. For instance, Your Production Database is 11g R2 ,Test Database is 11g R1 and you want restore logical backup on 11g r1 taken from 11 g r2 Server. In this kind of scenario you need to use Version Parameter while using expdp as shown below.

expdp system/****** schemas=hr directory=backup_dir dumpfile=hr18072012.dmp logfile=hr18072012.log Version=11.1.0

A Rahim Khan

Oracle Database Cold Backup Script

Execute this bash script, it will do the rest of your Database Cold Backup.

/oracle/app/product/10.2.0/db_1/bin/sqlplus /nolog <<EOF
conn /as sysdba

Continue reading

analyze redo/archive using logminer

First of all, query on V$DATABASE to check out if SUPPLEMENTAL_LOG_DATA_MIN is YES OR NO.


You can use this following query to alter SUPPLEMENTAL_LOG_DATA_MIN flag.


Continue reading