Updates from June, 2015 Toggle Comment Threads | Keyboard Shortcuts

  • 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 14:51 on June 25, 2015 Permalink | Reply

    Uninstall all Oracle components using the Oracle Universal Installer (OUI) in Windows 

    • Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products.
    • Delete any references to Oracle services left behind in the following part of the registry:


    It should be pretty obvious which ones relate to Oracle.

    • Reboot your machine.
    • Delete the “C:\Oracle” directory, or whatever directory is your ORACLE_BASE.
    • Delete the “C:\Program Files\Oracle” directory.
    • Empty the contents of your “c:\temp” directory.
    • Empty your recycle bin.
  • 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;

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