Updates from May, 2016 Toggle Comment Threads | Keyboard Shortcuts

  • Sachin Thapa 13:53 on May 28, 2016 Permalink | Reply
    Tags: document, , pdf, , rac installation,   

    RAC Installation Step by Step 

    Hi All,

    Please find the below link for RAC installation document for reference.

    (More …)

  • Sachin Thapa 15:00 on April 12, 2016 Permalink | Reply
    Tags: , , , index, indexes, , rebuild   

    Know when to rebuild indexes 


    An Oracle server index is a schema object that can speed up the retrieval of rows by using a pointer.

    You can create indexes on one or more columns of a table to speed SQL statement execution on that table. If you do not have an index on the column, then a full table scan occurs.

    (More …)

  • Sachin Thapa 10:23 on February 26, 2016 Permalink | Reply  

    How to bounce apache and clear cache in oracle apps 11i on sunsolaris operating system? 

    Go to scripts location.

    cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

    apptest@sachin $ adapcctl.sh stop ; m (More …)

  • Sachin Thapa 08:05 on February 7, 2016 Permalink | Reply  

    RAC related queries. 

    Hi All,

    I have been getting a lot of RAC related queries in my inbox, unfortunately i don’t access my blog inbox daily kindly shoot all your RAC related queries and requests for any contents..  @ ashkid0510@gmail.com.

    New Documents available:
    RAC installation step by step with screens..
    OCR and Voting Disk administration
    Adding and Deleting Nodes.
    Creating RAC Database Manually.
    RAC to non RAC and vice versa cloning

    Happy learning 🙂


  • Sachin Thapa 19:44 on August 12, 2015 Permalink | Reply
    Tags: , , , datafile is missing, ,   

    Full restore via RMAN of a database when a datafile is missing and never backed up !! 

    Problem Description

    Full restore via RMAN of a database when a datafile is missing and never
    backed up results in the following errors:

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command

    (More …)

  • K.T.Chowdary 14:58 on June 25, 2015 Permalink | Reply

    Types of Checkpoint in Oracle 

    Checkpoint types can be divided as INCREMENTAL and COMPLETE.

    Also COMPLETE CHECKPOINT can be divided further into

    In Incremental Checkpoint,checkpoint information is written to the
    controlfile. In the following cases:

    1.Every three second.
    2. At the time of log switch – Sometimes log switches may trigger a complete checkpoint , if the next log where the log switch is to take place is Active.

    In complete Checkpoint,checkpoint information is written
    in controlfile,datafile header and also dirty block is
    written by DBWR to the datafiles.

    Full Checkpoint

    2.Before Clean Shutdown
    3.Some log switches may trigger a complete checkpoint , if the next log where the log switch is to take place is Active.
    This has more chance of happenning when the Redo Log files are small in size and continuous transactions are taking place.
    4.when the ‘alter system checkpoint’ command is issued

    Partial Checkpoint happens in the following cases.

    1.before begin backup.
    2.before tablespace offline.
    3.before placing tablespace in read only.
    4.Before dropping tablespace.
    5.before taking datafile offline.
    6.When checpoint queue exceeds its threshold.
    7.before segment is dropped.
    8.Before adding and removing columns from table.

  • K.T.Chowdary 13:29 on June 11, 2015 Permalink | Reply

    RMAN (Recovery Manger) 

    Important points about RMAN

    • Rman is centralized backup restore and recovery utility across the enterprise database.
    • If we configure rman there will be minimal dba intervention during restore and recovery
    • We can configure rman in 2 modes.
    • No catalog mode
    • Catalog mode (More …)
  • K.T.Chowdary 13:25 on June 11, 2015 Permalink | Reply

    How to identify and recover from block corruption in RMAN? 

    First check whether the block is corrupted or not by using this command
    sql>select file# block# from v$database_block_corruption;

    file# block
    2 507

    the above block is corrupted…

    conn to Rman

    To recover the block use this command…

    Rman>blockrecover dataile 2 block 507;

    the above command recover the block 507

    Now just verify it…..

    Rman>blockrecover corruption list;

  • Sachin Thapa 16:53 on May 9, 2015 Permalink | Reply
    Tags: , ,   

    Internal processing of an execute query 

    Step 1: oracle create a cursor
    for every sql, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor).
    step 2: oracle parse sql statement
    a sql statement is parsed only if an identical sql statement does not exist in the library cache (shared pool-system global area). In this case, a new shared sql area is allocated and the statement is parsed (hard parse), otherwise existing stored information in library cache is used (soft parse).

    (More …)

  • Sachin Thapa 17:13 on February 13, 2015 Permalink | Reply
    Tags: , ,   

    GoldenGate – Installation (Oracle 11g on Linux) 

    This example will illustrate the installation of Oracle GoldenGate on an RHEL 5 platform. We had in an earlier post discussed the architecture and various components of a GoldenGate environment.

    GoldenGate software is also available on OTN but for our platform we need to download the required software from the Oracle E delivery Website

    Select the Product Pack “Oracle Fusion Middleware” and the platform Linux X86-64.

    Then select “Oracle GoldenGate on Oracle Media Pack for Linux x86-64″ and since we are installing this for an Oracle 11g database, we download “Oracle GoldenGate V10.4.0.x for Oracle 11g 64bit on RedHat 5.0″

    (More …)

Compose new post
Next post/Next comment
Previous post/Previous comment
Show/Hide comments
Go to top
Go to login
Show/Hide help
shift + esc