Oracle - Bloques corruptos

 
Vista:

Bloques corruptos

Publicado por Rocky (1 intervención) el 19/09/2005 13:43:14
Este es un spool del fichero .log. Me dice que hay bloques corrupos y no se que puedo hacer. Lo apagaron cuando estaba trabajando

Windows NT V5.1, OS V10.40, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 100
shared_pool_size = 16000000
control_files = d:\orant\database\ctl1C004.ora, d:\orant\database\ctl2C004.ora
db_block_buffers = 550
db_block_size = 16384
compatible = 8.0.5.0.0
log_buffer = 32768
log_checkpoint_interval = 8000
log_checkpoint_timeout = 0
db_files = 1020
db_file_multiblock_read_count= 16
dml_locks = 200
sequence_cache_entries = 30
sequence_cache_hash_buckets= 23
remote_login_passwordfile= SHARED
sort_area_size = 65536
db_name = CR1004
background_dump_dest = d:\orant\rdbms80\trace
user_dump_dest = d:\orant\rdbms80\trace
max_dump_file_size = 10240
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Sep 19 12:41:16 2005
alter database "cr1004" mount exclusive
***
Corrupt block relative dba: 0x00000003 file=0. blocknum=3.
Fractured block found during controlfile block read
Data in bad block - type:21. format:2. rdba:0x00000003
last change scn:0xffff.00003e1e seq:0x1 flg:0x04
consistancy value in tail 0x00000000
check value in block header: 0x605b, calculated check value: 0xc4f6
spare1:0x0, spare2:0x0, spare2:0x0
LGWR: terminating instance due to error 227
Instance terminated by LGWR, pid = 1944
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder