About

I’m currently working as a DBA Team Lead for a large bank in MENA region. I have a degree in Computer Engineering from Mumbai University and previously worked as a Database Consultant for various financial institutions in the region. The purpose of creating this blog was ; to give Oracle DBA’s an easy overview of Oracle Database Administration. Oracle is a complex database which is easy to learn but difficult to master. The posts here work towards simplifying this complex piece of software.

In addition to Oracle databases I devout my time managing SQL Server Databases as well. In my limited spare time i blog about SQL Server as well. You can access that blog on this link >>  Simple SQL DBA.

– Shadab Mohammad, EasyOraDBA

*** All postings here are  my personal opinions, and do not represent those of any of my employers, ex employers or clients. Use the ideas and commands here at your discretion. I am not responsible for any consequences of using these ideas, plans, views or opinions on this blog. ***

*** All the scripts and SQL commands are those which I have rigorously  tested in my test environment before moving to production. The usual discretion applies in using these scripts and commands.Try it in your testing environment before moving it to production. ***

21 thoughts on “About

  1. Hi,
    i nedd shell script which taking all schema exp/expdp backup seprately with there shema name dump file.please help me to create sheel script.

    Like

    1. I don’t think you can do multiple files for multiple schema’s. It will be one file holding multiple schema’s, yes you can have multiple files.You will have to make a script for each schema. Or use FOR loop and hold schema names in a text file and loop expdp command through it.

      #!/bin/ksh
      . $HOME/.profile
      expdate=`date ‘+%d%m%Y’`
      dat=`date ‘+%m%d%y %H:%M:%S’`
      echo “Backup started…” $dat;
      cd /u2/swxexportdump

      expdp system/system directory=export_dir dumpfile=exp_swx_$expdate.dmp logfile=exp_swx_$expdate.log schemas=abc,xyz,mno

      echo “Backup Completed.” $dat;
      gzip /u2/swxexportdump/exp_swx_$expdate.dmp

      Like

  2. Hi Shadab,
    I have a doubt regarding to oracle.Can u please tell me implementation of GoldenGate & Shareplex(replication tools such as SharePlex, Golden Gate).

    Like

  3. hallow Mohammad!!
    what time are you online?i have some questions that i need to ask about Oracle 11g database.i want a clear understanding on the exact syntax of exporting an HT schema,Import the HR dump file into user that u have created,importing a logfile called import for example and then a select statement script on the data dictionary for dropping all indexes under that user u have created.

    Like

  4. Hi,
    I am looking to get some help on getting DG status config in 12C(EM). or may be setup some sort of status check every 4 hours.
    My Env is 11gR2 RAC 4 cluster with standby and DR on Linux.
    Any suggestion will be great!

    Like

    1. I dont know how would you do that in 12c Cloud Control. But what i do is write shell scripts and based on that generate sms alerts. You can query v$managed_standby for status of process MRP0 as “APPLYING_LOG” and based on that you can work out your monitoring mechanism.

      Like

  5. I found your TAF info very helpful. I set it up in 12c RAC with pdbs. No changes to the tns entries just changes to the service with srvctl:
    srvctl modify service -d cdbrac -s testpdbs -tafpolicy BASIC
    -failovertype SELECT -failovermethod BASIC
    -failoverretry 180 -failoverdelay 5 -notification TRUE

    Queston I have now though.. is there a way to have it go to your standby if the preferred or available instances are down? I see a backup option on the tns entry of failover_mode but I’m not sure if that will check the preferred instances first prior to trying the standby..Also I don’t see the backup parameter as part of the service in the cluster

    Like

      1. Thanks for that idea. It think it worked. Since there are two nodes and each contain a primary and a standby instance I can’t be sure it used the second address entry. SInce both sqlplus sessions were rerouted to node 1 instead of as before split across I think it did use the second entry pointing specifically to node 1 instead of the scan address.

        TESTPDBSF =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = i-scan)(PORT = 1248))
        (ADDRESS = (PROTOCOL = TCP)(HOST = i-rhrlab)(PORT = 1521))
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = testpdbs)
        )
        )

        Like

  6. That is exactly how i would do it. The service name ‘testpdbs’ will be created on both sides as primary service. Once you do a switchover bring up the service in standby site and your apps should automatically connect to the standby site.

    Like

  7. I made some adjustments:

    TESTPDBSF =
    (DESCRIPTION =
    (ADDRESS_LIST=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS = (PROTOCOL = TCP)(HOST = i-scan)(PORT = 1248))
    (ADDRESS = (PROTOCOL = TCP)(HOST = i-rhrlab)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = testpdbs)
    )
    )

    turned off the scan listeners . I Shutdown the primary db and the sqlplus sessions switched over to the standby which was open read only. It works..

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s