Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Author: Saurabh Sood

This author has written 41 articles
Home » Archives for Saurabh Sood » Page 7

Resolving Shutdown Immediate Hang Situations

  • Post author:Saurabh Sood
  • Post published:26 May, 2008
  • Post category:Featured
  • Post comments:7 Comments

Many times Oracle DBA's are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is…

Continue ReadingResolving Shutdown Immediate Hang Situations

Solving ORA-1031 while connecting as “/ as sysdba” :

  • Post author:Saurabh Sood
  • Post published:24 May, 2008
  • Post category:10g/11g
  • Post comments:18 Comments

Many times we see an issue like this: SQL> conn / as sysdba ERROR: ORA-01031: insufficient privileges This is a very common and frequent error that can occur after the…

Continue ReadingSolving ORA-1031 while connecting as “/ as sysdba” :

Recovering from ORA-1578 ORA-8103 (Logical Corruption)

  • Post author:Saurabh Sood
  • Post published:21 May, 2008
  • Post category:10g/11g
  • Post comments:0 Comments

1. For ORA-1578: There are two ways in which we can extract the data from a corrupted table: a) Using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS b) Using Event 10231 a) Connect as sysdba user:…

Continue ReadingRecovering from ORA-1578 ORA-8103 (Logical Corruption)

Physical Corruption: ORA-1578 PART-2

  • Post author:Saurabh Sood
  • Post published:3 May, 2008
  • Post category:10g/11g
  • Post comments:2 Comments

Recovering from physical corruption: 1. Using BMR when RMAN backups are available When small set of blocks are corrupted, Block Media Recovery (BMR) can be used as a recovery technique.…

Continue ReadingPhysical Corruption: ORA-1578 PART-2

Physical Corruption: ORA-1578 -Part 1

  • Post author:Saurabh Sood
  • Post published:27 April, 2008
  • Post category:10g/11g
  • Post comments:3 Comments

ORA-1578 is indication of physical block corruption. Oracle computes an internal checksum before fetching the block from disk, when it is about to fetch the block it reads the block…

Continue ReadingPhysical Corruption: ORA-1578 -Part 1
  • Go to the previous page
  • 1
  • …
  • 4
  • 5
  • 6
  • 7
Copyright - OceanWP Theme by OceanWP