Skip to content

Blocks

Protecting an Oracle database from block corruption

Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.

This posting will present this parameter and some tests to measure its impact on the database.

RMAN backup is failing due to “corrupt blocks”

Last week, I was not able to complete a backup because of the ORA-19566 error: “exceeded limit of 0 corrupt blocks”. Here is what you can do to fix it. Starting Point: backup error Here is the starting point of this case. The following error is found in the RMAN Backup log file: allocated channel: ch1 channel ch1: sid=25 devtype=DISK… 

Oracle Basics (2) – Data Storage

What is finally the primary objective of a database? Storing Data Laughing
The question is, how Oracle makes it. For many beginners a confusing topic is
to get the picture between physical storage and logical one. So how does it works?