Re: Block Corruptions on Oracle and UNIX

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 3 Nov 2005 09:51:55 -0800
Message-ID: <1131040315.529356.75110@o13g2000cwo.googlegroups.com>

# g3000 wrote:
# >
# > Dont understand why Oracle offers RAC on 10G Standard but NO block

#> level media recovery?
#> Also no incremental backups. Makes no sense.

You may understand already but if you start using RMAN consistently at 9i and upwards oracle does a pretty good job of detecting and allowing you to fix any block errors.

Any RMAN backups that experience a bad block will fail ( unless you override the number of errors you are willing to tolerate ). You can run RMAN to verify backups and also to check for invalid blocks without taking a backup. If block problems are noted oracle will populate a table/view and you can run an RMAN command to fix those blocks without taking anything offline/etc.

At least all of these features are available in enterprise not sure if any of these features are compromised ( don't think so but could be wrong ) in Standard.

Robert Freeman has an excellent RMAN book that you should get plus of course all the oracle doc is actually pretty good in this area. Received on Thu Nov 03 2005 - 11:51:55 CST