Thursday Jan 17, 2013

Potential check for corruptions

Having a corruption somewhere in the database is one of the worst case scenarios I could ever imagine - especially if it "sleeps" somewhere in the data dictionary. Recently I did talk to a customer who encountered a failing upgrade due to a data dictionary corruption gotten introduced in an earlier release.

What can you do to check your database(s) prior to an upgrade or generally from time to time? Actually I know now two powerful possibilities: 

  • hcheck.sql
    See MOS Note:136697.1
    This script will check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g.
    You will need to create
    hOut Helper Package first - please see MOS Note:101468.1 to download the script hout.sql
  • RMAN validation:
    RMAN> backup check logical validate database;
    See MOS Note:836658.1 for further details - and you can run this with multiple parallel channels to speed up the run

About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers