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…
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…
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:…
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.…
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…
- Go to the previous page
- 1
- …
- 4
- 5
- 6
- 7