AskDba.org Weblog

Writing About Our Experiences With Oracle Databases

buy zithromax online; buy lexapro online

Tuesday May 22nd 2012

Latest Topics

Using current_scn for RMAN incremental ? Think again..

I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby [Read More]

Poll on Sql Plan Management

Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM [Read More]

Oracle Direct connector for HDFS

Some time back oracle had announced Oracle Big Data appliance. Along with this Oracle released Big Data Connectors to [Read More]

ORA-7445 core dump [kokscold()+849] from EM 12c

The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact [Read More]

Copying Oracle Scheduler jobs with Arguments

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that [Read More]

Posts Tagged ‘corruption’

Physical Corruption: ORA-1578 part 3

21 Aug, 2010 | Author: Amit | 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/ [Read More]

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

21 May, 2008 | Author: Saurabh Sood | No 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: execute [Read More]

Physical Corruption: ORA-1578 PART-2

03 May, 2008 | Author: Saurabh Sood | 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. The advantage of BMR is that it can be performed without taking the datafiles offline [Read More]

Physical Corruption: ORA-1578 -Part 1

27 Apr, 2008 | Author: Saurabh Sood | 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 header and compare the checksum stored in it. If the checksum mismatches we get ora-1578 [Read More]