Re: Oracle DB Took a HIT

Stan,

Please clarify your statement on rebuild.

Do you at least have exports of the system prior to the corruption?

SCott

Stan Novinsky wrote:

> We are running Oracle 7.1 on an Alpha 8400 running OpenVMS 6.2.
> Two days ago, we took a power hit. Although the computer did not
> crash, the DB took a hit.
>
> The DB came up but slow. It is operational and running without a
> problem except taht we found an error in one of log files pertaining
> to a corrupt block. I checked the .TRC files and found the following:
>
> _____
>
> PL/S
> Parallel server mode inactive
> Proc: 0x224 BATCH_1 User: [350,000] ORACLE7 Term:
> Image: APL1SD$DRA4:[ORACLE.V715.RDBMS]SQLDBA.EXE;9
> Enqueue Quota: 4000
> vsnsql=a vsnxtr=3
> cpu ALPH 80000000 vms V6.2 not clustered with 0 nodes
> scsnd: APL1SD , ndname: APL1SD, sys$node APL1SD::
> cpuid 80 rev 044C0000000000000000000C archflg 3C000
> hwmdl: 1100 hwnm: AlphaServer 8400 Model 5/300 cpus: FFFFFFFF cpush: 0
> active: 2, av
> locktbl size 30000 max 65535 resource hash size 2048
> 31-DEC-1999 21:55:51.35:
>
> *** SESSION ID:(6.1)
>
> ***
> Corrupt block=70252ac file=7. blocknum=152236. found during
> media/instance recovery
> on disk type=6. ver=1. dba=70252ac inc=1f9 seq=601 incseq=1f905fc
>
> ***
> Corrupt block=6026e5f file=6. blocknum=159327. found during
> media/instance recovery
> on disk type=6. ver=1. dba=6026e5f inc=3b8 seq=ac incseq=3b800ab
>
> ____________
>
> Is there a way to repair or remove the are with the corrupt block
> other than rebuilding the DB. We are not running archive mode.
>
> Thanks
>
> Stan_Novinsky_at_JHUAPL.EDU
>
>
>

Received on Fri Jul 24 1998 - 16:31:49 CDT