Skip to content

AskDba.org Weblog

  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Author: Saurabh Sood

Worked with prestigious Financial Institutions and Product Based MNCs e.g. Swiss Bank (UBS), CitiBank, Qatar Central Bank (QCB), Societe Generale, Oracle Corporation & Dell. An Oracle DBA who is up-skilling himself to help large enterprises move their data to cloud and get more insights into data to make it useful for them.
Saurabh Sood

26 May, 2008

Resolving Shutdown Immediate Hang Situations

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…

Read Full Recipe
969 views 7:22 pm 7 Comments
Saurabh Sood

24 May, 2008

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

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…

Read Full Recipe
212 views 11:42 am 18 Comments
Saurabh Sood

21 May, 2008

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

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:…

Read Full Recipe
91 views 7:07 pm 0 Comments
Saurabh Sood

3 May, 2008

Physical Corruption: ORA-1578 PART-2

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

Read Full Recipe
48 views 7:47 am 2 Comments
Saurabh Sood

27 April, 2008

Physical Corruption: ORA-1578 -Part 1

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…

Read Full Recipe
96 views 4:26 am 3 Comments

Posts navigation

Newer posts
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
  • Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
  • 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” :
Trending
  • Resolving Shutdown Immediate Hang Situations
  • Recreating Database Link
  • Limiting I/O and CPU resources using 11g Oracle Resource Manager
  • Connections to DataBase Hang Including "/ as sysdba"
  • 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
Proudly powered by WordPress | Tech Blog WordPress Theme by TheMagnifico
TOP