About

Shadab is currently working as a Senior Solutions Architect in Sydney. He has worked as a Database Consultant and Database Manager for various Banks and Financial institutions.

Shadab on EasyOraDBA, “The purpose of creating this blog was ; to give DBA’s an easy overview of 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.

    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

  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).

  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.

  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!

    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.

  5. Thanks Shadab!
    Would you happen to have any sample shell script which will do that?..My Shell scritping skills are bit rustic…:)

  6. 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

    1. I would use mutiple address list in the tns file. And create a servicd with same name on primary and standby db.

      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)
        )
        )

  7. 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.

  8. 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..

Leave a Reply