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

corruption

Home » corruption

LGWR terminating instance due to error 338

  • Post author:Amit Bansal
  • Post published:24 December, 2014
  • Post category:10g/11g/12c
  • Post comments:3 Comments

Recently we came across a issue where our DB crashed with ORA-00338 error . Errors in file /oracle/diag/rdbms/orcl11g/orc11g/trace/orc11g_lgwr_24118.trc: ORA-00338: log 2 of thread 1 is more recent than control file…

Continue ReadingLGWR terminating instance due to error 338

11gR2:Oracle Online Patching

  • Post author:Amit Bansal
  • Post published:22 June, 2012
  • Post category:11g
  • Post comments:1 Comment

Online patching is new feature introduced in 11.1.0.6 and oracle started delivering patches with 11.2.0.2. This patch allows you to apply patch to live database i.e we do not need…

Continue Reading11gR2:Oracle Online Patching

Physical Corruption: ORA-1578 part 3

  • Post author:Amit Bansal
  • Post published:21 August, 2010
  • Post category:10g
  • Post comments:3 Comments

Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database files. Saurabh had earlier written articles on ora-1578. http://askdba.org/weblog/2008/04/physical-corruption-ora-1578-part-1/…

Continue ReadingPhysical Corruption: ORA-1578 part 3

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
Copyright - OceanWP Theme by OceanWP