Author Archives: Sher khan

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email:

How to change the file extension using cmd script

To change the files extension in once using script its very easy. I need to change the multiple files extension , it was difficult to change one by one. So I created a script to change at once and reuse … Continue reading

Image | Posted on | Leave a comment

Upload data using sql loader

Make a batch file suppose load_data.bat –content of the file is –you keep the batch and controlfile in the same folder where the datafiles are there. –This script will upload all data files within the same folder whatever fortmat they … Continue reading

Posted in Uncategorized | Leave a comment

RMAN Backup On Remote Machine Disk On Windows

Objective How to take backups on shared disk of another machine on windows machine.. Steps are following Follow the below steps to take backups on remote disk : + Suppose I have a target database on Machine A and the remote … Continue reading

Posted in rman | Leave a comment

Find a session which are generating more archive logs

To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. The methods are: 1) Query … Continue reading

Posted in Performance and Tuning, scripts | 1 Comment


  ROBLEM: ARCHIVE process get hang on Primary Database ——– The problem has been that the standby hardware have some faulty backpane. This has caused processes in the standby to go into what is called as “D” state where the … Continue reading

Posted in Oracle DataGaurd | Leave a comment

Stop and Start Recover managed Standby Database

  To start Redo Apply in the foreground, issue the following SQL statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;   To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement   SQL> ALTER DATABASE … Continue reading

Posted in Oracle DataGaurd | Leave a comment

Oracle EBS 11i Installation logs

Oracle Applications Rapid Install Wizard Install log >> Using Rapid Wizard Version : >> Install session started : Thu Apr 24 08:52:41 EDT 2014 >> Rapid Wizard source location : /u01/Stage/Stage11i/startCD/Disk1/rapidwiz >> Command Line arguments for this execution : … Continue reading

Posted in Uncategorized | Leave a comment