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

Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments

  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
  • Natarajan Gounder on Creating ASM devices on AIX

Trending

  • Resolving Shutdown Immediate Hang Situations
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • MGMTDB: Grid Infrastructure Management Repository
  • User Sessions stuck on resmgr:cpu quantum wait event
  • Using SSL to securely connect to Amazon Redshift Cluster
  • TNS file functionality for PostgreSQL
  • Simplified Approach to Resolve ORA-4031

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers

Copyright - OceanWP Theme by OceanWP