Re: ORACLE data block corrupted

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Mon, 02 Apr 2001 10:32:29 +0800
Message-ID: <74ofctkitftdbhnqhpfonk17eikradlm1i@4ax.com>

On Sat, 31 Mar 2001 14:42:39 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>Datablock corrupted means there is an error on your disk.
>For now: you were lucky it is a rollback tablespace.
>Create an extra rollback segment in the tablespace system, drop the rollback
>tablespace, bringing the other rollback segments offline first of course,
>shutdown the database and make a backup (with verify!)

                                                         ^^^^^^

>Now remove the affected file
>Now check the disk
>If all is OK the bad spot doesn't belong to any file.
>Bring up the database and recreate your tablespace.
>And yes of course you will need to run upgrade scripts.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>

Sybrand & Howard,

I appreciate your help very much because they are very helpful. I would especially appreciate your in-time correction when I forgot something I have learned in the DBA 1A class. The recovery part is really a challenge to me.

Here I have one more question:
Can you tell me the exact meaning about a backup with verify? I know some backup procedures, but I am not sure which is the one you mean:

1.export with exp80.exe
2.ArcServe with Oracle Option
3.Recover Manager

I like exp80.exe because it can be run when the database is open, and we have more control on the objects we backup, but it seems you don't mean exp80.exe.

Regards,
Dino Received on Sun Apr 01 2001 - 21:32:29 CDT